mcp-mysql-explorer
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MYSQL_HOST | Yes | The MySQL host address. | |
| MYSQL_PORT | No | The MySQL port number. | 3306 |
| MYSQL_USER | Yes | The MySQL user name. | |
| MYSQL_DATABASE | Yes | The MySQL database name. | |
| MYSQL_PASSWORD | Yes | The MySQL password. | |
| MYSQL_READ_ONLY | No | Whether to run in read-only mode (true/false). Set to false to allow write operations. | 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": false
} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_tablesA | List all tables in the connected MySQL database. |
| describe_tableC | Get the schema (columns, types, keys) of a specific table. Args: table_name: Name of the table to describe. |
| queryA | Execute a read-only SQL query (SELECT / SHOW / DESCRIBE / EXPLAIN). Only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are allowed. Args: sql: The SQL query to execute. |
| execute_sqlB | Execute a write SQL statement (INSERT / UPDATE / DELETE / ALTER / CREATE / DROP, etc). Use with caution: this modifies the database. Args: sql: The SQL statement to execute. |
| get_table_indexesB | Show all indexes of a specific table. Args: table_name: Name of the table. |
| get_create_tableC | Get the CREATE TABLE statement of a specific table. Args: table_name: Name of the table. |
| get_database_infoA | Get overview information about the connected database, including size, table count, and charset. |
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 7 tools
The read/write split between query and execute_sql is explicitly stated in both descriptions, so an agent can pick correctly. The introspection tools (describe_table, get_table_indexes, get_create_table) overlap somewhat since DESCRIBE/SHOW can also surface keys and index info, but each has a distinct output focus.
All names are snake_case, but verb conventions are mixed: list_tables/describe_table use one verb family, while get_table_indexes/get_create_table/get_database_info use 'get', and query/execute_sql are bare verb forms. Readable overall, but 'get_create_table' is awkward and the pattern isn't uniform.
Seven tools is well-scoped for a MySQL explorer: schema discovery, ad-hoc read queries, writes, and database metadata each have exactly one owner. No tool feels redundant padding.
The surface covers introspection, read queries, write DDL/DML, and database-level info, so core workflows are supported. Minor gaps exist around database/schema switching (e.g. listing databases or selecting a schema) and explicit transaction control, which agents would have to work around with raw SQL.