bigquery-mcp-server

bigquery-mcp-server

3.3

If you are the rightful owner of bigquery-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

A Model Context Protocol (MCP) server for accessing Google BigQuery. This server enables Large Language Models (LLMs) to understand BigQuery dataset structures and execute SQL queries.

query

Execute read-only (SELECT) BigQuery SQL queries with configurable maximum results and bytes billed.

list_all_datasets

List all datasets in the project, returning an array of dataset IDs.

list_all_tables_with_dataset

List all tables in a specific dataset with their schemas, requiring a datasetId parameter.

get_table_information

Get table schema and sample data, supporting partitioned tables with partition filters.

dry_run_query

Check query validity and estimate cost without execution, returning processing size and estimated cost.