Prompts

Prompts

Prompts provide guided AI workflows for complex database tasks. Instead of figuring out which tools to use and in what order, simply invoke a prompt and follow its step-by-step guidance.

---

Available Prompts (19 total)

Core Prompts

Prompt	Description
mysql_query_builder	Construct SQL queries with security best practices
mysql_schema_design	Design table schemas with indexes and relationships
mysql_performance_analysis	Analyze slow queries with optimization recommendations
mysql_migration	Generate migration scripts with rollback options

Lazy Hydration Prompts

Prompt	Description
mysql_tool_index	Show all available tools organized by category
mysql_quick_query	Shortcut for running queries
mysql_quick_schema	Shortcut for exploring database schema

Health & Operations

Prompt	Description
mysql_database_health_check	Comprehensive database health assessment
mysql_backup_strategy	Enterprise backup planning with RTO/RPO
mysql_index_tuning	Index analysis and optimization workflow
mysql_sys_schema_guide	sys schema usage and diagnostics

Setup Guides

Prompt	Description
mysql_setup_router	MySQL Router configuration guide
mysql_setup_proxysql	ProxySQL configuration guide
mysql_setup_replication	Replication setup guide
mysql_setup_shell	MySQL Shell usage guide
mysql_setup_events	Event Scheduler setup guide
mysql_setup_spatial	Spatial/GIS data setup guide
mysql_setup_cluster	InnoDB Cluster/Group Replication guide
mysql_setup_docstore	Document Store / X DevAPI guide

---

Using Prompts

In Claude Desktop or Cursor, you can invoke prompts directly:

Use the mysql_schema_design prompt to design a users table
→ Invokes schema design workflow

Run the mysql_database_health_check prompt
→ Starts comprehensive health assessment

Help me setup replication
→ Uses mysql_setup_replication prompt

---

Prompt Details

mysql_database_health_check

Comprehensive health assessment workflow:

1. Check connection health
2. Assess performance metrics
3. Review storage and table health
4. Check replication status
5. Generate recommendations

mysql_backup_strategy

Enterprise backup planning:

• RPO/RTO requirements analysis
• Choosing backup method (mysqldump, MySQL Shell, XtraBackup)
• Point-in-time recovery setup
• Testing procedures

mysql_index_tuning

Index optimization workflow:

• Identify unused indexes
• Find missing indexes for slow queries
• Detect duplicate indexes
• EXPLAIN analysis for optimization

mysql_sys_schema_guide

Diagnostics using the MySQL sys schema:

• Analyze I/O usage
• Find most expensive statements
• Check for full table scans
• Investigate excessive locking

Setup Prompts

The setup prompts provide step-by-step guides for advanced MySQL features:

• Cluster: InnoDB Cluster and Group Replication setup
• Spatial: Enabling GIS features and creating spatial indexes
• DocStore: Using MySQL as a NoSQL document store
• Events: Configuring the Event Scheduler

Each guide includes prerequisites, installation steps, configuration commands, and verification tools.

---

See Also

• Tool-Reference - Complete list of all 224 tools
• Resources - Database observability resources