AgentSidekick

Cost Guard MCP

MCP serverby mcpsmithsSRC

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

SRC Publisher-stated: these are the publisher's own words, not an assessment.

RepositorySource listing

Key facts

Type
MCP server · mcp-localSRC
Publisher
mcpsmiths · organizationSRC
Licence
MITSRC
Open source
YesDER
Hosting
Local (runs on your machine)SRC
Latest version
0.6.0SRC
Languages
pythonSRC
First published
SRC
In this catalogue since
DER
Last verified
Not verified by a researcher. Last seen in a source on 2026-11-21.

Capabilities and categories

Assigned by keyword rules from the description unless marked otherwise. The matched word is shown so you can judge the match.

CapabilityEvidenceKind
Agent Governancematched guardrailsDER
Data Warehousesmatched bigqueryDER
Cloud Cost Optimizationmatched cost optimizationDER
Policy Enforcementmatched guardrailsDER
Warehouse Queryingmatched bigqueryDER

Filed underAgent InfrastructureCloud & Platform IntegrationsData & KnowledgeAgent SecurityCloud ProvidersData Engineering & AnalyticsCloud Infrastructure

Integrations DER

Platform compatibility

No pairing has been tested by AgentSidekick. Each status says what kind of evidence exists, not whether it works for you.

Protocol-level29

Each platform listed officially documents support for MCP. This specific pairing has not been tested.

Platform discontinued1
PlatformBasis
Roo CodeDiscontinuedRoo Code documented support for MCP but is discontinued. Project shut down and repository archived.
Unknown17
PlatformBasis
OpenClawCould not confirm whether OpenClaw supports MCP.
OpenHandsOpenHands documents MCP support, but it runs only on web, api, slack surfaces and this server runs locally as a process on your machine. Whether OpenHands can reach a local server is not established.
AiderCould not confirm whether Aider supports MCP.
Bolt (bolt.new)Bolt (bolt.new) documents MCP support, but it runs only on web surfaces and this server runs locally as a process on your machine. Whether Bolt (bolt.new) can reach a local server is not established.
Amazon Q DeveloperWinding downCould not confirm whether Amazon Q Developer supports MCP.
Amazon Bedrock Agents (Agents Classic)Maintenance onlyCould not confirm whether Amazon Bedrock Agents (Agents Classic) supports MCP.
GPTs (custom GPTs)Winding downCould not confirm whether GPTs (custom GPTs) supports MCP.
Gemini (app)Gemini (app) documents MCP support, but it runs only on web, mobile surfaces and this server runs locally as a process on your machine. Whether Gemini (app) can reach a local server is not established.
Gemini Enterprise Agent Platform (formerly Vertex AI / Vertex AI Agent Builder)Gemini Enterprise Agent Platform (formerly Vertex AI / Vertex AI Agent Builder) documents MCP support, but it runs only on web, api surfaces and this server runs locally as a process on your machine. Whether Gemini Enterprise Agent Platform (formerly Vertex AI / Vertex AI Agent Builder) can reach a local server is not established.
GitHub Copilot ExtensionsDiscontinuedCould not confirm whether GitHub Copilot Extensions supports MCP.
Google AI StudioCould not confirm whether Google AI Studio supports MCP.
JulesWinding downCould not confirm whether Jules supports MCP.
Microsoft CopilotCould not confirm whether Microsoft Copilot supports MCP.
Microsoft Copilot StudioMicrosoft Copilot Studio documents MCP support, but it runs only on web surfaces and this server runs locally as a process on your machine. Whether Microsoft Copilot Studio can reach a local server is not established.
Replit AgentReplit Agent documents MCP support, but it runs only on web surfaces and this server runs locally as a process on your machine. Whether Replit Agent can reach a local server is not established.
Sourcegraph CodyCould not confirm whether Sourcegraph Cody supports MCP.
v0v0 documents MCP support, but it runs only on web, api surfaces and this server runs locally as a process on your machine. Whether v0 can reach a local server is not established.

Install

Read from registry metadata. Follow the publisher's instructions; we have not run this.

Packages
RegistryPackageTransportRuntime
pypicost-guard-mcpstdionot stated

Environment variables SRC

NameRequiredSecretPublisher's description
GOOGLE_APPLICATION_CREDENTIALSNoSecretBigQuery: path to a service-account key file (Application Default Credentials). Required to use the bigquery engine.
SNOWFLAKE_ACCOUNTNoNoSnowflake: account identifier. Required to use the snowflake engine.
SNOWFLAKE_USERNoNoSnowflake: username. Required to use the snowflake engine.
SNOWFLAKE_ROLENoNoSnowflake: 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_ROLESNoNoSnowflake: 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_PATHNoSecretSnowflake: 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_PASSPHRASENoSecretSnowflake: passphrase for an encrypted SNOWFLAKE_PRIVATE_KEY_PATH key file, if the key is encrypted.
SNOWFLAKE_PASSWORDNoSecretSnowflake: password (discouraged; prefer SNOWFLAKE_PRIVATE_KEY_PATH). Either this or SNOWFLAKE_PRIVATE_KEY_PATH is required to use the snowflake engine.
SNOWFLAKE_EDITIONNoNoSnowflake: 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_HOSTNAMENoNoDatabricks: SQL warehouse server hostname (e.g. my-workspace.cloud.databricks.com, no scheme, no trailing slash). Required to use the databricks engine.
DATABRICKS_HTTP_PATHNoNoDatabricks: 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_TOKENNoSecretDatabricks: personal access token (simplest auth option). Either this or DATABRICKS_CLIENT_ID + DATABRICKS_CLIENT_SECRET is required to use the databricks engine.
DATABRICKS_CLIENT_IDNoNoDatabricks: OAuth machine-to-machine service-principal client ID (preferred for automated use). Requires DATABRICKS_CLIENT_SECRET as well.
DATABRICKS_CLIENT_SECRETNoSecretDatabricks: OAuth machine-to-machine service-principal client secret. Requires DATABRICKS_CLIENT_ID as well.
COST_GUARD_ALLOW_MULTI_STATEMENT_SQLNoNoSet 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_STATEMENTSNoNoSet 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_QUERIESNoNoMaximum 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_STARTNoNoSet 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_RESUMENoNoSet 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.

