Google Bigquery MCP Server By Cdata

What is google-bigquery-mcp-server-by-cdata?

google-bigquery-mcp-server-by-cdata is a read-only MCP server that lets LLMs (such as Claude Desktop) query live Google BigQuery data using natural language. It wraps CData’s JDBC Driver for Google BigQuery, exposing the data as relational SQL models without requiring direct SQL from the user.

How to use google-bigquery-mcp-server-by-cdata?

Clone the repository, build with mvn clean install, download and license the CData JDBC Driver for Google BigQuery, create a .prp file with your JDBC connection string and table settings, then add the server to Claude Desktop’s claude_desktop_config.json. The server runs on stdio and must be on the same machine as the client.

Key features of google-bigquery-mcp-server-by-cdata

• Read-only MCP server for Google BigQuery
• Natural language querying via LLMs
• Exposes tables and columns through built‑in tools
• Uses the CData JDBC Driver for Google BigQuery
• Requires Java and a configured .prp file
• Communicates over stdio transport

Use cases of google-bigquery-mcp-server-by-cdata

• Let LLMs answer questions about live BigQuery data without writing SQL
• Retrieve metadata (tables, columns) from a BigQuery dataset
• Integrate BigQuery queries into conversational AI assistants like Claude Desktop
• Explore BigQuery data interactively with natural language prompts