Databases (read-only, switchable) MCP Setup & Guide

{
  "id": "io.github.shibbirweb/mcp-db-read-only",
  "type": "mcp-server",
  "version": "1.1.0",
  "displayName": "Databases (read-only, switchable)",
  "description": "Read-only SQL, MongoDB, Redis and Elasticsearch access, switchable mid-conversation.",
  "repository": {
    "url": "https://github.com/shibbirweb/mcp-db-read-only",
    "source": "github"
  },
  "homepage": "https://github.com/shibbirweb/mcp-db-read-only#readme",
  "distribution": {
    "packages": [
      {
        "registryType": "npm",
        "identifier": "@shibbirweb/mcp-db-read-only",
        "version": "1.1.0",
        "transport": "stdio",
        "environmentVariables": [
          {
            "name": "DB_URL",
            "description": "Connection URL to open at startup, e.g. postgres://user@host:5432/db, mongodb://user@host/db, redis://host:6379/0 or sqlite:///data/app.db"
          },
          {
            "name": "DB_PASSWORD",
            "description": "Password for DB_URL, so it need not be percent-encoded inside the URL",
            "isSecret": true
          },
          {
            "name": "DB_PROFILES",
            "description": "JSON object of named connections to switch between, each a URL or {\"url\", \"password\"}",
            "isSecret": true
          },
          {
            "name": "DB_DEFAULT_PROFILE",
            "description": "Which DB_PROFILES entry to start on"
          },
          {
            "name": "DB_CONNECT_TIMEOUT_MS",
            "description": "Connection timeout in milliseconds. Defaults to 10000"
          },
          {
            "name": "DB_QUERY_TIMEOUT_MS",
            "description": "Server-side query timeout in milliseconds. Defaults to 30000"
          },
          {
            "name": "DB_LOG",
            "description": "true logs every tool call, its statements and full output to stderr. Off by default"
          },
          {
            "name": "DB_LOG_FILE",
            "description": "Log every tool call to this file instead. Implies DB_LOG"
          },
          {
            "name": "DB_LOG_DIR",
            "description": "Save every tool call as its own JSON file in this folder, permanently. Implies logging"
          },
          {
            "name": "DB_LOG_FORMAT",
            "description": "pretty (default) or json, one object per line"
          },
          {
            "name": "DB_LOG_PORT",
            "description": "Serve a live log viewer in the browser on this port. Needs DB_LOG_DIR, DB_LOG or DB_LOG_FILE. No access control"
          },
          {
            "name": "DB_LOG_HISTORY",
            "description": "Entries the viewer keeps in memory when DB_LOG_DIR is not set. Defaults to 500"
          },
          {
            "name": "MYSQL_HOST",
            "description": "Legacy MySQL-only form, kept for drop-in compatibility. Prefer DB_URL"
          },
          {
            "name": "MYSQL_USER",
            "description": "Legacy MySQL-only form. Prefer DB_URL"
          },
          {
            "name": "MYSQL_PASSWORD",
            "description": "Legacy MySQL-only form. Prefer DB_URL with DB_PASSWORD",
            "isSecret": true
          },
          {
            "name": "MYSQL_DATABASE",
            "description": "Legacy MySQL-only form. Prefer DB_URL"
          }
        ]
      },
      {
        "registryType": "oci",
        "identifier": "docker.io/shibbirweb/mcp-db-read-only:1.1.0",
        "transport": "stdio",
        "environmentVariables": [
          {
            "name": "DB_URL",
            "description": "Connection URL to open at startup, e.g. postgres://user@host:5432/db, mongodb://user@host/db, redis://host:6379/0 or sqlite:///data/app.db. Use host.docker.internal to reach the host"
          },
          {
            "name": "DB_PASSWORD",
            "description": "Password for DB_URL, so it need not be percent-encoded inside the URL",
            "isSecret": true
          },
          {
            "name": "DB_PROFILES",
            "description": "JSON object of named connections to switch between, each a URL or {\"url\", \"password\"}",
            "isSecret": true
          },
          {
            "name": "DB_DEFAULT_PROFILE",
            "description": "Which DB_PROFILES entry to start on"
          },
          {
            "name": "DB_CONNECT_TIMEOUT_MS",
            "description": "Connection timeout in milliseconds. Defaults to 10000"
          },
          {
            "name": "DB_QUERY_TIMEOUT_MS",
            "description": "Server-side query timeout in milliseconds. Defaults to 30000"
          },
          {
            "name": "DB_LOG",
            "description": "true logs every tool call, its statements and full output to stderr. Off by default"
          },
          {
            "name": "DB_LOG_FILE",
            "description": "Log every tool call to this file instead, on a mounted volume. Implies DB_LOG"
          },
          {
            "name": "DB_LOG_DIR",
            "description": "Save every tool call as its own JSON file in this folder, on a mounted volume. Implies logging"
          },
          {
            "name": "DB_LOG_FORMAT",
            "description": "pretty (default) or json, one object per line"
          },
          {
            "name": "DB_LOG_PORT",
            "description": "Serve a live log viewer on this port (publish it with -p). Needs DB_LOG_DIR, DB_LOG or DB_LOG_FILE. No access control"
          },
          {
            "name": "DB_LOG_HISTORY",
            "description": "Entries the viewer keeps in memory when DB_LOG_DIR is not set. Defaults to 500"
          },
          {
            "name": "MYSQL_HOST",
            "description": "Legacy MySQL-only form, kept for drop-in compatibility. Prefer DB_URL"
          },
          {
            "name": "MYSQL_USER",
            "description": "Legacy MySQL-only form. Prefer DB_URL"
          },
          {
            "name": "MYSQL_PASSWORD",
            "description": "Legacy MySQL-only form. Prefer DB_URL with DB_PASSWORD",
            "isSecret": true
          },
          {
            "name": "MYSQL_DATABASE",
            "description": "Legacy MySQL-only form. Prefer DB_URL"
          }
        ]
      }
    ],
    "remotes": []
  },
  "dependencies": [],
  "installTargets": [
    "claude-code",
    "claude-desktop",
    "cursor",
    "vscode",
    "trae",
    "cherry-studio",
    "lingma",
    "windsurf",
    "cline",
    "workbuddy"
  ],
  "keywords": [],
  "provenance": {
    "origin": "official-mcp-registry",
    "originalId": "io.github.shibbirweb/mcp-db-read-only",
    "originalUrl": "https://registry.modelcontextprotocol.io/v0.1/servers/io.github.shibbirweb%2Fmcp-db-read-only/versions/latest",
    "isOfficial": true,
    "status": "active"
  }
}