Claude MarketplacesSubmit
snowleopard-ai avatar

Bigquery Mcp

snowleopard-ai/bigquery-mcp

Connects Claude to Google BigQuery through the Model Context Protocol. Exposes three core operations: listing tables, fetching schemas, and executing arbitrary SQL queries. Resources provide browsable access to table metadata at `bigquery://tables` URIs, while the query tool lets Claude run SQL directly against your datasets. Built by SnowLeopard AI as a benchmarking tool for their platform, now open sourced. Authentication uses Google Cloud CLI credentials, and you configure it by pointing at specific datasets or tables in your project. Supports both public datasets like `bigquery-public-data.usa_names` and your private tables. Reach for this when you need to give Claude read access to your data warehouse without building custom extraction pipelines.

GitHub stars
10
tools
5
transport
STDIO
last updated
Mar 27, 2026
View on GitHub

Tools

5 tools

Public tool metadata for what this MCP can expose to an agent.

list_dataset_idsList BigQuery dataset IDs in a Google Cloud project.1 params

List BigQuery dataset IDs in a Google Cloud project.

Parameters* required
projectIdstring
Required. Project ID of the dataset request.
get_dataset_infoGet metadata information about a BigQuery dataset.2 params

Get metadata information about a BigQuery dataset.

Parameters* required
datasetIdstring
Required. Dataset ID of the dataset request.
projectIdstring
Required. Project ID of the dataset request.
list_table_idsList table ids in a BigQuery dataset.2 params

List table ids in a BigQuery dataset.

Parameters* required
datasetIdstring
Required. Dataset ID of the table request.
projectIdstring
Required. Project ID of the table request.
get_table_infoGet metadata information about a BigQuery table.3 params

Get metadata information about a BigQuery table.

Parameters* required
datasetIdstring
Required. Dataset ID of the table request.
projectIdstring
Required. Project ID of the table request.
tableIdstring
Required. Table ID of the table request.
execute_sqlRun a SQL query in the project and return the result. This tool is restricted to only `SELECT` statements. `INSERT`, `UPDATE`, and `DELETE` statements and stored procedures aren't allowed. If the query doesn't include a `SELECT` statement, an error is returned. For information...3 params

Run a SQL query in the project and return the result. This tool is restricted to only `SELECT` statements. `INSERT`, `UPDATE`, and `DELETE` statements and stored procedures aren't allowed. If the query doesn't include a `SELECT` statement, an error is returned. For information...

Parameters* required
dryRunboolean
Optional. If set to true, BigQuery doesn't run the job. Instead, if the query is valid, BigQuery returns statistics about the job such as how many bytes would be processed. If the query is invalid,...
projectIdstring
Required. Project that will be used for query execution and billing.
querystring
Required. The query to execute in the form of a GoogleSQL query.

Sponsors

Promote your product hereReach 125k+ visitors monthlyPromote your product hereReach 125k+ visitors monthlyAgent CaffeineSponsoredClose your lid, come back to finished workSnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthlyWaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthlyknobsSponsoredSee your site on any phone, any day, in any language

Readme

Snow Leopard BigQuery MCP

Test Coverage PyPI - Version Discord


Snow Leopard BigQuery MCP Logo


A Model Context Protocol (MCP) server for Google BigQuery that enables AI agents to interact with BigQuery databases through natural language queries and schema exploration.

View the full README on GitHub

Details

Repository
github.com/snowleopard-ai/bigquery-mcp
Category
Data & Analytics
Package
sl-bigquery-mcp
Transport
STDIO
Registry
MCP registry, active

Related Data & Analytics MCP servers

View all
1marekrost avatarMcp Server Spreadsheetmarekrost/mcp-server-spreadsheetMCP server for spreadsheet files (.xlsx, .csv, .ods) - cell-level ops + DuckDB SQL engine.2stars
2nsphung avatarSnowflake MCP Servernsphung/mcp-snowflake-serverA Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants2stars
3mcp-z avatarGoogle Sheetsio.github.mcp-z/mcp-sheetsGoogle Sheets integration with OAuth, spreadsheet management, batch operations, and formatting0stars
4rog0x avatarJsonrog0x/mcp-json-toolsJSON/YAML/CSV validate, diff, transform for AI agents0stars
5stucchi avatarGoogle Analytics 4stucchi/mcp-google-analyticsManage GA4 properties, data streams, conversions, and run reports via Admin & Data APIs.0stars
6us-all avatarDbtus-all/dbt-mcp-serverdbt MCP — manifest/run_results/sources/catalog parsing + DQ result tables (BigQuery/Postgres)0stars