-
Notifications
You must be signed in to change notification settings - Fork 2
Resources
Value Proposition Empower your AI agents with real-time database telemetry. Proactively detect performance bottlenecks, rapidly respond to schema changes, and enable autonomous monitoring for a more resilient, self-healing infrastructure. Read the full value proposition.
MCP clients access resources automatically. In Claude Desktop or Cursor, reference them directly:
Show me the database health status
→ Uses mysql://health resource
What tables exist in this database?
→ Uses mysql://tables resource
Check the replication lag
→ Uses mysql://replication resource
Show me any locking issues
→ Uses mysql://locks resource
The server seamlessly integrates with the MCP resources/subscribe feature, ensuring your agents receive immediate, real-time notifications when critical data or schema changes occur.
Prominent Subscribable URIs:
-
mysql://schema: Any DDL change across the database. -
mysql://health: Periodic health status updates. -
mysql://insights: Analyzes the database and surfaces potential performance bottlenecks or configuration issues.
Note
Tool executions detect changes. External changes bypassing the MCP server delay notifications.
- Passive Telemetry: System-level telemetry (Prometheus, Grafana, Datadog) silently collects data in the background. See Observability & Telemetry.
-
Active Troubleshooting: MCP Resources (like
mysql://insights) and Tools are actively invoked by the AI agent to drill down into specific database issues identified by the passive telemetry.
The server exposes detailed telemetry through standard MCP resources. Use the mysql_tool_index prompt (which indexes both tools and resources) or check --help for the full, current list.
Prominent Categories:
-
Database & Schema: Overview of structures and tables (e.g.,
mysql://schema,mysql://tables). -
Performance & Health: Active diagnostics and query insights (e.g.,
mysql://health,mysql://performance,mysql://sysschema,mysql://locks). -
Replication & Topology: Cluster and slave telemetry (e.g.,
mysql://replication,mysql://cluster).
- Tools - Complete list of all tools
- Tool Filtering - Reduce tool count for IDE limits
Unlock autonomous database orchestration with an enterprise-grade MySQL MCP server. Featuring blazing-fast sandboxed Code Mode, uncompromising schema enforcement, and seamless ecosystem integrations to power secure, intelligent AI workflows.
- Installation
- Configuration
- Architecture
- HTTP Transport
- Tool Filtering
- Code Mode
- Tools
- Prompts
- Resources
- Observability & Telemetry