NestDaddy

Db Gateway

io.github.sijunkim/db-gateway · v1.0.4

145+ tools across 8 databases: MySQL, PostgreSQL, Redshift, MongoDB, Redis, Kafka, and more

Connect Runs on your machine

Terminal
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]
claude_desktop_config.json
{
  "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>"
      }
    }
  }
}
~/.cursor/mcp.json
{
  "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>"
      }
    }
  }
}
.vscode/mcp.json
{
  "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

NameDescription
DBS
Required
Engines to enable, comma-separated. Only the listed engines get their tools registered. Example: mysql,redis,kafka
READ_ONLY
Optional
Set to true to hide every write tool and restrict *_execute_query to SELECT-style statements. Recommended when pointing at production.
MYSQL
Optional, secret
MySQL connection string(s), semicolon-separated for multiple instances. Format: mysql://<user>:<password>@<host>:3306/<database>?alias=dev&default=true — alias is required.
POSTGRESQL
Optional, secret
PostgreSQL connection string(s), semicolon-separated. Format: postgresql://<user>:<password>@<host>:5432/<database>?alias=dev&ssl=true — alias is required.
REDSHIFT
Optional, secret
Redshift connection string(s), semicolon-separated. Format: redshift://<user>:<password>@<host>:5439/<database>?alias=dev&ssl=true — alias is required.
MONGODB
Optional, secret
MongoDB connection string(s), semicolon-separated. Format: mongodb://<user>:<password>@<host>:27017/<database>?alias=dev — alias is required.
REDIS
Optional, 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.
ELASTICSEARCH
Optional, 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.
KAFKA
Optional, secret
Kafka connection string(s), semicolon-separated. Format: kafka://<user>:<password>@<broker1>:9092,<broker2>:9092?alias=dev&mechanism=plain — alias is required.
DYNAMODB_REGION
Optional
AWS region for DynamoDB. DynamoDB is configured with discrete variables instead of a connection string.
DYNAMODB_ACCESS_KEY_ID
Optional, secret
AWS access key ID for DynamoDB.
DYNAMODB_SECRET_ACCESS_KEY
Optional, secret
AWS secret access key for DynamoDB.

Details

Package[email protected] (NPM, stdio)
First published9 Aug 2026
Last updated9 Aug 2026
Registry nameio.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.