AcademyMCP serversData and reporting

BigQuery MCP Server

Data and analytics teams who want to explore and query BigQuery datasets by asking an AI assistant.

  • Recommendedour rating
  • 131gitHub stars
  • MITlicence
  • 7 months agolast update
claude mcp add bigquery -e BIGQUERY_PROJECT={{GCP_PROJECT_ID}} -e BIGQUERY_LOCATION={{GCP_LOCATION}} -- uvx mcp-server-bigquery
README.md

Loading the file...

What it does

A Model Context Protocol server that gives an AI assistant access to BigQuery. It can list the tables in a database, describe the schema of a table and run SQL queries using the BigQuery dialect. It is configured with command line arguments or environment variables.

Use cases

  1. 01List the tables available in a BigQuery project
  2. 02Check the schema of a table before writing a query
  3. 03Run a SQL query and read the results in chat

Questions about
BigQuery MCP Server.

What is BigQuery MCP Server used for?

Data and analytics teams who want to explore and query BigQuery datasets by asking an AI assistant. A Model Context Protocol server that gives an AI assistant access to BigQuery. It can list the tables in a database, describe the schema of a table and run SQL queries using the BigQuery dialect. It is configured with command line arguments or environment variables.

How do I install BigQuery MCP Server?

Run this in your terminal: claude mcp add bigquery -e BIGQUERY_PROJECT={{GCP_PROJECT_ID}} -e BIGQUERY_LOCATION={{GCP_LOCATION}} -- uvx mcp-server-bigquery

Is BigQuery MCP Server open source?

Yes. The code is on GitHub (LucasHild/mcp-server-bigquery) under the MIT licence.

Is BigQuery MCP Server safe to use?

It passed our automatic scan for credential theft, hidden instructions and risky install commands. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.