Resources

Database Resources and Telemetry

Value Proposition Equip AI agents with secure, high-fidelity real-time database telemetry. Our structured resource endpoints deliver context-optimized diagnostics and intelligent event-driven schema notifications. This empowers agents to continuously evaluate performance and seamlessly orchestrate responses to dynamic structural changes. Read the full value proposition.

Real-Time Diagnostics

Agents can access real-time database telemetry directly within their context, enabling them to evaluate performance and respond to state changes:

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 integrates natively with the core MCP resources/subscribe protocol. Agents receive timely push notifications. These cover critical schema mutations and state changes.

Prominent Subscribable URIs:

• mysql://schema: Awareness of any DDL change across the database.
• mysql://health: Periodic, high-fidelity health status updates.
• mysql://tables: Notifications for table creation, deletion, or alteration.
• mysql://table/{name}: Notifications for specific table schema changes.

Tip

The MCP server automatically and deterministically synchronizes state changes triggered by local tool executions. External architectural modifications may experience minor notification delays. These delays are bounded by the configured polling cycle. Resource routing and matching is highly optimized.

---

Surface Active Diagnostics

• Passive Telemetry: System-level observability infrastructure aggregates large datasets in the background continuously (e.g., Prometheus, Grafana, Datadog, OpenTelemetry). See Observability & Telemetry.
• Active Root Cause Analysis: Empowers AI agents to autonomously query specialized, high-fidelity MCP Resources, dynamically surfacing actionable insights to resolve complex performance anomalies and bottlenecks faster.

---

Reference Resource Metrics

The server securely exposes detailed telemetry through standard MCP resources. Query the native MCP protocol to discover all available resources.

Prominent Categories:

Resource	Category	Description
mysql://schema	Core	Full database schema
mysql://tables	Core	Table listing with metadata
mysql://variables	Core	Server configuration variables
mysql://status	Core	Server status metrics
mysql://processlist	Core	Active connections and queries
mysql://pool	Core	Connection pool statistics
mysql://capabilities	Extended	Server version, features, and tool categories
mysql://health	Extended	Comprehensive database health status
mysql://performance	Extended	Query performance metrics
mysql://indexes	Extended	Index usage and statistics
mysql://replication	Extended	Replication status and lag
mysql://innodb	Extended	InnoDB buffer pool and engine metrics
mysql://events	Domain	Event Scheduler status and scheduled events
mysql://sysschema	Domain	sys schema diagnostics summary
mysql://locks	Domain	InnoDB lock contention detection
mysql://cluster	Domain	Group Replication / InnoDB Cluster status
mysql://spatial	Domain	Spatial columns and indexes
mysql://docstore	Domain	Document Store collections
mysql://insights	Analytics	Active anomaly detection and deep system insights
mysql://metrics	Observability	In-memory token usage, latency, and request metrics (Note: this is an MCP resource, distinct from the HTTP Prometheus /metrics endpoint)
mysql://audit	Observability	Forensic trail and snapshot of system errors explicitly connected to file-based audit pipeline telemetry (persisted to AUDIT_LOG_PATH for Datadog ingestion)
mysql://help	Documentation	Critical gotchas and high-level API reference
mysql://help/{group}	Documentation	Dynamic group-specific tool reference (e.g., core, codemode)

---

Explore Related Topics

• Tools - Complete tool list
• Tool Filtering - Custom tool filtering
• Configuration - General configuration
• Code Mode - Code Mode API documentation
• Schema - Strict schema enforcement
• Observability - Telemetry and monitoring setup