DBHub Analytics

io.github.amansingh63/dbhub-analytics·v0.2.0·Databases

Quality Score

/100

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

Repository →

§01 Install

Claude Desktop (claude_desktop_config.json)

{
  "mcpServers": {
    "dbhub-analytics": {
      "command": "npx",
      "args": [
        "-y",
        "dbhub-analytics"
      ],
      "env": {
        "DSN": "<your-dsn>",
        "DB_TYPE": "<db_type>",
        "DB_HOST": "<db_host>",
        "DB_PORT": "<db_port>",
        "DB_USER": "<db_user>",
        "DB_PASSWORD": "<your-db_password>",
        "DB_NAME": "<db_name>",
        "TRANSPORT": "<transport>",
        "PORT": "<port>",
        "ID": "<id>",
        "SSH_HOST": "<ssh_host>",
        "SSH_PORT": "<ssh_port>",
        "SSH_USER": "<ssh_user>",
        "SSH_PASSWORD": "<your-ssh_password>",
        "SSH_KEY": "<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": "<db_type>",
        "DB_HOST": "<db_host>",
        "DB_PORT": "<db_port>",
        "DB_USER": "<db_user>",
        "DB_PASSWORD": "<your-db_password>",
        "DB_NAME": "<db_name>",
        "TRANSPORT": "<transport>",
        "PORT": "<port>",
        "ID": "<id>",
        "SSH_HOST": "<ssh_host>",
        "SSH_PORT": "<ssh_port>",
        "SSH_USER": "<ssh_user>",
        "SSH_PASSWORD": "<your-ssh_password>",
        "SSH_KEY": "<ssh_key>",
        "SSH_PASSPHRASE": "<your-ssh_passphrase>"
      }
    }
  }
}

Cline (cline_mcp_settings.json)

npx -y dbhub-analytics

§02 Environment variables

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

§03 MCP Quality Score · methodology

freshness

completeness

installability

documentation

stability

§04 Alternatives in Databases

ai.haymon/dbmcp

Database MCP server for MySQL, MariaDB, PostgreSQL & SQLite

ai.smithery/MisterSandFR-supabase-mcp-selfhosted

Manage Supabase projects end to end across database, auth, storage, realtime, and migrations. Moni…

ai.smithery/afgong-sqlite-mcp-server

Explore your Messages SQLite database to browse tables and inspect schemas with ease. Run flexible…