Prompts

Workflow Automation: Available Prompts

Value Proposition Streamline workflows with context-aware automation prompts. Minimize boilerplate, maximize token efficiency, and enable your AI agents to execute flawless orchestration of complex database operations with enhanced autonomous intelligence. Read the full value proposition.

---

Workflows

The server provides intelligent, context-aware prompts meticulously designed for maximum context window efficiency. These prompts instantly initialize complex tasks and streamline autonomous workflows, eliminating boilerplate code while preserving your critical token budget. Query the server via the MCP protocol for the current list of prompts. Note that the mysql_tool_index prompt merely dumps the complete structured markdown listing of available tools; it does not accept a query parameter for search, nor does it list resources or prompts.

Explore Prominent Categories

• Core Workflows: Essential automation (e.g., mysql_query_builder, mysql_schema_design, mysql_quick_query, mysql_quick_schema, mysql_mcp_heal, mysql_tool_index).
• Health & Ops: Proactive diagnostics (e.g., mysql_database_health_check, mysql_sys_schema_guide, mysql_performance_analysis, mysql_backup_strategy, mysql_index_tuning).
• Migrations: Database migrations (e.g., mysql_migration).
• Setup Guides: Advanced configurations (e.g., mysql_setup_replication, mysql_setup_proxysql).

---

Prompt Workflows

Empower your agents with sophisticated, multi-step orchestration. Leverage AI orchestration by invoking prompts directly in Claude Desktop or Cursor:

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

---

Review Prompt Features

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

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

mysql_performance_analysis

A diagnostic prompt to guide the analysis of query execution and performance metrics.

mysql_tool_index

Dynamic discoverability prompt that dumps the complete list of available tools to enable quick index-based tool selection (no query parameter accepted).

Parameter Summaries:

• mysql_database_health_check: Optional focus (e.g., 'performance', 'storage').
• mysql_backup_strategy: Optional rpo, rto, and data_size.
• mysql_index_tuning: Optional table to focus on a specific table.
• mysql_sys_schema_guide: No parameters required.
• mysql_performance_analysis: Required query (the slow query string to analyze) and optional context (table schema and data volume).
• mysql_tool_index: No parameters required (does not accept a query string).

Configure Setup Prompts

The setup prompts provide step-by-step guides for advanced MySQL features. Examples include, but are not limited to:

• Router (mysql_setup_router): Configure MySQL Router REST API endpoints and integrate with InnoDB Cluster.
• ProxySQL (mysql_setup_proxysql): Deploy query routing rules, digest stats, and connection pooling.
• Replication (mysql_setup_replication): Initialize source/replica architectures, measure lag, and handle failover.
• Shell (mysql_setup_shell): Leverage MySQL Shell utilities for reliable schema dumps and parallel imports.
• Cluster (mysql_setup_cluster): InnoDB Cluster and Group Replication setup
• Spatial (mysql_setup_spatial): Enabling GIS features and creating spatial indexes
• DocStore (mysql_setup_docstore): Using MySQL as a NoSQL document store
• Events (mysql_setup_events): Configuring the Event Scheduler

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

---

Explore Related Topics

• Tools - Complete list of all tools
• Resources - Database telemetry resources (MCP)
• Observability & Telemetry - System telemetry (Prometheus, Grafana, Datadog)