Resources

📡 Database Telemetry: Autonomous Resources

Value Proposition Provide real-time telemetry for autonomous database monitoring, proactively detect performance bottlenecks, and rapidly respond to schema changes.

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 supports the MCP resources/subscribe feature. Clients receive real-time notifications when data changes.

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.

---

Active vs. Passive Telemetry

• 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. Note: Run the mysql_tool_index prompt or the CLI --help command for the full list of supported resources.

---

Resource Metrics Reference

The server exposes detailed telemetry through standard MCP resources. Use the mysql_tool_index prompt 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).
• Replication & Topology: Cluster and slave telemetry (e.g., mysql://replication, mysql://cluster).

---

Explore Related Topics

• Tools - Complete list of all tools
• Tool Filtering - Reduce tool count for IDE limits