Home › Databases & Data › Cost Guard MCP

Cost Guard MCP

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

Python Local macOSWindowsLinux
★ 1 stars Last pushed 2026-11-16 License: MIT

Topics: Databases

Connect

Review any command before running it. Package names and URLs come from the server's own registry entry.

Package (pypi 0.6.0)

uvx cost-guard-mcp

Or add to your MCP client config:

{
  "mcpServers": {
    "cost-guard-mcp": {
      "command": "uvx",
      "args": [
        "cost-guard-mcp"
      ],
      "env": {
        "GOOGLE_APPLICATION_CREDENTIALS": "<YOUR_VALUE>",
        "SNOWFLAKE_PRIVATE_KEY_PATH": "<YOUR_VALUE>",
        "SNOWFLAKE_PRIVATE_KEY_PASSPHRASE": "<YOUR_VALUE>",
        "SNOWFLAKE_PASSWORD": "<YOUR_VALUE>",
        "DATABRICKS_TOKEN": "<YOUR_VALUE>",
        "DATABRICKS_CLIENT_SECRET": "<YOUR_VALUE>"
      }
    }
  }
}
  • GOOGLE_APPLICATION_CREDENTIALS secret — BigQuery: path to a service-account key file (Application Default Credentials). Required to use the bigquery engine.
  • SNOWFLAKE_ACCOUNT — Snowflake: account identifier. Required to use the snowflake engine.
  • SNOWFLAKE_USER — Snowflake: username. Required to use the snowflake engine.
  • SNOWFLAKE_ROLE — Snowflake: role to assume. Required to use the snowflake engine; has no default and must never be ACCOUNTADMIN (ACCOUNTADMIN, SECURITYADMIN and ORGADMIN are rejected before any Snowflake connection is opened - the check runs when the Snowflake configuration is first loaded, on the first Snowflake tool call; the server process itself starts regardless, so a bad role surfaces as a failed check_credentials or a tool error, not as a startup exit).
  • SNOWFLAKE_SECONDARY_ROLES — Snowflake: secondary roles activated at login. NONE (default) means only SNOWFLAKE_ROLE is active in the session; ALL is the explicit opt-out that activates every role granted to SNOWFLAKE_USER.
  • SNOWFLAKE_PRIVATE_KEY_PATH secret — Snowflake: path to an RSA private key file for key-pair auth (preferred over SNOWFLAKE_PASSWORD). Either this or SNOWFLAKE_PASSWORD is required to use the snowflake engine.
  • SNOWFLAKE_PRIVATE_KEY_PASSPHRASE secret — Snowflake: passphrase for an encrypted SNOWFLAKE_PRIVATE_KEY_PATH key file, if the key is encrypted.
  • SNOWFLAKE_PASSWORD secret — Snowflake: password (discouraged; prefer SNOWFLAKE_PRIVATE_KEY_PATH). Either this or SNOWFLAKE_PRIVATE_KEY_PATH is required to use the snowflake engine.
  • SNOWFLAKE_EDITION — Snowflake: account edition that sets the USD/credit price of estimates - standard (default), enterprise, business_critical or vps. The per-call edition argument can only raise it.
  • DATABRICKS_SERVER_HOSTNAME — Databricks: SQL warehouse server hostname (e.g. my-workspace.cloud.databricks.com, no scheme, no trailing slash). Required to use the databricks engine.
  • DATABRICKS_HTTP_PATH — Databricks: SQL warehouse HTTP path (from the warehouse's Connection Details tab, e.g. /sql/1.0/warehouses/<warehouse-id>). Required to use the databricks engine.
  • DATABRICKS_TOKEN secret — Databricks: personal access token (simplest auth option). Either this or DATABRICKS_CLIENT_ID + DATABRICKS_CLIENT_SECRET is required to use the databricks engine.
  • DATABRICKS_CLIENT_ID — Databricks: OAuth machine-to-machine service-principal client ID (preferred for automated use). Requires DATABRICKS_CLIENT_SECRET as well.
  • DATABRICKS_CLIENT_SECRET secret — Databricks: OAuth machine-to-machine service-principal client secret. Requires DATABRICKS_CLIENT_ID as well.
  • COST_GUARD_ALLOW_MULTI_STATEMENT_SQL — Set to 1 to let estimate_query_cost/run_query_bounded accept text containing more than one SQL statement. Off by default: the cost cap is only known to cover the single statement the dry run/EXPLAIN priced. Skips only this server's scanner: Snowflake still rejects multi-statement text (sessions are pinned to MULTI_STATEMENT_COUNT=1), and only a single SELECT/WITH/VALUES statement is wrapped in a LIMIT subquery - a script runs unwrapped and its row cap (max_rows, default 1000) is enforced by the paged fetch.
  • COST_GUARD_ALLOW_WRITE_STATEMENTS — Set to 1 (exactly that value) to let estimate_query_cost/run_query_bounded accept statements that are not reads. Off by default: only text whose first keyword (after comments and opening parentheses) is SELECT, WITH, VALUES, SHOW, DESCRIBE, DESC or EXPLAIN is estimated or run - a WITH must be followed by a SELECT or VALUES - because warehouse rows re-enter the model's context and can steer the next call. The gate is defence in depth: the authorisation boundary is the credential's grants (deploy a read-only principal). With COST_GUARD_ALLOW_MULTI_STATEMENT_SQL=1 every statement in the text must be a read, so BigQuery scripts (DECLARE/SET/BEGIN) need both opt-outs. Any other value leaves the gate on.
  • COST_GUARD_MAX_IN_FLIGHT_QUERIES — Maximum number of run_query_bounded calls allowed in flight at once (positive integer, default 8). A cancelled call keeps its slot until its warehouse query completes or the 120 s watchdog fires; a call over the cap fails with a tool error naming this variable before any warehouse connection is opened.
  • COST_GUARD_DATABRICKS_ALLOW_WAREHOUSE_START — Set to true (exactly that value) to let the read-only Databricks tools (check_credentials, estimate_query_cost) open a session on a SQL warehouse that is not RUNNING, which starts the warehouse and bills compute until it auto-stops. Off by default: the server first reads the warehouse's state through the Warehouses API (GET /api/2.0/sql/warehouses/<id>, CAN_VIEW/CAN_USE suffices) and, unless it is RUNNING - also when the state cannot be read - check_credentials returns ok=false and estimate_query_cost returns no byte or dollar figure, without opening a session. run_query_bounded is not gated: its own pre-execution estimate and the execution may start the warehouse. Any other value leaves the guard on.
  • COST_GUARD_SNOWFLAKE_ALLOW_WAREHOUSE_RESUME — Set to true (exactly that value) to let the read-only Snowflake tools run SELECT CURRENT_REGION(), the INFORMATION_SCHEMA.QUERY_HISTORY read and check_credentials' session-context SELECT on a warehouse that is not STARTED, which can resume a suspended AUTO_RESUME warehouse and bill compute until it auto-suspends. Off by default: those statements are skipped unless the pinned warehouse's SHOW WAREHOUSES state is STARTED (also skipped when no warehouse is pinned or the state cannot be read), and the QUERY_HISTORY read is skipped whenever estimate_query_cost is called without a warehouse argument; estimate_query_cost then prices at Gen1 rates with the byte-tier heuristic and says so in a caveat, and check_credentials returns ok=true with a detail built from the SHOW WAREHOUSES row. USE WAREHOUSE, EXPLAIN USING JSON, SHOW WAREHOUSES and SELECT CURRENT_WAREHOUSE() always run; run_query_bounded is not gated. Any other value leaves the guard on.

Related servers

Listed in punkpeye/awesome-mcp-servers (MIT)

Data from the Official MCP Registry