Resources

📡 Database Telemetry: Autonomous Resources

💎 Enterprise-Grade Value Proposition

• Maximize AI Context Windows: Transform complex database workflows via Code Mode, unlocking up to 90% token efficiency.
• Accelerate Agent Deployments: Build autonomous AI integrations instantly with zero-trust telemetry and strict boundaries.
• Unleash Autonomous Operations: Equip intelligent agents with granular, schema-enforced database capabilities.
• Scale Without Bottlenecks: Sustain high-throughput agent swarms with robust, enterprise-grade connection pooling.
• Secure Every Transaction: Fortify your infrastructure with native OAuth 2.1 authentication and sandboxed execution.

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 Architecture via Subscriptions

The server supports the MCP resources/subscribe feature. Clients receive real-time notifications when data changes.

Review Subscribable URIs

URI Pattern	Event Trigger
mysql://schema	Any DDL change (CREATE, ALTER, DROP) across the database
mysql://tables	Any DDL change affecting table structures
mysql://table/{name}	DDL changes affecting a specific table
mysql://health	Periodic health status updates

Note: Tool executions detect changes. External changes bypassing the MCP server delay notifications.

---

Explore Resource Metrics

mysql://capabilities

Shows server information and MCP server capabilities:

• MySQL version and supported features
• JSON support, FULLTEXT, partitioning availability
• All tool groups and meta-groups with tool counts

mysql://health

Comprehensive health dashboard:

• Connection pool utilization and thread activity
• Buffer pool hit ratio and memory usage
• Slow query count
• Query mix (SELECT/INSERT/UPDATE/DELETE counts)

mysql://performance

Query performance insights:

• Total queries and slow query count
• Temporary tables to disk ratio
• Full table scan percentage
• Top 10 queries by execution time (if performance_schema enabled)
• Handler statistics (index reads vs table scans)

mysql://indexes

Index analysis:

• All indexes with cardinality and type
• Unused indexes (never scanned)
• Potential duplicate/redundant indexes

mysql://replication

Replication monitoring:

• Server role (source, replica, standalone)
• Binary log position
• Replica I/O and SQL thread status
• Seconds behind source (replication lag)
• GTID configuration

mysql://innodb

InnoDB engine metrics:

• Buffer pool size and hit ratio
• Page statistics (total, free, dirty)
• Row operations (reads, inserts, updates, deletes)
• I/O statistics

mysql://cluster

Group Replication & InnoDB Cluster status:

• Member state (ONLINE, RECOVERING)
• Primary/Secondary check
• Cluster topology

mysql://sysschema

High-level performance summary from sys schema:

• Top I/O users
• Worst performing statements
• Host summary

mysql://locks

Lock contention analysis:

• Currently blocked transactions
• Blocking transaction ID and query
• Wait duration

mysql://events

Event Scheduler status and scheduled events:

• Scheduler ON/OFF status
• List of scheduled events and their definitions
• Last execution times and statuses

mysql://spatial

Spatial columns and indexes:

• Table columns with spatial data types
• SRID configurations
• Spatial indexes presence

mysql://docstore

Document Store collections:

• JSON collection list
• Collection metadata and sizes
• Document count estimates

mysql://insights

Business insights and operational knowledge:

• Persistent insights you append via mysql_append_insight
• Contextual memory for multi-session tasks

---

Explore Related Topics

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