Skip to content
VS Code

Cost Guard MCP for VS Code

io.github.mcpsmiths/cost-guard-mcp

Pre-flight query cost and result-size guardrails for AI agents on BigQuery, Snowflake, Databricks

client:VS Code transport:stdio runtime:pypi

Install Cost Guard MCP in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "google-application-credentials",
      "description": "GOOGLE_APPLICATION_CREDENTIALS",
      "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-role",
      "description": "SNOWFLAKE_ROLE",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-private-key-path",
      "description": "SNOWFLAKE_PRIVATE_KEY_PATH",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-private-key-passphrase",
      "description": "SNOWFLAKE_PRIVATE_KEY_PASSPHRASE",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake-password",
      "description": "SNOWFLAKE_PASSWORD",
      "password": true
    },
    {
      "type": "promptString",
      "id": "databricks-server-hostname",
      "description": "DATABRICKS_SERVER_HOSTNAME",
      "password": true
    },
    {
      "type": "promptString",
      "id": "databricks-http-path",
      "description": "DATABRICKS_HTTP_PATH",
      "password": true
    },
    {
      "type": "promptString",
      "id": "databricks-token",
      "description": "DATABRICKS_TOKEN",
      "password": true
    },
    {
      "type": "promptString",
      "id": "databricks-client-id",
      "description": "DATABRICKS_CLIENT_ID",
      "password": true
    },
    {
      "type": "promptString",
      "id": "databricks-client-secret",
      "description": "DATABRICKS_CLIENT_SECRET",
      "password": true
    }
  ],
  "servers": {
    "cost-guard-mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "cost-guard-mcp"
      ],
      "env": {
        "GOOGLE_APPLICATION_CREDENTIALS": "${input:google-application-credentials}",
        "SNOWFLAKE_ACCOUNT": "${input:snowflake-account}",
        "SNOWFLAKE_USER": "${input:snowflake-user}",
        "SNOWFLAKE_ROLE": "${input:snowflake-role}",
        "SNOWFLAKE_PRIVATE_KEY_PATH": "${input:snowflake-private-key-path}",
        "SNOWFLAKE_PRIVATE_KEY_PASSPHRASE": "${input:snowflake-private-key-passphrase}",
        "SNOWFLAKE_PASSWORD": "${input:snowflake-password}",
        "DATABRICKS_SERVER_HOSTNAME": "${input:databricks-server-hostname}",
        "DATABRICKS_HTTP_PATH": "${input:databricks-http-path}",
        "DATABRICKS_TOKEN": "${input:databricks-token}",
        "DATABRICKS_CLIENT_ID": "${input:databricks-client-id}",
        "DATABRICKS_CLIENT_SECRET": "${input:databricks-client-secret}"
      }
    }
  }
}

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

Cost Guard MCP in other clients