# Db Gateway

> Db Gateway is an open-source MCP server for databases. 145+ tools across 8 databases: MySQL, PostgreSQL, Redshift, MongoDB, Redis, Kafka, and more. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **Pricing:** Open source
- **Repository:** https://github.com/sijunkim/db-gateway
- **MCP Registry name:** io.github.sijunkim/db-gateway
- **Categories:** databases
- **Listing updated:** 2026-11-13

## About

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

## Install

### Claude Code (Terminal)

```sh
claude mcp add db-gateway --env DBS='<DBS>' --env MYSQL='<MYSQL>' --env POSTGRESQL='<POSTGRESQL>' --env REDSHIFT='<REDSHIFT>' --env MONGODB='<MONGODB>' --env REDIS='<REDIS>' --env ELASTICSEARCH='<ELASTICSEARCH>' --env KAFKA='<KAFKA>' --env DYNAMODB_ACCESS_KEY_ID='<DYNAMODB_ACCESS_KEY_ID>' --env DYNAMODB_SECRET_ACCESS_KEY='<DYNAMODB_SECRET_ACCESS_KEY>' -- npx -y db-gateway
```

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "db-gateway": {
      "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>"
      }
    }
  }
}
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "db-gateway": {
      "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>"
      }
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "db-gateway": {
      "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>"
      }
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "db-gateway": {
      "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>"
      }
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "db-gateway": {
      "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>"
      }
    }
  }
}
```

## FAQ

### Is Db Gateway free?

Yes. Db Gateway is open source, so you can use and self-host it for free.

### How do I add Db Gateway to Claude Code?

Run this command in your terminal: claude mcp add db-gateway --env DBS='<DBS>' --env MYSQL='<MYSQL>' --env POSTGRESQL='<POSTGRESQL>' --env REDSHIFT='<REDSHIFT>' --env MONGODB='<MONGODB>' --env REDIS='<REDIS>' --env ELASTICSEARCH='<ELASTICSEARCH>' --env KAFKA='<KAFKA>' --env DYNAMODB_ACCESS_KEY_ID='<DYNAMODB_ACCESS_KEY_ID>' --env DYNAMODB_SECRET_ACCESS_KEY='<DYNAMODB_SECRET_ACCESS_KEY>' -- npx -y db-gateway

### What are the best alternatives to Db Gateway?

The closest alternatives to Db Gateway are Midplane, PlatypusDB, Lorebase, Sovaria and model2data studio.

## Alternatives

- [Midplane](https://ai-powered.com/mcp/midplane): Midplane is an open-source MCP server for databases.
- [PlatypusDB](https://ai-powered.com/mcp/platypusdb): PlatypusDB is an open-source MCP server for databases.
- [Lorebase](https://ai-powered.com/mcp/lorebase): Lorebase is an open-source MCP server for knowledge and memory.
- [Sovaria](https://ai-powered.com/mcp/sovaria): Sovaria is a freemium MCP server for databases.
- [model2data studio](https://ai-powered.com/mcp/model2data-studio): model2data studio is a freemium MCP server for databases.
- [semlayer](https://ai-powered.com/mcp/semlayer): semlayer is a free MCP server for databases.
- [bricksentry](https://ai-powered.com/mcp/bricksentry): bricksentry is an open-source MCP server for databases.
- [MCP Toolbox for Databases](https://ai-powered.com/mcp/mcp-toolbox-for-databases-2): MCP Toolbox for Databases is an open-source MCP server for databases.

---
Source: https://ai-powered.com/mcp/db-gateway-2
