DBHub Analytics

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

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

Source code Set it up

Connect Runs on your machine

Terminal

claude mcp add dbhub-analytics -e DSN=<DSN> -e DB_TYPE=<DB_TYPE> -e DB_HOST=<DB_HOST> -e DB_PORT=<DB_PORT> -e DB_USER=<DB_USER> -e DB_PASSWORD=<DB_PASSWORD> -e DB_NAME=<DB_NAME> -e TRANSPORT=<TRANSPORT> -e PORT=<PORT> -e ID=<ID> -e SSH_HOST=<SSH_HOST> -e SSH_PORT=<SSH_PORT> -e SSH_USER=<SSH_USER> -e SSH_PASSWORD=<SSH_PASSWORD> -e SSH_KEY=<SSH_KEY> -e SSH_PASSPHRASE=<SSH_PASSPHRASE> -- npx -y [email protected]

claude_desktop_config.json

{
  "mcpServers": {
    "dbhub-analytics": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "DSN": "<DSN>",
        "DB_TYPE": "<DB_TYPE>",
        "DB_HOST": "<DB_HOST>",
        "DB_PORT": "<DB_PORT>",
        "DB_USER": "<DB_USER>",
        "DB_PASSWORD": "<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": "<SSH_PASSWORD>",
        "SSH_KEY": "<SSH_KEY>",
        "SSH_PASSPHRASE": "<SSH_PASSPHRASE>"
      }
    }
  }
}

~/.cursor/mcp.json

{
  "mcpServers": {
    "dbhub-analytics": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "DSN": "<DSN>",
        "DB_TYPE": "<DB_TYPE>",
        "DB_HOST": "<DB_HOST>",
        "DB_PORT": "<DB_PORT>",
        "DB_USER": "<DB_USER>",
        "DB_PASSWORD": "<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": "<SSH_PASSWORD>",
        "SSH_KEY": "<SSH_KEY>",
        "SSH_PASSPHRASE": "<SSH_PASSPHRASE>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "dbhub-analytics": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "DSN": "<DSN>",
        "DB_TYPE": "<DB_TYPE>",
        "DB_HOST": "<DB_HOST>",
        "DB_PORT": "<DB_PORT>",
        "DB_USER": "<DB_USER>",
        "DB_PASSWORD": "<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": "<SSH_PASSWORD>",
        "SSH_KEY": "<SSH_KEY>",
        "SSH_PASSPHRASE": "<SSH_PASSPHRASE>"
      }
    }
  }
}

Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.

Tools

This server runs locally, so its tools are listed by your MCP client once it starts.

Environment variables

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

Details

Package	`[email protected]` (NPM, stdio)
First published	2 Apr 2026
Last updated	2 Apr 2026
Registry name	`io.github.amansingh63/dbhub-analytics`

More databases servers See all

Live status

Local install

Installed and run on your own machine, so there is no public endpoint to check.

Pair it with live search

Agents that use DBHub Analytics often also need current facts. NestDaddy MCP gives your AI today's internet: web search, real-time breaking news and full page reading in one connector.

See NestDaddy MCP

For maintainers

[![NestDaddy MCP](https://nestdaddy.com/mcp/servers/io-github-amansingh63-dbhub-analytics/badge.svg)](https://nestdaddy.com/mcp/servers/io-github-amansingh63-dbhub-analytics)

Add the badge to your README. It turns green while your server passes our daily check. Listing details come from the official MCP registry; update them there.

Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.