DB Gateway MCP Server

by sijunkimio.github.sijunkim/db-gatewayv1.0.4

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

0Node.jsstdioofficial registry

context tax

queued

security

queued

cold start

queued

freshness

Maintained2mo ago

Install DB Gateway MCP server

claude mcp add db-gateway-sijunkim -e DBS='<dbs>' -e MYSQL='<mysql>' -e POSTGRESQL='<postgresql>' -e REDSHIFT='<redshift>' -e MONGODB='<mongodb>' -e REDIS='<redis>' -e ELASTICSEARCH='<elasticsearch>' -e KAFKA='<kafka>' -e DYNAMODB_ACCESS_KEY_ID='<dynamodb-access-key-id>' -e DYNAMODB_SECRET_ACCESS_KEY='<dynamodb-secret-access-key>' -- npx -y db-gateway

{
  "mcpServers": {
    "db-gateway-sijunkim": {
      "command": "npx",
      "args": [
        "-y",
        "db-gateway"
      ],
      "env": {
        "DBS": "<dbs>",
        "MYSQL": "<mysql>",
        "POSTGRESQL": "<postgresql>",
        "REDSHIFT": "<redshift>",
        "MONGODB": "<mongodb>",
        "REDIS": "<redis>",
        "ELASTICSEARCH": "<elasticsearch>",
        "KAFKA": "<kafka>",
        "DYNAMODB_ACCESS_KEY_ID": "<dynamodb-access-key-id>",
        "DYNAMODB_SECRET_ACCESS_KEY": "<dynamodb-secret-access-key>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).

{
  "mcpServers": {
    "db-gateway-sijunkim": {
      "command": "npx",
      "args": [
        "-y",
        "db-gateway"
      ],
      "env": {
        "DBS": "<dbs>",
        "MYSQL": "<mysql>",
        "POSTGRESQL": "<postgresql>",
        "REDSHIFT": "<redshift>",
        "MONGODB": "<mongodb>",
        "REDIS": "<redis>",
        "ELASTICSEARCH": "<elasticsearch>",
        "KAFKA": "<kafka>",
        "DYNAMODB_ACCESS_KEY_ID": "<dynamodb-access-key-id>",
        "DYNAMODB_SECRET_ACCESS_KEY": "<dynamodb-secret-access-key>"
      }
    }
  }
}

Settings → Developer → Edit Config (claude_desktop_config.json), then restart.

{
  "servers": {
    "db-gateway-sijunkim": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "db-gateway"
      ],
      "env": {
        "DBS": "<dbs>",
        "MYSQL": "<mysql>",
        "POSTGRESQL": "<postgresql>",
        "REDSHIFT": "<redshift>",
        "MONGODB": "<mongodb>",
        "REDIS": "<redis>",
        "ELASTICSEARCH": "<elasticsearch>",
        "KAFKA": "<kafka>",
        "DYNAMODB_ACCESS_KEY_ID": "<dynamodb-access-key-id>",
        "DYNAMODB_SECRET_ACCESS_KEY": "<dynamodb-secret-access-key>"
      }
    }
  }
}

Add to .vscode/mcp.json in your workspace.

{
  "mcpServers": {
    "db-gateway-sijunkim": {
      "command": "npx",
      "args": [
        "-y",
        "db-gateway"
      ],
      "env": {
        "DBS": "<dbs>",
        "MYSQL": "<mysql>",
        "POSTGRESQL": "<postgresql>",
        "REDSHIFT": "<redshift>",
        "MONGODB": "<mongodb>",
        "REDIS": "<redis>",
        "ELASTICSEARCH": "<elasticsearch>",
        "KAFKA": "<kafka>",
        "DYNAMODB_ACCESS_KEY_ID": "<dynamodb-access-key-id>",
        "DYNAMODB_SECRET_ACCESS_KEY": "<dynamodb-secret-access-key>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json.

Configuration

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

Freshness

Maintained — last maintenance signal 2mo ago. The newest of the signals below sets the band.

Last commit (default branch)
2026-08-09 · 2mo ago · GitHub
Latest release
2026-08-09 · 2mo ago · GitHub · v1.0.4
Package published
no data · npm/PyPI
Registry entry updated
2026-08-09 · 2mo ago · official registry · v1.0.4

FAQ

›How do I install the DB Gateway MCP server in Claude Code?

Run: claude mcp add db-gateway-sijunkim -e DBS='<dbs>' -e MYSQL='<mysql>' -e POSTGRESQL='<postgresql>' -e REDSHIFT='<redshift>' -e MONGODB='<mongodb>' -e REDIS='<redis>' -e ELASTICSEARCH='<elasticsearch>' -e KAFKA='<kafka>' -e DYNAMODB_ACCESS_KEY_ID='<dynamodb-access-key-id>' -e DYNAMODB_SECRET_ACCESS_KEY='<dynamodb-secret-access-key>' -- npx -y db-gateway. For Cursor, VS Code, Claude Desktop and Windsurf, use the install tabs above.

›Does DB Gateway require an API key?

Yes. It expects DBS, MYSQL, POSTGRESQL, REDSHIFT, MONGODB, REDIS, ELASTICSEARCH, KAFKA, DYNAMODB_ACCESS_KEY_ID, DYNAMODB_SECRET_ACCESS_KEY, of which 9 are secrets.

›Can I use DB Gateway as a remote (hosted) MCP server?

No hosted endpoint is published; it runs locally over stdio.

›Is DB Gateway in the official MCP registry?

Yes, as io.github.sijunkim/db-gateway.