Prompts

Workflow Automation: Available Prompts

Value Proposition Streamline enterprise automation workflows. mysql-mcp provides context-aware, ready-to-use prompts. These standardize and execute complex database operations to empower your AI agents to operate with increased precision, reliability, and speed. Read the full value proposition.

---

⚡ Instant Workflows: Available Prompts

The server provides a comprehensive library of context-aware prompts designed to instantly bootstrap complex tasks, accelerating autonomous workflows and minimizing boilerplate. Direct your agent to run the mysql_tool_index prompt or query the server via the MCP protocol for the complete current list.

Prominent Categories

• Core Workflows: Essential automation (e.g., mysql_query_builder, mysql_schema_design).
• Health & Ops: Proactive diagnostics (e.g., mysql_database_health_check, mysql_sysschema_guide).
• Setup Guides: Expert configurations (e.g., mysql_setup_replication, mysql_setup_proxysql).

---

🚀 Accelerate Workflows: 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

---

🔎 Deep Dive: 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

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_sysschema_guide

Diagnostics using the MySQL sysschema:

• 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. 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 robust 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)