Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MYSQL_DEV_DSN | No | MySQL connection string for the development environment. (e.g., mysql://user:password@127.0.0.1:3306/app_dev) | |
| MYSQL_PROD_RO_DSN | No | MySQL connection string for the production read-only environment. (e.g., mysql://readonly:password@127.0.0.1:3306/app) | |
| VMYSQL_CONFIG_PATH | Yes | Path to the vmysql.config.json configuration file. By default, it uses vmysql.config.json in the current working directory. Absolute paths are recommended. |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| mysql_query | Run one read-only SQL statement on a configured MySQL environment. |
| mysql_exec | Run one write-capable SQL statement on a configured MySQL environment if policy allows. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |