sql-query-mcp
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_connectionsC | List configured SQL connections by connection_id. |
| list_schemasB | List visible schemas for a PostgreSQL connection. |
| list_databasesA | List visible databases for a MySQL or Hive connection. |
| list_tablesB | List tables and views for a resolved schema or database. |
| describe_tableC | Describe columns, keys, and indexes for a table. |
| run_selectB | Run a read-only SELECT or CTE query. |
| explain_queryB | Run EXPLAIN on a read-only SELECT or CTE query. |
| get_table_sampleB | Fetch a small sample from a table for schema discovery. |
| start_queryC | Start an asynchronous read-only SELECT or CTE query. |
| get_queryB | Get asynchronous query status and paginated results when complete. |
| cancel_queryC | Cancel a running asynchronous query. |
| import_table_fileC | Import a local CSV or XLSX file into an existing table. |
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/andyWang1688/sql-query-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server