db-gateway

{
  "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
  "name": "io.github.sijunkim/db-gateway",
  "description": "145+ tools across 8 databases: MySQL, PostgreSQL, Redshift, MongoDB, Redis, Kafka, and more",
  "repository": {
    "url": "https://github.com/sijunkim/db-gateway",
    "source": "github"
  },
  "version": "1.0.4",
  "packages": [
    {
      "registryType": "npm",
      "identifier": "db-gateway",
      "version": "1.0.4",
      "transport": {
        "type": "stdio"
      },
      "environmentVariables": [
        {
          "description": "Engines to enable, comma-separated. Only the listed engines get their tools registered. Example: mysql,redis,kafka",
          "isRequired": true,
          "format": "string",
          "name": "DBS"
        },
        {
          "description": "Set to true to hide every write tool and restrict *_execute_query to SELECT-style statements. Recommended when pointing at production.",
          "format": "string",
          "name": "READ_ONLY"
        },
        {
          "description": "MySQL connection string(s), semicolon-separated for multiple instances. Format: mysql://<user>:<password>@<host>:3306/<database>?alias=dev&default=true — alias is required.",
          "format": "string",
          "isSecret": true,
          "name": "MYSQL"
        },
        {
          "description": "PostgreSQL connection string(s), semicolon-separated. Format: postgresql://<user>:<password>@<host>:5432/<database>?alias=dev&ssl=true — alias is required.",
          "format": "string",
          "isSecret": true,
          "name": "POSTGRESQL"
        },
        {
          "description": "Redshift connection string(s), semicolon-separated. Format: redshift://<user>:<password>@<host>:5439/<database>?alias=dev&ssl=true — alias is required.",
          "format": "string",
          "isSecret": true,
          "name": "REDSHIFT"
        },
        {
          "description": "MongoDB connection string(s), semicolon-separated. Format: mongodb://<user>:<password>@<host>:27017/<database>?alias=dev — alias is required.",
          "format": "string",
          "isSecret": true,
          "name": "MONGODB"
        },
        {
          "description": "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.",
          "format": "string",
          "isSecret": true,
          "name": "REDIS"
        },
        {
          "description": "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.",
          "format": "string",
          "isSecret": true,
          "name": "ELASTICSEARCH"
        },
        {
          "description": "Kafka connection string(s), semicolon-separated. Format: kafka://<user>:<password>@<broker1>:9092,<broker2>:9092?alias=dev&mechanism=plain — alias is required.",
          "format": "string",
          "isSecret": true,
          "name": "KAFKA"
        },
        {
          "description": "AWS region for DynamoDB. DynamoDB is configured with discrete variables instead of a connection string.",
          "format": "string",
          "name": "DYNAMODB_REGION"
        },
        {
          "description": "AWS access key ID for DynamoDB.",
          "format": "string",
          "isSecret": true,
          "name": "DYNAMODB_ACCESS_KEY_ID"
        },
        {
          "description": "AWS secret access key for DynamoDB.",
          "format": "string",
          "isSecret": true,
          "name": "DYNAMODB_SECRET_ACCESS_KEY"
        }
      ]
    }
  ]
}