Skip to content
VS Code

DBHub Analytics for VS Code

io.github.amansingh63/dbhub-analytics

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

client:VS Code transport:stdio runtime:npm

Install DBHub Analytics in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "dsn",
      "description": "DSN",
      "password": true
    },
    {
      "type": "promptString",
      "id": "db-type",
      "description": "DB_TYPE",
      "password": true
    },
    {
      "type": "promptString",
      "id": "db-host",
      "description": "DB_HOST",
      "password": true
    },
    {
      "type": "promptString",
      "id": "db-port",
      "description": "DB_PORT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "db-user",
      "description": "DB_USER",
      "password": true
    },
    {
      "type": "promptString",
      "id": "db-password",
      "description": "DB_PASSWORD",
      "password": true
    },
    {
      "type": "promptString",
      "id": "db-name",
      "description": "DB_NAME",
      "password": true
    },
    {
      "type": "promptString",
      "id": "transport",
      "description": "TRANSPORT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "port",
      "description": "PORT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "id",
      "description": "ID",
      "password": true
    },
    {
      "type": "promptString",
      "id": "ssh-host",
      "description": "SSH_HOST",
      "password": true
    },
    {
      "type": "promptString",
      "id": "ssh-port",
      "description": "SSH_PORT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "ssh-user",
      "description": "SSH_USER",
      "password": true
    },
    {
      "type": "promptString",
      "id": "ssh-password",
      "description": "SSH_PASSWORD",
      "password": true
    },
    {
      "type": "promptString",
      "id": "ssh-key",
      "description": "SSH_KEY",
      "password": true
    },
    {
      "type": "promptString",
      "id": "ssh-passphrase",
      "description": "SSH_PASSPHRASE",
      "password": true
    }
  ],
  "servers": {
    "dbhub-analytics": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "dbhub-analytics"
      ],
      "env": {
        "DSN": "${input:dsn}",
        "DB_TYPE": "${input:db-type}",
        "DB_HOST": "${input:db-host}",
        "DB_PORT": "${input:db-port}",
        "DB_USER": "${input:db-user}",
        "DB_PASSWORD": "${input:db-password}",
        "DB_NAME": "${input:db-name}",
        "TRANSPORT": "${input:transport}",
        "PORT": "${input:port}",
        "ID": "${input:id}",
        "SSH_HOST": "${input:ssh-host}",
        "SSH_PORT": "${input:ssh-port}",
        "SSH_USER": "${input:ssh-user}",
        "SSH_PASSWORD": "${input:ssh-password}",
        "SSH_KEY": "${input:ssh-key}",
        "SSH_PASSPHRASE": "${input:ssh-passphrase}"
      }
    }
  }
}

VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs

DBHub Analytics in other clients