Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DEBUG | No | Enable debug logging | false |
| LOCAL_DB_HOST | No | Database host for local environment | |
| LOCAL_DB_NAME | No | Database name for local environment | |
| LOCAL_DB_PASS | No | Database password for local environment | |
| LOCAL_DB_PORT | No | Database port for local environment | 3306 |
| LOCAL_DB_USER | No | Database username for local environment | |
| MCP_MYSQL_SSL | No | Enable SSL for all connections | false |
| STAGING_DB_HOST | No | Database host for staging environment | |
| STAGING_DB_NAME | No | Database name for staging environment | |
| STAGING_DB_PASS | No | Database password for staging environment | |
| STAGING_DB_PORT | No | Database port for staging environment | 3306 |
| STAGING_DB_USER | No | Database username for staging environment | |
| PRODUCTION_DB_HOST | No | Database host for production environment | |
| PRODUCTION_DB_NAME | No | Database name for production environment | |
| PRODUCTION_DB_PASS | No | Database password for production environment | |
| PRODUCTION_DB_PORT | No | Database port for production environment | 3306 |
| PRODUCTION_DB_USER | No | Database username for production environment | |
| DEVELOPMENT_DB_HOST | No | Database host for development environment | |
| DEVELOPMENT_DB_NAME | No | Database name for development environment | |
| DEVELOPMENT_DB_PASS | No | Database password for development environment | |
| DEVELOPMENT_DB_PORT | No | Database port for development environment | 3306 |
| DEVELOPMENT_DB_USER | No | Database username for development environment | |
| MCP_MYSQL_REJECT_UNAUTHORIZED | No | Verify SSL certificates | true |
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| query | Execute read-only SQL queries against MySQL databases |
| info | Get information about MySQL databases |
| environments | List available MySQL database environments |