A
licenseNot graded
qualityC
maintenanceEnables LLMs to explore BigQuery datasets and tables, run safe read-only queries, and optionally perform vector search using BigQuery embeddings.
9
MIT
bigquery-mcp-data-agent
by Minahil099
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@bigquery-mcp-data-agentFind the top 5 busiest Citi Bike stations by trip count."
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
BigQuery MCP Data Agent
An AI-powered data analysis agent built with Google's Agent Development Kit (ADK), Gemini, BigQuery MCP Server, and Cloud Run.
Overview
This project demonstrates how an AI agent can connect to structured data in BigQuery through the Model Context Protocol (MCP).
The agent analyzes the NYC Citi Bike dataset and can answer analytical questions by inspecting the dataset, generating SQL queries, and retrieving data from BigQuery.
Related MCP server: BigQuery MCP
Technologies
Google Agent Development Kit (ADK)
Gemini
BigQuery
BigQuery MCP Server
Model Context Protocol (MCP)
Google Cloud Run
Python
Dataset
The agent works with the public NYC Citi Bike dataset:
bigquery-public-data.new_york_citibike
The dataset contains information about Citi Bike trips and stations in New York City.
How It Works
The user asks a question about the Citi Bike data.
Gemini analyzes the question.
The ADK agent uses BigQuery MCP tools to inspect the dataset.
The agent generates and executes read-only SQL queries.
BigQuery returns the requested data.
Gemini analyzes the results and provides an answer.
MCP Tools Used
The agent uses the following BigQuery MCP tools:
get_dataset_infolist_table_idsget_table_infoexecute_sql_readonly
Example Question
We have budget for 3 coffee trucks.
We want to find the best city bike stations to place our coffee trucks.This server cannot be installed
Maintenance
ActivityMaintained
ResponsivenessNo issues
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Related MCP Connectors
The BigQuery remote MCP server is a fully managed service that uses the Model Context Protocol to connect AI applications and LLMs to BigQuery data sources. It provides secure, standardized tools for AI agents to list datasets and tables, retrieve schemas, generate and execute SQL queries through natural language, and analyze data—enabling direct access to enterprise analytics data without requiring manual SQL coding.
Query your org's data in natural language — read-only MCP access to SQL, NoSQL, files & warehouses.
Read and edit GA4, Search Console and Google Tag Manager from any MCP client. 29 tools.
Read-only MCP tools for AI agent discovery, structured resources, and NIULAI information.
Related MCP Servers
- AlicenseBqualityCmaintenanceEnables AI agents to interact with Google BigQuery databases through natural language queries and schema exploration.310MIT
- AlicenseNot gradedqualityCmaintenanceEnables AI assistants to query and analyze Google BigQuery data, including schema browsing, running queries, and comparing datasets through natural language.MIT
- FlicenseNot gradedqualityCmaintenanceEnables natural language interaction with BigQuery, providing tools to list tables, fetch schemas, and generate/execute queries via MCP.-