DBHub Analytics

MCP

by amansingh63 · v0.2.0

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

mcplocal

MCP configuration

stdio

Command

npx -y dbhub-analytics@0.2.0

Environment

  • DSNsecret

    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_PASSWORDsecret

    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_PASSWORDsecret

    SSH password

  • SSH_KEY

    Path to SSH private key

  • SSH_PASSPHRASEsecret

    SSH key passphrase

Install in one click with Zurek

Browse here, install from the native macOS app — pick targets, fill env vars, and write configs safely.