145+ tools across 8 databases: MySQL, PostgreSQL, Redshift, MongoDB, Redis, Kafka, and more
Connect Runs on your machine
claude mcp add db-gateway -e DBS=<DBS> -e READ_ONLY=<READ_ONLY> -e MYSQL=<MYSQL> -e POSTGRESQL=<POSTGRESQL> -e REDSHIFT=<REDSHIFT> -e MONGODB=<MONGODB> -e REDIS=<REDIS> -e ELASTICSEARCH=<ELASTICSEARCH> -e KAFKA=<KAFKA> -e DYNAMODB_REGION=<DYNAMODB_REGION> -e DYNAMODB_ACCESS_KEY_ID=<DYNAMODB_ACCESS_KEY_ID> -e DYNAMODB_SECRET_ACCESS_KEY=<DYNAMODB_SECRET_ACCESS_KEY> -- npx -y [email protected]
{
"mcpServers": {
"db-gateway": {
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"DBS": "<DBS>",
"READ_ONLY": "<READ_ONLY>",
"MYSQL": "<MYSQL>",
"POSTGRESQL": "<POSTGRESQL>",
"REDSHIFT": "<REDSHIFT>",
"MONGODB": "<MONGODB>",
"REDIS": "<REDIS>",
"ELASTICSEARCH": "<ELASTICSEARCH>",
"KAFKA": "<KAFKA>",
"DYNAMODB_REGION": "<DYNAMODB_REGION>",
"DYNAMODB_ACCESS_KEY_ID": "<DYNAMODB_ACCESS_KEY_ID>",
"DYNAMODB_SECRET_ACCESS_KEY": "<DYNAMODB_SECRET_ACCESS_KEY>"
}
}
}
}
{
"mcpServers": {
"db-gateway": {
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"DBS": "<DBS>",
"READ_ONLY": "<READ_ONLY>",
"MYSQL": "<MYSQL>",
"POSTGRESQL": "<POSTGRESQL>",
"REDSHIFT": "<REDSHIFT>",
"MONGODB": "<MONGODB>",
"REDIS": "<REDIS>",
"ELASTICSEARCH": "<ELASTICSEARCH>",
"KAFKA": "<KAFKA>",
"DYNAMODB_REGION": "<DYNAMODB_REGION>",
"DYNAMODB_ACCESS_KEY_ID": "<DYNAMODB_ACCESS_KEY_ID>",
"DYNAMODB_SECRET_ACCESS_KEY": "<DYNAMODB_SECRET_ACCESS_KEY>"
}
}
}
}
{
"servers": {
"db-gateway": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"DBS": "<DBS>",
"READ_ONLY": "<READ_ONLY>",
"MYSQL": "<MYSQL>",
"POSTGRESQL": "<POSTGRESQL>",
"REDSHIFT": "<REDSHIFT>",
"MONGODB": "<MONGODB>",
"REDIS": "<REDIS>",
"ELASTICSEARCH": "<ELASTICSEARCH>",
"KAFKA": "<KAFKA>",
"DYNAMODB_REGION": "<DYNAMODB_REGION>",
"DYNAMODB_ACCESS_KEY_ID": "<DYNAMODB_ACCESS_KEY_ID>",
"DYNAMODB_SECRET_ACCESS_KEY": "<DYNAMODB_SECRET_ACCESS_KEY>"
}
}
}
}
Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.
Tools
This server runs locally, so its tools are listed by your MCP client once it starts.
Environment variables
| Name | Description |
|---|---|
DBSRequired | Engines to enable, comma-separated. Only the listed engines get their tools registered. Example: mysql,redis,kafka |
READ_ONLYOptional | Set to true to hide every write tool and restrict *_execute_query to SELECT-style statements. Recommended when pointing at production. |
MYSQLOptional, secret | MySQL connection string(s), semicolon-separated for multiple instances. Format: mysql://<user>:<password>@<host>:3306/<database>?alias=dev&default=true — alias is required. |
POSTGRESQLOptional, secret | PostgreSQL connection string(s), semicolon-separated. Format: postgresql://<user>:<password>@<host>:5432/<database>?alias=dev&ssl=true — alias is required. |
REDSHIFTOptional, secret | Redshift connection string(s), semicolon-separated. Format: redshift://<user>:<password>@<host>:5439/<database>?alias=dev&ssl=true — alias is required. |
MONGODBOptional, secret | MongoDB connection string(s), semicolon-separated. Format: mongodb://<user>:<password>@<host>:27017/<database>?alias=dev — alias is required. |
REDISOptional, secret | Redis connection string(s), semicolon-separated. Format: redis://:<password>@<host>:6379/0?alias=dev — leave the password empty for a no-auth instance. alias is required. |
ELASTICSEARCHOptional, secret | Elasticsearch connection string(s), semicolon-separated. Format: elasticsearch://<user>:<password>@<host>:9200?alias=dev, or http(s)://<host>:9200?alias=dev for no auth. alias is required. |
KAFKAOptional, secret | Kafka connection string(s), semicolon-separated. Format: kafka://<user>:<password>@<broker1>:9092,<broker2>:9092?alias=dev&mechanism=plain — alias is required. |
DYNAMODB_REGIONOptional | AWS region for DynamoDB. DynamoDB is configured with discrete variables instead of a connection string. |
DYNAMODB_ACCESS_KEY_IDOptional, secret | AWS access key ID for DynamoDB. |
DYNAMODB_SECRET_ACCESS_KEYOptional, secret | AWS secret access key for DynamoDB. |
Details
| Package | [email protected] (NPM, stdio) |
| First published | 9 Aug 2026 |
| Last updated | 9 Aug 2026 |
| Registry name | io.github.sijunkim/db-gateway |
More databases servers See all
Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.
