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