Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| ALLOW_DDL | No | Allow DDL operations (CREATE, DROP, ALTER) | false |
| MYSQL_HOST | No | MySQL server hostname | localhost |
| MYSQL_PORT | No | MySQL server port | 3306 |
| MYSQL_USER | Yes | MySQL username (required) | |
| MCP_LOG_LEVEL | No | Logging level: debug, info, warn, error | info |
| MYSQL_DATABASE | Yes | Database name (required) | |
| MYSQL_PASSWORD | Yes | MySQL password (required) | |
| MAX_SELECT_ROWS | No | Maximum rows returned by SELECT queries | 1000 |
| REQUIRE_WHERE_CLAUSE | No | Require WHERE clause for UPDATE/DELETE | true |
| MYSQL_CONNECTION_LIMIT | No | Maximum number of connections in pool | 10 |
| ALLOW_MULTIPLE_STATEMENTS | No | Allow multiple SQL statements | false |
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
No tools | |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |