DBHub Analytics MCP Server

Name: DBHub Analytics MCP Server
Author: io.github.amansingh63

io.github.amansingh63/dbhub-analytics

Repository Registry

What is the DBHub Analytics MCP server?

MCP server for Databricks, BigQuery, PostgreSQL, MySQL, SQL Server, SQLite, MariaDB

How to install DBHub Analytics

Copy-paste configuration for popular MCP clients.

transport: stdio

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

Environment / auth

DSN
secret
Database connection string (e.g., postgres://user:pass@host:5432/db)
DB_TYPE
Database type: postgres, mysql, mariadb, sqlserver, sqlite, databricks, bigquery
DB_HOST
Database hostname
DB_PORT
Database port
DB_USER
Database username
DB_PASSWORD
secret
Database password
DB_NAME
Database name or SQLite file path
TRANSPORT
Transport mode: stdio or http
PORT
HTTP server port (default: 8080)
ID
Instance identifier for tool names
SSH_HOST
SSH server hostname
SSH_PORT
SSH server port (default: 22)
SSH_USER
SSH username
SSH_PASSWORD
secret
SSH password
SSH_KEY
Path to SSH private key
SSH_PASSPHRASE
secret
SSH key passphrase

Claude Desktop

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

{
  "mcpServers": {
    "dbhub-analytics": {
      "command": "npx",
      "args": [
        "-y",
        "dbhub-analytics"
      ],
      "env": {
        "DSN": "<YOUR_DSN>",
        "DB_TYPE": "<YOUR_DB_TYPE>",
        "DB_HOST": "<YOUR_DB_HOST>",
        "DB_PORT": "<YOUR_DB_PORT>",
        "DB_USER": "<YOUR_DB_USER>",
        "DB_PASSWORD": "<YOUR_DB_PASSWORD>",
        "DB_NAME": "<YOUR_DB_NAME>",
        "TRANSPORT": "<YOUR_TRANSPORT>",
        "PORT": "<YOUR_PORT>",
        "ID": "<YOUR_ID>",
        "SSH_HOST": "<YOUR_SSH_HOST>",
        "SSH_PORT": "<YOUR_SSH_PORT>",
        "SSH_USER": "<YOUR_SSH_USER>",
        "SSH_PASSWORD": "<YOUR_SSH_PASSWORD>",
        "SSH_KEY": "<YOUR_SSH_KEY>",
        "SSH_PASSPHRASE": "<YOUR_SSH_PASSPHRASE>"
      }
    }
  }
}

Cursor

~/.cursor/mcp.json

{
  "mcpServers": {
    "dbhub-analytics": {
      "command": "npx",
      "args": [
        "-y",
        "dbhub-analytics"
      ],
      "env": {
        "DSN": "<YOUR_DSN>",
        "DB_TYPE": "<YOUR_DB_TYPE>",
        "DB_HOST": "<YOUR_DB_HOST>",
        "DB_PORT": "<YOUR_DB_PORT>",
        "DB_USER": "<YOUR_DB_USER>",
        "DB_PASSWORD": "<YOUR_DB_PASSWORD>",
        "DB_NAME": "<YOUR_DB_NAME>",
        "TRANSPORT": "<YOUR_TRANSPORT>",
        "PORT": "<YOUR_PORT>",
        "ID": "<YOUR_ID>",
        "SSH_HOST": "<YOUR_SSH_HOST>",
        "SSH_PORT": "<YOUR_SSH_PORT>",
        "SSH_USER": "<YOUR_SSH_USER>",
        "SSH_PASSWORD": "<YOUR_SSH_PASSWORD>",
        "SSH_KEY": "<YOUR_SSH_KEY>",
        "SSH_PASSPHRASE": "<YOUR_SSH_PASSPHRASE>"
      }
    }
  }
}

Windsurf

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "dbhub-analytics": {
      "command": "npx",
      "args": [
        "-y",
        "dbhub-analytics"
      ],
      "env": {
        "DSN": "<YOUR_DSN>",
        "DB_TYPE": "<YOUR_DB_TYPE>",
        "DB_HOST": "<YOUR_DB_HOST>",
        "DB_PORT": "<YOUR_DB_PORT>",
        "DB_USER": "<YOUR_DB_USER>",
        "DB_PASSWORD": "<YOUR_DB_PASSWORD>",
        "DB_NAME": "<YOUR_DB_NAME>",
        "TRANSPORT": "<YOUR_TRANSPORT>",
        "PORT": "<YOUR_PORT>",
        "ID": "<YOUR_ID>",
        "SSH_HOST": "<YOUR_SSH_HOST>",
        "SSH_PORT": "<YOUR_SSH_PORT>",
        "SSH_USER": "<YOUR_SSH_USER>",
        "SSH_PASSWORD": "<YOUR_SSH_PASSWORD>",
        "SSH_KEY": "<YOUR_SSH_KEY>",
        "SSH_PASSPHRASE": "<YOUR_SSH_PASSPHRASE>"
      }
    }
  }
}

VS Code

.vscode/mcp.json

{
  "servers": {
    "dbhub-analytics": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "dbhub-analytics"
      ],
      "env": {
        "DSN": "<YOUR_DSN>",
        "DB_TYPE": "<YOUR_DB_TYPE>",
        "DB_HOST": "<YOUR_DB_HOST>",
        "DB_PORT": "<YOUR_DB_PORT>",
        "DB_USER": "<YOUR_DB_USER>",
        "DB_PASSWORD": "<YOUR_DB_PASSWORD>",
        "DB_NAME": "<YOUR_DB_NAME>",
        "TRANSPORT": "<YOUR_TRANSPORT>",
        "PORT": "<YOUR_PORT>",
        "ID": "<YOUR_ID>",
        "SSH_HOST": "<YOUR_SSH_HOST>",
        "SSH_PORT": "<YOUR_SSH_PORT>",
        "SSH_USER": "<YOUR_SSH_USER>",
        "SSH_PASSWORD": "<YOUR_SSH_PASSWORD>",
        "SSH_KEY": "<YOUR_SSH_KEY>",
        "SSH_PASSPHRASE": "<YOUR_SSH_PASSPHRASE>"
      }
    }
  }
}

Claude Code

claude mcp add dbhub-analytics --env DSN=<YOUR_DSN> --env DB_TYPE=<YOUR_DB_TYPE> --env DB_HOST=<YOUR_DB_HOST> --env DB_PORT=<YOUR_DB_PORT> --env DB_USER=<YOUR_DB_USER> --env DB_PASSWORD=<YOUR_DB_PASSWORD> --env DB_NAME=<YOUR_DB_NAME> --env TRANSPORT=<YOUR_TRANSPORT> --env PORT=<YOUR_PORT> --env ID=<YOUR_ID> --env SSH_HOST=<YOUR_SSH_HOST> --env SSH_PORT=<YOUR_SSH_PORT> --env SSH_USER=<YOUR_SSH_USER> --env SSH_PASSWORD=<YOUR_SSH_PASSWORD> --env SSH_KEY=<YOUR_SSH_KEY> --env SSH_PASSPHRASE=<YOUR_SSH_PASSPHRASE> -- npx -y dbhub-analytics