Resources

Resources

🚀 Value Proposition

Experience unparalleled visibility and control with Enterprise-grade observability resources. Gain real-time database intelligence through semantic URI patterns to securely surface mission-critical telemetry, maintain a continuous pulse on database performance and health, and empower AI agents with the absolute truth.

---

Gain Total Visibility: Available Resources (19)

Core Resources: Essential Intelligence

Resource	Description
mysql://schema	Full database schema including tables, views, and indexes
mysql://tables	Table listing with metadata (row counts, sizes, engines)
mysql://variables	Server configuration variables (SHOW GLOBAL VARIABLES)
mysql://status	Server status metrics (SHOW GLOBAL STATUS)
mysql://processlist	Active connections and currently running queries
mysql://pool	Connection pool statistics (total, active, idle, waiting)

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

Monitor Instantly: Using Resources

Resources are accessed by MCP clients automatically. In Claude Desktop or Cursor, you can 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

---

Automate Monitoring: Resource Subscriptions

The server supports the native MCP resources/subscribe feature, allowing clients to receive real-time notifications (notifications/resources/updated) when underlying 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: Changes are detected through tool executions (e.g., executing a CREATE TABLE query via mysql_execute_code). External changes not routed through the MCP server will not trigger notifications immediately.

---

Explore Deep 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://insights

Business insights and operational knowledge:

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

---

Expand Your Knowledge (See Also)

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