Snow Leopard BigQuery MCP
About
Interact with Google BigQuery databases using natural language queries and schema exploration.
Details
- Author
- snowleopard-ai
- Categories
- Database, Other
Jump to
Before getting started, ensure you have:
- Claude Desktop:](https://en.wikipedia.org/wiki/Model_Context_Protocol)Download here
- Google Cloud Projectwith BigQuery enabled:Setup guide
- Google Cloud CLI (gcloud):Installation guide
- UV Package Manager:Installation guide
First, we need to authenticate with Google.
This opens your browser to authenticate your local machine with Google Cloud.
Edit yourclaude_desktop_config.jsonfile to add the BigQuery MCP server.
Application: Claude > Settings > Developer > Edit Config
Mac:~/Library/Application\ Support/Claude/claude_desktop_config.json
Windows:%APPDATA%\\Claude\\claude_desktop_config.json
You will need to set your project to a Google Cloud project with permissions to submit bigquery jobs. If you do not have a project that you can run bigquery jobs on, create and test one by following Google'sBigQuery Quickstart GuideCreate a project and follow the instructions toquery a public dataset.
{ "mcpServers": { "bigquery": { "command": "uvx", "args": [ "sl-bigquery-mcp", "--dataset", "bigquery-public-data.usa_names", "--project", "๐จ <projectName> ๐จ" ] } } }
Setup
Install Snow Leopard BigQuery MCP in your MCP client (Claude Desktop, Cursor, Windsurf, and others).
Repository: https://github.com/snowleopard-ai/bigquery-mcp
Follow the installation instructions in the repository README, then restart your MCP client.
Snow Leopard BigQuery MCP Server Features
Before getting started, ensure you have:
- Claude Desktop:](https://en.wikipedia.org/wiki/Model_Context_Protocol)Download here
- Google Cloud Projectwith BigQuery enabled:Setup guide
- Google Cloud CLI (gcloud):Installation guide
- UV Package Manager:Installation guide
First, we need to authenticate with Google.
This opens your browser to authenticate your local machine with Google Cloud.
Edit yourclaude_desktop_config.jsonfile to add the BigQuery MCP server.
Application: Claude > Settings > Developer > Edit Config
Mac:~/Library/Application\ Support/Claude/claude_desktop_config.json
Windows:%APPDATA%\\Claude\\claude_desktop_config.json
You will need to set your project to a Google Cloud project with permissions to submit bigquery jobs. If you do not have a project that you can run bigquery jobs on, create and test one by following Google'sBigQuery Quickstart GuideCreate a project and follow the instructions toquery a public dataset.
{ "mcpServers": { "bigquery": { "command": "uvx", "args": [ "sl-bigquery-mcp", "--dataset", "bigquery-public-data.usa_names", "--project", "๐จ <projectName> ๐จ" ] } } }
3. Close Claude Desktop and Launch it from the terminal
Depending on how you have installed uv, the uvx executable may not be in Claude Desktop's PATH if it is launched from the GUI. To be sure uvx is accessible from Claude Desktop, let's run it in the terminal.
After saving the configuration, restart Claude Desktop. You should now be able to ask Claude questions about your BigQuery data!
What are the top 10 most popular names in 2020?
Usage: sl-bigquery-mcp [OPTIONS] โญโ Options โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโฎ โ --mode [stdio|sse|streamable-http] MCP transport protocol [default: stdio] โ โ --dataset TEXT Dataset(s) for mcp resources. Will create resources for all tables. โ โ --table TEXT Table(s) for mcp resources. Can be specified as project.dataset.table or dataset.table โ โ --enable-list-tables-tool --no-enable-list-tables-tool Registers list_resources tool [default: enable-list-tables-tool] โ โ --enable-schema-tool --no-enable-schema-tool Registers get_schema tool [default: enable-schema-tool] โ โ --project TEXT BigQuery project [env var: BQ_PROJECT] [default: None] โ โ --api-method [INSERT|QUERY] BigQuery client api_method [default: QUERY] โ โ --port INTEGER [default: 8000] โ โฐโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโฏ
First, check out your Claude Desktop app logs (in the same directory as the config file) for more verbose errors / logging
This usually means Claude is having issues starting the mcp server. Frequently this is due to uvx being inaccessible from the application. In this case, use the full path to your uvx executable instead of justuvxinclaude_desktop_config.json.
Otherwise, this may be caused by bad arguments, dependency version incompatibilities, or bugs. If you run into the last two, please file anissuedescribing the problem.
This may be a misconfiguration mcp server, authentication issues, the llm getting too much data, or of course, product bugs. After checking the logs, consider using theMCP Inspectorto debug your issue. And of course, file any bugs you find on ourissue board.
- Clone the repository
- Setup virtual environment and install dependencies
- Verify installation
git clone https://github.com/SnowLeopard-AI/bigquery-mcp.git cd bigquery-mcp uv sync source .venv/bin/activate sl-bigquery-mcp --help
The following command will launch a browser for you to login to your google cloud account. You must have a Google Cloud project withBigQueryenabled. If you don't, see Google'sbigquery setup guide.
gcloud auth application-default login gcloud config set project <projectName> gcloud auth application-default set-quota-project <projectName>
Run the tests to make sure your dev environment is properly configured.
Note: the tests run actual BigQuery queries against public datasets and require authentication.
For hands-on testing and development, use theMCP Inspectortool:
npx @modelcontextprotocol/inspector uv run sl-bigquery-mcp --dataset bigquery-public-data.usa_names
We welcome contributions! Please coordinate with us ondiscordto ensure your changes can quicly make it into the repo. Communicating before coding always saves time.
For logistics of contributing to an open source project, see thefirst contributions repository.
Issues:GitHub Issues
Documentation:BigQuery Documentation
MCP Protocol:Model Context Protocol
Contact:Discord Server
Inspect database schemas and execute queries on Google BigQuery.
Access Google BigQuery to understand dataset structures and execute SQL queries.
A secure, self-hosted Model Context Protocol (MCP) server for Google BigQuery. Hard table allowlists, per-query scan ceilings, built-in rate limiting, and predictable costs on Cloud Run. Works with Claude, ChatGPT, Cursor, Gemini, and any MCP-compatible AI agent.
Connect to Google BigQuery databases using CData's MCP Server. Requires a separate CData JDBC Driver license.
Official MCP server for dbt (data build tool) providing integration with dbt Core/Cloud CLI, project metadata discovery, model information, and semantic layer querying capabilities.
Open source MCP server specializing in easy, fast, and secure tools for Databases.
Query and analyze data with MotherDuck and local DuckDB
A collection of tools for managing the platform, addressing data quality and reading and writing to Teradata Database.
A read-only MCP server for Avro data sources, powered by the CData JDBC Driver.
Run SQL queries on data in Amazon S3 using AWS Athena.
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.





