Resources
Value Proposition Empower AI agents with real-time database telemetry. Diagnose performance bottlenecks autonomously. Respond immediately to schema changes securely. 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 integrates with the MCP resources/subscribe feature. Agents receive timely notifications for critical schema changes.
Prominent Subscribable URIs:
-
mysql://schema: Any DDL change across the database. -
mysql://health: Periodic health status updates.
Tip: The MCP server automatically synchronizes state changes from tool executions. External modifications may experience notification delays until the next polling cycle.
- Passive Telemetry: System-level telemetry (Prometheus, Grafana, Datadog) silently collects data in the background. See Observability & Telemetry.
-
Active Root Cause Analysis:
mysql://insightsaggregates intelligence generated by active tool use. AI agents dynamically invoke MCP Resources to perform deep-dive troubleshooting. They directly address bottlenecks surfaced by passive observability.
The server exposes detailed telemetry through standard MCP resources. Query the MCP protocol to list all available resources. The mysql_tool_index prompt only indexes tools.
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://insights,mysql://sysschema,mysql://locks). -
Replication & Topology: Cluster and slave telemetry (e.g.,
mysql://replication,mysql://cluster).
- Tools - Complete list of all tools
- Tool Filtering - Optimize toolsets to accommodate IDE context limits