Question 1

What is the CData MCP Server for Google BigQuery?

Accepted Answer

It's a read-only MCP (Model Context Protocol) server that allows Large Language Models (LLMs) like Claude to query live data from Google BigQuery using CData JDBC Drivers.

Question 2

What is MCP (Model Context Protocol)?

Accepted Answer

MCP is an open protocol that standardizes how applications provide context to LLMs, enabling AI models to access and interact with external data sources and tools.

Question 3

What are the benefits of using the CData MCP Server?

Accepted Answer

It enables natural language querying of Google BigQuery data, real-time data analysis, and seamless integration with AI clients like Claude.

Question 4

Is this a read/write server?

Accepted Answer

This particular server is read-only. However, CData offers a free (beta) read/write version available on their website.

Question 5

What is the CData JDBC Driver for Google BigQuery?

Accepted Answer

It's a driver that exposes Google BigQuery as relational SQL models, allowing the MCP Server to translate natural language queries into SQL queries.

Question 6

How do I set up the CData MCP Server?

Accepted Answer

The setup involves cloning the repository, building the server, installing and licensing the CData JDBC Driver, configuring the connection, creating a .prp file, and configuring your AI client (e.g., Claude Desktop).

Question 7

Where can I find the CData JDBC Driver for Google BigQuery?

Accepted Answer

You can download it from the CData website: [https://www.cdata.com/drivers/bigquery/download/jdbc](https://www.cdata.com/drivers/bigquery/download/jdbc)

Question 8

What is a .prp file?

Accepted Answer

It's a property file that stores the connection details for the JDBC driver, including the prefix, server name, driver path, driver class, JDBC URL, and tables.

Question 9

How do I configure the connection string?

Accepted Answer

Use the Connection String utility provided with the CData JDBC Driver to configure and test the connection to your Google BigQuery instance. Copy the connection string for use in the .prp file.

Question 10

How do I configure Claude Desktop to use the MCP Server?

Accepted Answer

You need to add an entry for the new MCP server in the `claude_desktop_config.json` file, specifying the path to the Java executable, the JAR file, and the .prp file.

Question 11

How do I run the MCP Server manually?

Accepted Answer

Use the command `java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/Salesforce.prp`.

Question 12

What do the servername_get_tables, servername_get_columns, and servername_run_query tools do?

Accepted Answer

`servername_get_tables` retrieves a list of tables. `servername_get_columns` retrieves a list of columns for a table. `servername_run_query` executes a SQL SELECT query.

Question 13

What should I do if I can't see the CData MCP Server in Claude Desktop?

Accepted Answer

Ensure that you have fully quit and restarted the Claude Desktop client.

Question 14

What should I do if Claude Desktop is unable to retrieve data?

Accepted Answer

Double-check that you have configured your connection properly and that the connection string in the .prp file is correct.

Question 15

Where can I get help with connecting to my data source?

Accepted Answer

Contact the [CData Support Team](https://www.cdata.com/support/submit.aspx).

Question 16

Where can I get help with using the MCP server?

Accepted Answer

Join the [CData Community](https://community.cdata.com).

Question 17

What license is the MCP server released under?

Accepted Answer

The MCP server is licensed under the MIT License.

Question 18

How does UBOS enhance the MCP Server experience?

Accepted Answer

UBOS is a full-stack AI Agent Development Platform that allows you to orchestrate AI Agents, connect them with your enterprise data, build custom AI Agents with your LLM model and Multi-Agent Systems.

Question 19

Can I use this MCP server with data sources other than Google BigQuery?

Accepted Answer

Yes, CData offers MCP Servers for many other data sources. See the complete table of supported sources.

Google BigQuery MCP Server by CData

Resources

Project Details

Recomended MCP Servers

Featured Templates

Sarcastic AI Chat Bot

Pharmacy Admin Panel

AI Chat Bot: Text, Voice, and Video Magic

Service ERP

Image to text with Claude 3

Customer Relationship Management (CRM)

Start your free trial