mysql-legacy-mcp
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MYSQL_LEGACY_HOST | Yes | Database host or local tunnel endpoint | |
| MYSQL_LEGACY_PORT | No | TCP port, 1–65535 | 3306 |
| MYSQL_LEGACY_USER | Yes | Dedicated reader account | |
| MYSQL_LEGACY_DATABASE | No | Optional default database for SELECT queries | |
| MYSQL_LEGACY_MAX_ROWS | No | SELECT response row limit, 1–1000 | 200 |
| MYSQL_LEGACY_PASSWORD | Yes | Nonempty account password | |
| MYSQL_LEGACY_QUERY_TIMEOUT | No | Driver query timeout, 100–60000 ms | 10000 |
| MYSQL_LEGACY_MAX_RESULT_BYTES | No | SELECT row-data JSON byte limit, 1024–1048576 | 262144 |
| MYSQL_LEGACY_HIDE_SYSTEM_DATABASES | No | Hide mysql and information_schema in listings; true / false | 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_legacy_pingA | Checks the legacy MySQL connection with SELECT VERSION() AS version. Read-only. |
| mysql_legacy_selectA | Executes exactly one read-only SELECT statement. SELECT INTO and locking reads are rejected; results are limited by MYSQL_LEGACY_MAX_ROWS and MYSQL_LEGACY_MAX_RESULT_BYTES. |
| mysql_legacy_list_databasesA | Lists databases using SHOW DATABASES. System databases are hidden by default according to MYSQL_LEGACY_HIDE_SYSTEM_DATABASES. |
| mysql_legacy_list_tablesA | Lists base tables and views with SHOW FULL TABLES FROM . Read-only. |
| mysql_legacy_describe_tableC | Lists columns with SHOW FULL COLUMNS FROM .. Read-only. |
| mysql_legacy_show_create_tableA | Returns the definition from SHOW CREATE TABLE .. Read-only. |
| mysql_legacy_list_indexesA | Lists indexes with SHOW INDEX FROM .. Read-only. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |