Resources

📡 Database Telemetry: Autonomous Resources

💎 Value Proposition

• Execute complex logic via Code Mode, reducing token usage by 70-90%.
• Build AI integrations instantly.
• Empower agents with secure database access.
• Scale operations with robust connection pooling.
• Leverage OAuth 2.1 for enterprise security.

Monitor Instantly

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

---

Subscribe to Notifications

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 200+ tools
• Tool-Filtering - Reduce tool count for IDE limits