Permissions and signals

Signals, not a safety verdict. They describe what the product's metadata references. Security review: not reviewed.

SignalEvidenceHow observedObserved
Runs a local processruns locally via pypiregistry metadata 2026-11-21
Asks for a secretdeclares secret env var(s): GOOGLE_APPLICATION_CREDENTIALS, SNOWFLAKE_PRIVATE_KEY_PATH, SNOWFLAKE_PRIVATE_KEY_PASSPHRASE, SNOWFLAKE_PASSWORD, DATABRICKS_TOKENregistry metadata 2026-11-21

Known advisories for the published package SRC

An advisory existing does not mean the listed version is affected: compare the vulnerable range with the version you install. None found is not evidence of safety.

No advisories found

No published advisory matches a package this product declares. Products without a declared package cannot be matched at all. This is not evidence of safety.

Evaluation

Separate dimensions, each with its evidence. There is no overall score: the dimensions do not add up to one number honestly.

Source authority

Publisher-submitted

Published to the official MCP Registry by the namespace owner. Field values are the publisher's own claims.

Publisher verification

Namespace verified by registry

The MCP Registry verifies namespace ownership (GitHub login or DNS) before publishing. This confirms who published it, not what it does.

Maintenance activity

Active

Last push 2026-11-18 (3 days before this page was built).

Licence clarity

MIT

Licence identifier as reported by GitHub repository metadata.

Installation clarity

Machine-readable

1 package(s) and 0 remote endpoint(s) declared in registry metadata.

Documentation

Repository / website only

No dedicated documentation URL on record. AgentSidekick has not assessed documentation quality.

Compatibility evidence

Protocol-level only

Compatibility is inferred from the standard it implements. No pairing has been tested.

Security review

Not reviewed

AgentSidekick has not audited this product. 2 automated signal(s) are listed under Permissions & signals — they describe what it references, not whether it is safe.

Pricing

Not published in any source we track. The code is open source, which says nothing about the cost of any hosted service.

Repository activity

mcpsmiths/cost-guard-mcp. Read from the GitHub API on 2026-11-21.

1SRCGitHub stars
0SRCForks
6SRCOpen issues
3d agoSRCLast push2026-11-18
v0.6.0SRCLatest release2026-10-19

Version history SRC

  1. 0.6.0
  2. 0.5.0
  3. 0.3.2
  4. 0.3.0
  5. 0.2.0
  6. 0.1.1
  7. 0.1.0

Change history

What changed between two ingests of the same source, and when the product was first seen. Registry releases are under Version history.

  1. First seen

Competitors and alternativesDER

Paired by shared capabilities and integrations. Similar on paper; not tested side by side.

Direct

Same type, overlapping capabilities.

SharesData WarehousesWarehouse QueryingBigQueryDatabricks

spotdb

MCP serverby aliengiraffe.aiSRC

21 GitHub starspushed 1d agoMIT

SharesAgent GovernancePolicy EnforcementData WarehousesWarehouse Querying

db-metadata-extractor-mcp

MCP serverby Optisol-BusinessSRC

0 GitHub starspushed 7mo agolicence unknown

SharesData WarehousesWarehouse QueryingBigQuerySnowflake

warehouse-mcp

MCP serverby kalehdooSRC

0 GitHub starspushed 5mo agoApache-2.0

SharesData WarehousesWarehouse QueryingBigQuerySnowflake

bigquery-mcp

MCP serverby SnowLeopard-AISRC

10 GitHub starspushed 7mo agoMIT

SharesData WarehousesWarehouse QueryingBigQuery

SharesData WarehousesWarehouse QueryingSnowflake

Adjacent

A different form or a partial overlap.

altimate-code

Pluginby altimateaiSRC

4 GitHub starspushed todayMIT

SharesData WarehousesWarehouse QueryingCloud Cost OptimizationBigQuery

SharesData WarehousesWarehouse QueryingBigQuery

SharesData WarehousesWarehouse QueryingSnowflake

Provenance

Which source set each field, what kind of claim it is, and when.

FieldSourceKindSet on
Canonical URLOfficial MCP RegistrySRC2026-11-21
PublisherOfficial MCP RegistrySRC2026-11-21
DescriptionOfficial MCP RegistrySRC2026-11-21
HostingOfficial MCP RegistrySRC2026-11-21
Integration typeOfficial MCP RegistrySRC2026-11-21
LanguagesGitHub repository metadataSRC2026-11-21
Latest versionOfficial MCP RegistrySRC2026-11-21
LicenceGitHub repository metadataSRC2026-11-21
NameOfficial MCP RegistrySRC2026-11-21
Open sourceGitHub repository metadataDER2026-11-21
TypeOfficial MCP RegistrySRC2026-11-21
PublishedOfficial MCP RegistrySRC2026-11-21
RepositoryOfficial MCP RegistrySRC2026-11-21
source_updated_atOfficial MCP RegistrySRC2026-11-21
Source URLOfficial MCP RegistrySRC2026-11-21

Sources

Not verified by a researcher. Last seen in a source on . Report incorrect information

Page data last updated .