bigquery-mcp

effcamp/bigquery-mcp

3.2

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

A Model Context Protocol (MCP) server for Google BigQuery, enabling AI assistants to query and interact with BigQuery datasets.

Tools

Functions exposed to the LLM to take actions

execute_catalog_query

Execute a pre-defined query from the catalog.

execute_query

Execute a custom BigQuery SQL query with optional parameters.

list_datasets

List all datasets in the BigQuery project.

list_tables

List all tables in a specific dataset.

get_table_schema

Get the schema of a specific table.

query_table

Query a table with optional WHERE clause and LIMIT.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources