mysql-mcp
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MYSQL_HOST | No | MySQL server host (used for single server mode) | localhost |
| MYSQL_PORT | No | MySQL server port (used for single server mode) | 3306 |
| MYSQL_USER | No | MySQL username (used for single server mode) | root |
| MYSQL_SERVERS | No | JSON string defining multiple MySQL servers. Example: '{"production":{"host":"prod.example.com","port":3306,"user":"prod_user","password":"prod_password","database":"prod_db"}}' | |
| MYSQL_DATABASE | No | Database name to connect to (used for single server mode) | |
| MYSQL_PASSWORD | No | MySQL password (used for single server mode) |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_serversA | List all configured MySQL servers |
| list_tablesC | List all tables in the database |
| describe_tableB | Describe the structure of a specific table |
| queryA | Execute a SELECT query (readonly operations only) |
| show_databasesB | List all databases available |
| use_databaseB | Switch to a different database on a server |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 6 tools
Each tool targets a distinct resource or action: servers, databases, tables, schema, and querying. There is no meaningful overlap between list_servers, show_databases, list_tables, describe_table, use_database, and query.
Most tools follow a clear verb_noun snake_case pattern (list_servers, list_tables, describe_table, show_databases, use_database). The single tool 'query' deviates slightly by lacking a noun object, but the imperative style remains consistent.
Six tools is well-scoped for a read-only MySQL exploration server. Each tool covers a necessary step in navigating servers, databases, tables, and data without redundancy.
The tool set provides a complete read-only workflow: discover servers, select databases, list tables, inspect schemas, and run SELECT queries. It intentionally lacks write and administrative operations, which is a minor limitation if broader MySQL management is expected.