Prompts

Workflow Automation: Available Prompts

Value Proposition Accelerate workflows with our comprehensive library of context-aware automation prompts. Minimize boilerplate, preserve token budgets, and empower your AI agents to intuitively orchestrate complex database operations. Read the full value proposition.

---

Automating Enterprise Workflows

The server provides a comprehensive library of context-aware prompts designed for context window efficiency. These prompts initialize complex tasks and streamline autonomous workflows, minimizing boilerplate code and preserving token budgets. Query the server via the MCP protocol for the current list of prompts. Note that the mysql_tool_index prompt lists only available tools. It does not 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).
• Health & Ops: Proactive diagnostics (e.g., mysql_database_health_check, mysql_sys_schema_guide, mysql_mcp_heal (note: this is a prompt, distinguishing it from tools), mysql_performance_analysis).
• Migrations: Database migrations (e.g., mysql_migration).
• Setup Guides: Expert configurations (e.g., mysql_setup_replication, mysql_setup_proxysql).

---

Executing Prompt Workflows

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

---

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

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

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 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)