Google BigQuery MCP Server
by CData Software
This project builds a read-only MCP Server to allow LLMs to query live data from Google BigQuery. It leverages the CData JDBC Driver for Google BigQuery to expose data as relational SQL models, enabling natural language querying.
Last updated: N/A
What is Google BigQuery MCP Server?
The Google BigQuery MCP Server by CData is a read-only server that enables Large Language Models (LLMs) to query live data from Google BigQuery using natural language. It utilizes the CData JDBC Driver for Google BigQuery to translate BigQuery data into a relational SQL model accessible through a simple Model Context Protocol (MCP) interface.
How to use Google BigQuery MCP Server?
To use the server, clone the repository, build the server using Maven, download and license the CData JDBC Driver for Google BigQuery, configure the connection to Google BigQuery using the Connection String utility, create a .prp file with connection properties, and configure your client (e.g., Claude Desktop) to use the server.
Key features of Google BigQuery MCP Server
Read-only access to Google BigQuery data
Exposes BigQuery data as relational SQL models
Enables natural language querying of BigQuery data by LLMs
Uses the CData JDBC Driver for Google BigQuery
Simple MCP interface for easy integration with LLMs
Use cases of Google BigQuery MCP Server
Allowing LLMs to answer questions about data stored in Google BigQuery
Enabling natural language data exploration for Google BigQuery
Integrating Google BigQuery data with AI-powered applications
Providing a simplified interface for querying Google BigQuery data without SQL
FAQ from Google BigQuery MCP Server
How do I configure the connection to Google BigQuery?
How do I configure the connection to Google BigQuery?
Use the Connection String utility provided with the CData JDBC Driver for Google BigQuery to create a connection string and then include it in the .prp file.
What is the purpose of the .prp file?
What is the purpose of the .prp file?
The .prp file contains the configuration properties for the JDBC connection, including the driver path, driver class, JDBC URL, and other settings.
How do I integrate the MCP server with Claude Desktop?
How do I integrate the MCP server with Claude Desktop?
Create or modify the claude_desktop_config.json file to include the MCP server configuration, specifying the path to the Java executable, the JAR file, and the .prp file.
What do I do if I cannot see the CData MCP Server in Claude Desktop?
What do I do if I cannot see the CData MCP Server in Claude Desktop?
Ensure that you have fully quit Claude Desktop (using Task Manager or Activity Monitor) and then re-opened it.
Where can I get help if I am having trouble connecting to my data source?
Where can I get help if I am having trouble connecting to my data source?
Contact the CData Support Team or join the CData Community for assistance.