Resources

📡 Database Telemetry: Autonomous Resources

Value Proposition Empower your AI agents with real-time database telemetry. Enable autonomous diagnosis of performance bottlenecks and immediate responses to schema changes within a secure operational framework. Read the full value proposition.

⏱️ Real-Time Autonomous Telemetry

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

---

🔔 Event-Driven Subscriptions

The server seamlessly integrates with the MCP resources/subscribe feature, ensuring your agents receive timely 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.

Tip: The MCP server automatically synchronizes state changes triggered by tool executions. Note that external modifications bypassing the MCP layer may experience notification delays until the next polling cycle.

---

🔍 Active vs. Passive Telemetry

• Passive Telemetry: System-level telemetry (Prometheus, Grafana, Datadog) silently collects data in the background. See Observability & Telemetry.
• Active Root Cause Analysis: mysql://insights aggregates intelligence generated by active tool use. AI agents dynamically invoke context-rich MCP Resources and Tools to perform deep-dive troubleshooting, directly addressing and resolving bottlenecks surfaced by the passive observability stack.

---

📊 Resource Metrics Reference

The server exposes detailed telemetry through standard MCP resources. Query the server via the MCP protocol to list all available tools and 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).

---

🌐 Explore Related Topics

• Tools - Complete list of all tools
• Tool Filtering - Optimize toolsets to accommodate IDE context limits