MySQL Query MCP Server
by devakone
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DEBUG | No | Enable debug logging (default false) | |
| LOCAL_DB_SSL | No | Enable SSL for the local environment (default false) | |
| LOCAL_DB_HOST | No | Database host for the local environment | |
| LOCAL_DB_NAME | No | Database name for the local environment | |
| LOCAL_DB_PASS | No | Database password for the local environment | |
| LOCAL_DB_PORT | No | Database port for the local environment (default 3306) | |
| LOCAL_DB_USER | No | Database username for the local environment | |
| MCP_MYSQL_SSL | No | Enable SSL for all connections (default false) | |
| MYSQL_TIMEZONE | No | Timezone used by mysql2 when sending JavaScript Date values in queries (default Z) | |
| STAGING_DB_SSL | No | Enable SSL for the staging environment (default false) | |
| STAGING_DB_HOST | No | Database host for the staging environment | |
| STAGING_DB_NAME | No | Database name for the staging environment | |
| STAGING_DB_PASS | No | Database password for the staging environment | |
| STAGING_DB_PORT | No | Database port for the staging environment (default 3306) | |
| STAGING_DB_USER | No | Database username for the staging environment | |
| PRODUCTION_DB_SSL | No | Enable SSL for the production environment (default false) | |
| DEVELOPMENT_DB_SSL | No | Enable SSL for the development environment (default false) | |
| PRODUCTION_DB_HOST | No | Database host for the production environment | |
| PRODUCTION_DB_NAME | No | Database name for the production environment | |
| PRODUCTION_DB_PASS | No | Database password for the production environment | |
| PRODUCTION_DB_PORT | No | Database port for the production environment (default 3306) | |
| PRODUCTION_DB_USER | No | Database username for the production environment | |
| DEVELOPMENT_DB_HOST | No | Database host for the development environment | |
| DEVELOPMENT_DB_NAME | No | Database name for the development environment | |
| DEVELOPMENT_DB_PASS | No | Database password for the development environment | |
| DEVELOPMENT_DB_PORT | No | Database port for the development environment (default 3306) | |
| DEVELOPMENT_DB_USER | No | Database username for the development environment | |
| MCP_MYSQL_REJECT_UNAUTHORIZED | No | Verify SSL certificates (default true) |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| queryA | Execute read-only SQL queries against MySQL databases |
| infoC | Get information about MySQL databases |
| environmentsA | List available MySQL database environments |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/devakone/mysql-query-mcp-server'
If you have feedback or need assistance with the MCP directory API, please join our Discord server