Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| SQL_QUERY_MCP_CONFIG | No | The absolute path to the connections.json configuration file. Defaults to 'config/connections.json' if not set. | |
| PG_CONN_CRM_PROD_MUQIAO_RO | No | Example PostgreSQL DSN (e.g., postgresql://user:password@host:5432/dbname). The environment variable name must match the 'dsn_env' field in your connections.json. | |
| MYSQL_CONN_CRM_PROD_MUQIAO_RO | No | Example MySQL DSN (e.g., mysql://user:password@host:3306/crm). The environment variable name must match the 'dsn_env' field in your connections.json. |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": false
} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_connections | List configured SQL connections by connection_id. |
| list_schemas | List visible schemas for a PostgreSQL connection. |
| list_databases | List visible databases for a MySQL connection. |
| list_tables | List tables and views for a resolved PostgreSQL schema or MySQL database. |
| describe_table | Describe columns, keys, and indexes for a table. |
| run_select | Run a read-only SELECT or CTE query. |
| explain_query | Run EXPLAIN on a read-only SELECT or CTE query. |
| get_table_sample | Fetch a small sample from a table for schema discovery. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |