Resources

Resources

Resources provide real-time database information through URI patterns. Unlike tools which perform actions, resources expose read-only observability data.

---

Available Resources (19 total)

Core Resources

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

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

---

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

---

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}/schema	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.

---

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

---

See Also

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