Resources

📡 Database Telemetry: Autonomous Resources

🚀 Value Proposition

Deep data telemetry feeds autonomous resources, providing a live database view. Enable autonomous workflows with telemetry, metadata extraction, and anomaly detection without tool tokens.

Core Resources: Essential Intelligence

Resource	Description
mysql://schema	Complete, instantaneous blueprint of all tables, views, and indexes
mysql://tables	High-level table metadata for rapid capacity assessment
mysql://table/{name}	Targeted metadata resource for a specific table.
mysql://variables	Live global configuration states for immediate tuning
mysql://status	Real-time vital metrics for anomaly detection
mysql://processlist	Live view of executing queries and active connections
mysql://pool	Connection pool utilization metrics to help ensure scalability

Monitoring Resources: Real-time Health

Resource	Description
mysql://capabilities	Server version, supported features, and tool categories
mysql://health	Comprehensive health status (connections, performance, InnoDB)
mysql://performance	Query performance metrics and top queries by time
mysql://indexes	Index usage statistics, unused indexes, duplicate detection
mysql://replication	Replication status, lag, GTID info, connected replicas
mysql://innodb	InnoDB buffer pool stats, row operations, I/O metrics
mysql://events	Event Scheduler status and scheduled events
mysql://sysschema	sys schema diagnostics summary
mysql://locks	InnoDB lock contention detection
mysql://cluster	Group Replication/InnoDB Cluster status
mysql://spatial	Spatial columns and indexes
mysql://docstore	Document Store collections
mysql://insights	Business insights memo from mysql_append_insight

Server-Level Resources

Resource	Description
mysql://audit-log	Forensic audit trail and pre-mutation snapshot stats
mysql://metrics	In-memory streaming telemetry (p50/p95/p99 latency)
mysql://help	Critical gotchas, parameter aliases, and API reference

Monitor Instantly: Using Resources

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 Notifications: Subscribable Resources

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

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 Metrics: Resource Details

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

---

Learn More (See Also)

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