Google Bigquery By Cdata MCP Server

CData JDBC Driver connects to Google BigQuery by exposing them as relational SQL models.

Remote serverstreamable-http

What is the Google Bigquery By Cdata MCP server?

Google Bigquery By Cdata MCP server exists for a simple reason — assistants are far more useful when they can act on Google Bigquery By Cdata directly instead of describing what you should do. CData JDBC Driver connects to Google BigQuery by exposing them as relational SQL models.

What the assistant can call

Once Google Bigquery By Cdata is connected, these are the calls the assistant has available:

  • google_bigquery_get_tables — The google_bigquery_get_tables tool exposed by this server
  • google_bigquery_get_columns — The google_bigquery_get_columns tool exposed by this server
  • google_bigquery_run_query — The google_bigquery_run_query tool exposed by this server

Setting it up

Being a remote server, there is no local install. You register the endpoint with your client, authorise it once, and the tools appear.

Choosing this one

Among the database access options, the useful question is rarely "what can it do" but "what does it cost you to run" — permissions, credentials, and how much of your context its toolset consumes. Google Bigquery By Cdata's toolset — google_bigquery_get_tables, google_bigquery_get_columns, google_bigquery_run_query — is a fair guide to whether it matches your workflow. It is maintained by CDataSoftware; worth a glance at recent repository activity before you build anything load-bearing on it.

SyncDev reviews every entry in this directory against the project's own documentation before publishing, and revisits them as servers change.

Before you rely on it

  • Your data travels to the provider's service, so the usual questions apply about what you send and what they retain.
  • MCP clients confirm each tool call by default. Leave that on until you have watched what the google bigquery by cdata mcp server does with a few real requests.

Available tools

ToolWhat it does
google_bigquery_get_tablesThe google_bigquery_get_tables tool exposed by this server.
google_bigquery_get_columnsThe google_bigquery_get_columns tool exposed by this server.
google_bigquery_run_queryThe google_bigquery_run_query tool exposed by this server.

How to install the Google Bigquery By Cdata MCP server

**Linux/Mac**
      ```json
      {
        "mcpServers": {
          "{classname_dash}": {
            "command": "/PATH/TO/java",
            "args": [
              "-jar",
              "/PATH/TO/CDataMCP-jar-with-dependencies.jar",
              "/PATH/TO/google-bigquery.prp"
            ]
          },
          ...
        }
      }

Configuration as documented by the project. Restart the client after saving.

Example prompts to try

  • Use Google Bigquery By Cdata to google bigquery get tables.
  • Use Google Bigquery By Cdata to google bigquery get columns.
  • Use Google Bigquery By Cdata to google bigquery run query.

Frequently asked questions

It connects Google Bigquery By Cdata to MCP-compatible AI assistants such as Claude and Cursor, exposing 3 tools (google_bigquery_get_tables, google_bigquery_get_columns, google_bigquery_run_query) that the assistant can call on your behalf. Instead of copying data back and forth by hand, the assistant works with Google Bigquery By Cdata directly.