io.github.sijunkim/db-gateway MCP Server

Name: io.github.sijunkim/db-gateway MCP Server
Author: io.github.sijunkim

io.github.sijunkim/db-gateway

Repository Registry

What is the io.github.sijunkim/db-gateway MCP server?

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

How to install io.github.sijunkim/db-gateway

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

DBS
required
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
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
secret
PostgreSQL connection string(s), semicolon-separated. Format: postgresql://<user>:<password>@<host>:5432/<database>?alias=dev&ssl=true — alias is required.
REDSHIFT
secret
Redshift connection string(s), semicolon-separated. Format: redshift://<user>:<password>@<host>:5439/<database>?alias=dev&ssl=true — alias is required.
MONGODB
secret
MongoDB connection string(s), semicolon-separated. Format: mongodb://<user>:<password>@<host>:27017/<database>?alias=dev — alias is required.
REDIS
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
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
secret
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
secret
AWS access key ID for DynamoDB.
DYNAMODB_SECRET_ACCESS_KEY
secret
AWS secret access key for DynamoDB.

Claude Desktop

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "db-gateway": {
      "command": "npx",
      "args": [
        "-y",
        "db-gateway"
      ],
      "env": {
        "DBS": "<YOUR_DBS>",
        "READ_ONLY": "<YOUR_READ_ONLY>",
        "MYSQL": "<YOUR_MYSQL>",
        "POSTGRESQL": "<YOUR_POSTGRESQL>",
        "REDSHIFT": "<YOUR_REDSHIFT>",
        "MONGODB": "<YOUR_MONGODB>",
        "REDIS": "<YOUR_REDIS>",
        "ELASTICSEARCH": "<YOUR_ELASTICSEARCH>",
        "KAFKA": "<YOUR_KAFKA>",
        "DYNAMODB_REGION": "<YOUR_DYNAMODB_REGION>",
        "DYNAMODB_ACCESS_KEY_ID": "<YOUR_DYNAMODB_ACCESS_KEY_ID>",
        "DYNAMODB_SECRET_ACCESS_KEY": "<YOUR_DYNAMODB_SECRET_ACCESS_KEY>"
      }
    }
  }
}

Cursor

~/.cursor/mcp.json

{
  "mcpServers": {
    "db-gateway": {
      "command": "npx",
      "args": [
        "-y",
        "db-gateway"
      ],
      "env": {
        "DBS": "<YOUR_DBS>",
        "READ_ONLY": "<YOUR_READ_ONLY>",
        "MYSQL": "<YOUR_MYSQL>",
        "POSTGRESQL": "<YOUR_POSTGRESQL>",
        "REDSHIFT": "<YOUR_REDSHIFT>",
        "MONGODB": "<YOUR_MONGODB>",
        "REDIS": "<YOUR_REDIS>",
        "ELASTICSEARCH": "<YOUR_ELASTICSEARCH>",
        "KAFKA": "<YOUR_KAFKA>",
        "DYNAMODB_REGION": "<YOUR_DYNAMODB_REGION>",
        "DYNAMODB_ACCESS_KEY_ID": "<YOUR_DYNAMODB_ACCESS_KEY_ID>",
        "DYNAMODB_SECRET_ACCESS_KEY": "<YOUR_DYNAMODB_SECRET_ACCESS_KEY>"
      }
    }
  }
}

Windsurf

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "db-gateway": {
      "command": "npx",
      "args": [
        "-y",
        "db-gateway"
      ],
      "env": {
        "DBS": "<YOUR_DBS>",
        "READ_ONLY": "<YOUR_READ_ONLY>",
        "MYSQL": "<YOUR_MYSQL>",
        "POSTGRESQL": "<YOUR_POSTGRESQL>",
        "REDSHIFT": "<YOUR_REDSHIFT>",
        "MONGODB": "<YOUR_MONGODB>",
        "REDIS": "<YOUR_REDIS>",
        "ELASTICSEARCH": "<YOUR_ELASTICSEARCH>",
        "KAFKA": "<YOUR_KAFKA>",
        "DYNAMODB_REGION": "<YOUR_DYNAMODB_REGION>",
        "DYNAMODB_ACCESS_KEY_ID": "<YOUR_DYNAMODB_ACCESS_KEY_ID>",
        "DYNAMODB_SECRET_ACCESS_KEY": "<YOUR_DYNAMODB_SECRET_ACCESS_KEY>"
      }
    }
  }
}

VS Code

.vscode/mcp.json

{
  "servers": {
    "db-gateway": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "db-gateway"
      ],
      "env": {
        "DBS": "<YOUR_DBS>",
        "READ_ONLY": "<YOUR_READ_ONLY>",
        "MYSQL": "<YOUR_MYSQL>",
        "POSTGRESQL": "<YOUR_POSTGRESQL>",
        "REDSHIFT": "<YOUR_REDSHIFT>",
        "MONGODB": "<YOUR_MONGODB>",
        "REDIS": "<YOUR_REDIS>",
        "ELASTICSEARCH": "<YOUR_ELASTICSEARCH>",
        "KAFKA": "<YOUR_KAFKA>",
        "DYNAMODB_REGION": "<YOUR_DYNAMODB_REGION>",
        "DYNAMODB_ACCESS_KEY_ID": "<YOUR_DYNAMODB_ACCESS_KEY_ID>",
        "DYNAMODB_SECRET_ACCESS_KEY": "<YOUR_DYNAMODB_SECRET_ACCESS_KEY>"
      }
    }
  }
}

Claude Code

claude mcp add db-gateway --env DBS=<YOUR_DBS> --env READ_ONLY=<YOUR_READ_ONLY> --env MYSQL=<YOUR_MYSQL> --env POSTGRESQL=<YOUR_POSTGRESQL> --env REDSHIFT=<YOUR_REDSHIFT> --env MONGODB=<YOUR_MONGODB> --env REDIS=<YOUR_REDIS> --env ELASTICSEARCH=<YOUR_ELASTICSEARCH> --env KAFKA=<YOUR_KAFKA> --env DYNAMODB_REGION=<YOUR_DYNAMODB_REGION> --env DYNAMODB_ACCESS_KEY_ID=<YOUR_DYNAMODB_ACCESS_KEY_ID> --env DYNAMODB_SECRET_ACCESS_KEY=<YOUR_DYNAMODB_SECRET_ACCESS_KEY> -- npx -y db-gateway