Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| CONFIG_FILE | No | Configuration file path (.env/.json/.js) | |
| SQL_MCP_DB_HOST | No | Database host | |
| SQL_MCP_DB_NAME | No | Database name | |
| SQL_MCP_DB_PORT | No | Database port | |
| SQL_MCP_DB_TYPE | No | Database type | mysql |
| SQL_MCP_DB_USER | No | Database user | |
| SQL_MCP_LOG_LEVEL | No | Logging level (debug|info|warn|error) | |
| SQL_MCP_DB_TIMEOUT | No | Database connection timeout | |
| SQL_MCP_DB_PASSWORD | No | Database password | |
| SQL_MCP_LOG_FILE_PATH | No | Log file path | |
| SQL_MCP_MCP_HTTP_PORT | No | MCP HTTP port | |
| SQL_MCP_MCP_TRANSPORT | No | MCP transport (stdio|http) | |
| SQL_MCP_LOG_DESTINATION | No | Logging destination (console|file) |
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 |
|---|---|
No tools | |