sql-mcp-server
by lieberweiss
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| API_KEY | No | API key for authentication (alternative to tokens.txt) | |
| DB_HOST | No | Database host (required for postgres, mysql, mssql) | |
| DB_PORT | No | Database port (optional, default varies by provider) | |
| DB_USER | No | Database user (required for postgres, mysql, mssql) | |
| DB_DATABASE | No | Database name (required for postgres, mysql, mssql) | |
| DB_MAX_ROWS | No | Maximum rows returned (default: 100) | |
| DB_PASSWORD | No | Database password (required for postgres, mysql, mssql) | |
| DB_PROVIDER | No | Database provider: sqlite, postgres, mysql, mssql | |
| SQLITE_PATH | No | Path to SQLite database file (required when DB_PROVIDER=sqlite) | |
| DB_READ_ONLY | No | Read-only mode (default: true) | |
| DB_ALLOW_DROP | No | Allow DROP statements (default: false) | |
| MCP_INSTANCES | No | Comma-separated instance prefixes for multi-instance mode | |
| DB_ALLOW_ALTER | No | Allow ALTER statements (default: false) | |
| DB_QUERY_TIMEOUT | No | Query timeout in seconds (default: 10) | |
| LOG_QUERY_BODIES | No | Log full SQL text (default: false) | |
| DB_ALLOWED_TABLES | No | Comma-separated allowlist of table names | |
| ENABLE_QUERY_LOGS | No | Enable query logging (default: false) | |
| SQL_MCP_LOG_LEVEL | No | Log level (default: INFO) | |
| DB_STATEMENT_TIMEOUT_MS | No | Statement timeout in milliseconds (default: DB_QUERY_TIMEOUT * 1000) |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
No tools | |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
This server cannot be deployed
Maintenance
ActivityInactive
ResponsivenessNo issues