Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MYSQL_SSL | No | Enable SSL connection | false |
| MYSQL_HOST | Yes | MySQL host | |
| MYSQL_PORT | No | MySQL port | 3306 |
| MYSQL_USER | Yes | MySQL user | |
| MYSQL_DATABASE | No | Default database | |
| MYSQL_MAX_ROWS | No | Auto LIMIT for SELECT queries | 100 |
| MYSQL_PASSWORD | Yes | MySQL password | |
| MYSQL_READONLY | No | Read-only mode | false |
| MYSQL_QUERY_TIMEOUT | No | Query timeout in ms (0 to disable) | 30000 |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| query | Execute a read-only SQL query (SELECT, SHOW, DESCRIBE, EXPLAIN). |
| execute | Execute a data modification SQL statement (INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, etc.). |
| list_databases | List all databases on the MySQL server. |
| list_tables | List all tables in the specified database (or the current database if not specified). |
| describe_table | Show the schema/structure of a table, including column names, types, constraints, and comments. |
| describe_all_tables | Show the schema of all tables at once. Much more efficient than calling describe_table for each table individually. |
| add_comment | Safely add a comment to a table or column. This tool only modifies comments — it cannot alter table structure, column types, or data. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |