Skip to content
MCP server

DBHub Analytics

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

Runs locallyStatus and history
Pricing
Open source
Runs
Locally
Version
0.2.0
Listing updated
4 days ago

About DBHub Analytics

DBHub Analytics is an open-source MCP server for databases. It runs locally on your machine and is started by your AI client.

Install

Run in a terminal

claude mcp add dbhub-analytics --env DSN='<DSN>' --env DB_PASSWORD='<DB_PASSWORD>' --env SSH_PASSWORD='<SSH_PASSWORD>' --env SSH_PASSPHRASE='<SSH_PASSPHRASE>' -- npx -y dbhub-analytics

Add to claude_desktop_config.json

{
  "mcpServers": {
    "dbhub-analytics": {
      "command": "npx",
      "args": [
        "-y",
        "dbhub-analytics"
      ],
      "env": {
        "DSN": "<DSN>",
        "DB_PASSWORD": "<DB_PASSWORD>",
        "SSH_PASSWORD": "<SSH_PASSWORD>",
        "SSH_PASSPHRASE": "<SSH_PASSPHRASE>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "dbhub-analytics": {
      "command": "npx",
      "args": [
        "-y",
        "dbhub-analytics"
      ],
      "env": {
        "DSN": "<DSN>",
        "DB_PASSWORD": "<DB_PASSWORD>",
        "SSH_PASSWORD": "<SSH_PASSWORD>",
        "SSH_PASSPHRASE": "<SSH_PASSPHRASE>"
      }
    }
  }
}

Add to .vscode/mcp.json

{
  "servers": {
    "dbhub-analytics": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "dbhub-analytics"
      ],
      "env": {
        "DSN": "<DSN>",
        "DB_PASSWORD": "<DB_PASSWORD>",
        "SSH_PASSWORD": "<SSH_PASSWORD>",
        "SSH_PASSPHRASE": "<SSH_PASSPHRASE>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "dbhub-analytics": {
      "command": "npx",
      "args": [
        "-y",
        "dbhub-analytics"
      ],
      "env": {
        "DSN": "<DSN>",
        "DB_PASSWORD": "<DB_PASSWORD>",
        "SSH_PASSWORD": "<SSH_PASSWORD>",
        "SSH_PASSPHRASE": "<SSH_PASSPHRASE>"
      }
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "dbhub-analytics": {
      "command": "npx",
      "args": [
        "-y",
        "dbhub-analytics"
      ],
      "env": {
        "DSN": "<DSN>",
        "DB_PASSWORD": "<DB_PASSWORD>",
        "SSH_PASSWORD": "<SSH_PASSWORD>",
        "SSH_PASSPHRASE": "<SSH_PASSPHRASE>"
      }
    }
  }
}

Configuration

  • DSNDatabase connection string (e.g., postgres://user:pass@host:5432/db)
  • DB_TYPEDatabase type: postgres, mysql, mariadb, sqlserver, sqlite, databricks, bigquery
  • DB_HOSTDatabase hostname
  • DB_PORTDatabase port
  • DB_USERDatabase username
  • DB_PASSWORDDatabase password
  • DB_NAMEDatabase name or SQLite file path
  • TRANSPORTTransport mode: stdio or http
  • PORTHTTP server port (default: 8080)
  • IDInstance identifier for tool names
  • SSH_HOSTSSH server hostname
  • SSH_PORTSSH server port (default: 22)
  • SSH_USERSSH username
  • SSH_PASSWORDSSH password
  • SSH_KEYPath to SSH private key
  • SSH_PASSPHRASESSH key passphrase

Pricing

Open source

DBHub Analytics FAQ

Is DBHub Analytics free?

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

How do I add DBHub Analytics to Claude Code?

Run this command in your terminal: claude mcp add dbhub-analytics --env DSN='<DSN>' --env DB_PASSWORD='<DB_PASSWORD>' --env SSH_PASSWORD='<SSH_PASSWORD>' --env SSH_PASSPHRASE='<SSH_PASSPHRASE>' -- npx -y dbhub-analytics

What are the best alternatives to DBHub Analytics?

The closest alternatives to DBHub Analytics are Agent-Native Analytics, Google Ads + Meta Ads + SEO/GEO MCP, Tapetide - Indian Stock Market MCP, Midplane and World Monitor.

Alternatives to DBHub Analytics

  1. Open-source analytics app where an AI agent builds charts and dashboards from your data

    • Remote
    • Open source
    • 7.7K GitHub stars
    • Analytics and data
  2. Hosted MCP connector for managing Google Ads, Meta Ads, GA4 and Search Console from chat

    • 8 tools
    • Remote
    • Freemium
    • 8.1K GitHub stars
    • Marketing and SEO
  3. Indian NSE and BSE stock market data for AI assistants through 48 MCP tools

    • 17 tools
    • Remote
    • Freemium
    • 150 GitHub stars
    • Finance and payments
  4. Midplane

    MCP server

    Postgres gateway for AI agents with table grants, column masking and approval for writes

    Runs locally
    • Open source
    • 5 GitHub stars
    • Databases
  5. World Monitor

    MCP server

    Live geopolitical intelligence dashboard with an API and MCP server for agents

    • Remote
    • Freemium
    • Analytics and data
  6. CompanyData

    MCP server

    Search and enrich company records from official registers via the CompanyData API

    • 3 tools
    • Remote
    • Paid
    • 3 GitHub stars
    • Analytics and data