Prompts

Workflow Automation: Available Prompts

Value Proposition Initialize automation workflows with a library of context-aware prompts. Streamline database operations and empower your AI agents to execute tasks with precision and reliability.

---

Instant Workflows: Available Prompts

The server provides a comprehensive library of context-aware prompts designed to initialize complex tasks, streamline autonomous workflows, and minimize boilerplate. Query the server via the MCP protocol for the complete current list of prompts (Note: the mysql_tool_index prompt lists only available tools, not resources or prompts).

Prominent Categories

• Core Workflows: Essential automation (e.g., mysql_query_builder, mysql_schema_design, mysql_quick_query, mysql_quick_schema).
• Health & Ops: Proactive diagnostics (e.g., mysql_database_health_check, mysql_sys_schema_guide, mysql_mcp_heal, mysql_performance_analysis).
• Migrations: Database migrations (e.g., mysql_migration).
• 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_sys_schema_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)