warehouse mcp for VS Code
io.github.kalehdoo/warehouse-mcp
Production MCP server for Postgres, Oracle, Snowflake, BigQuery, Redshift, DuckDB, MotherDuck.
client:VS Code
transport:stdio
runtime:npm
Install warehouse mcp in VS Code
.vscode/mcp.json
{
"inputs": [
{
"type": "promptString",
"id": "mcp-transport",
"description": "MCP_TRANSPORT",
"password": true
},
{
"type": "promptString",
"id": "warehouse-type",
"description": "WAREHOUSE_TYPE",
"password": true
},
{
"type": "promptString",
"id": "mcp-api-keys",
"description": "MCP_API_KEYS",
"password": true
},
{
"type": "promptString",
"id": "duckdb-path",
"description": "DUCKDB_PATH",
"password": true
},
{
"type": "promptString",
"id": "motherduck-token",
"description": "MOTHERDUCK_TOKEN",
"password": true
},
{
"type": "promptString",
"id": "pg-host",
"description": "PG_HOST",
"password": true
},
{
"type": "promptString",
"id": "pg-database",
"description": "PG_DATABASE",
"password": true
},
{
"type": "promptString",
"id": "pg-user",
"description": "PG_USER",
"password": true
},
{
"type": "promptString",
"id": "pg-password",
"description": "PG_PASSWORD",
"password": true
},
{
"type": "promptString",
"id": "oracle-user",
"description": "ORACLE_USER",
"password": true
},
{
"type": "promptString",
"id": "oracle-password",
"description": "ORACLE_PASSWORD",
"password": true
},
{
"type": "promptString",
"id": "oracle-connect-string",
"description": "ORACLE_CONNECT_STRING",
"password": true
},
{
"type": "promptString",
"id": "snowflake-account",
"description": "SNOWFLAKE_ACCOUNT",
"password": true
},
{
"type": "promptString",
"id": "snowflake-user",
"description": "SNOWFLAKE_USER",
"password": true
},
{
"type": "promptString",
"id": "snowflake-private-key-path",
"description": "SNOWFLAKE_PRIVATE_KEY_PATH",
"password": true
},
{
"type": "promptString",
"id": "bigquery-project",
"description": "BIGQUERY_PROJECT",
"password": true
},
{
"type": "promptString",
"id": "google-application-credentials",
"description": "GOOGLE_APPLICATION_CREDENTIALS",
"password": true
},
{
"type": "promptString",
"id": "guardrail-pii-mask",
"description": "GUARDRAIL_PII_MASK",
"password": true
},
{
"type": "promptString",
"id": "mcp-rate-limit-rpm",
"description": "MCP_RATE_LIMIT_RPM",
"password": true
}
],
"servers": {
"warehouse-mcp": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"warehouse-mcp"
],
"env": {
"MCP_TRANSPORT": "${input:mcp-transport}",
"WAREHOUSE_TYPE": "${input:warehouse-type}",
"MCP_API_KEYS": "${input:mcp-api-keys}",
"DUCKDB_PATH": "${input:duckdb-path}",
"MOTHERDUCK_TOKEN": "${input:motherduck-token}",
"PG_HOST": "${input:pg-host}",
"PG_DATABASE": "${input:pg-database}",
"PG_USER": "${input:pg-user}",
"PG_PASSWORD": "${input:pg-password}",
"ORACLE_USER": "${input:oracle-user}",
"ORACLE_PASSWORD": "${input:oracle-password}",
"ORACLE_CONNECT_STRING": "${input:oracle-connect-string}",
"SNOWFLAKE_ACCOUNT": "${input:snowflake-account}",
"SNOWFLAKE_USER": "${input:snowflake-user}",
"SNOWFLAKE_PRIVATE_KEY_PATH": "${input:snowflake-private-key-path}",
"BIGQUERY_PROJECT": "${input:bigquery-project}",
"GOOGLE_APPLICATION_CREDENTIALS": "${input:google-application-credentials}",
"GUARDRAIL_PII_MASK": "${input:guardrail-pii-mask}",
"MCP_RATE_LIMIT_RPM": "${input:mcp-rate-limit-rpm}"
}
}
}
}
VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs