mysql-mcp-server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MYSQL_SSL | No | Enable SSL (1, true, yes, on / 0, false, no, off) | false |
| MYSQL_HOST | No | MySQL host | 127.0.0.1 |
| MYSQL_PORT | No | MySQL port | 3306 |
| MYSQL_USER | Yes | MySQL username (required) | |
| MYSQL_DATABASE | No | Default database, leave empty to not specify | |
| MYSQL_MAX_ROWS | No | Maximum rows returned per query | 500 |
| MYSQL_PASSWORD | Yes | MySQL password (required) | |
| MYSQL_CONNECTION_LIMIT | No | Connection pool size | 5 |
| MYSQL_QUERY_TIMEOUT_MS | No | Query timeout in milliseconds | 30000 |
| MYSQL_CONNECT_TIMEOUT_MS | No | Connection timeout in milliseconds | 10000 |
| MYSQL_SSL_REJECT_UNAUTHORIZED | No | SSL reject unauthorized (1, true, yes, on / 0, false, no, off) | true |
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 | {
"listChanged": true
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| mysql_queryA | Run a read-only MySQL query. Allowed statements: SELECT, WITH SELECT, SHOW, DESCRIBE/DESC, and safe EXPLAIN. |
| mysql_list_databasesA | List databases visible to the configured read-only MySQL user. |
| mysql_list_tablesA | List tables and views for the current or selected database. |
| mysql_describe_tableA | Return column metadata and optional indexes for a table. |
| mysql_connection_infoA | Return current database, user, effective user, and server version. |
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 5 tools
Each tool has a distinct purpose: querying, listing databases, listing tables, describing table structure, and retrieving connection metadata. There is no overlap or ambiguity between them.
All tools share the mysql_ prefix and most follow a verb_noun pattern (list_databases, list_tables, describe_table, query). mysql_connection_info is slightly inconsistent as it uses a noun phrase instead of a verb, but the pattern is still clear and predictable.
Five tools is well-scoped for a read-only MySQL introspection server. Each tool serves a clear and necessary function without redundancy or bloat.
The toolset covers the core read-only operations: generic querying, database/table listing, schema description, and connection info. The only minor gap is a lack of a dedicated tool for viewing table indexes without using describe_table, but that is covered by the optional indexes parameter. Overall, the surface is complete for its intended purpose.