Hosted MCP server · #70 most used on Smithery · ✓ verified

Google BigQuery

bigquery

Run SQL queries on BigQuery datasets, list tables, and inspect schemas. Manage jobs, export results, and explore data warehouse resources.

Data & databases

Install ↓Smithery ↗

Uses: 7.0k
Tools: 5
Runs: Hosted
Listed: 8mo ago

Get started

Add it to your agent

npx -y @smithery/cli@latest install bigquery --client claude

Swap --client claude for cursor, vscode, windsurf or another client. The CLI asks for any required settings.

claude mcp add --transport http google-bigquery https://server.smithery.ai/bigquery/mcp

A hosted server: nothing to install. Run /mcp in Claude Code to sign in if it asks.

[mcp_servers.google-bigquery]
url = "https://server.smithery.ai/bigquery/mcp"

Add to ~/.codex/config.toml.

{
  "mcpServers": {
    "google-bigquery": {
      "url": "https://server.smithery.ai/bigquery/mcp"
    }
  }
}

Add to ~/.cursor/mcp.json.

{
  "servers": {
    "google-bigquery": {
      "type": "http",
      "url": "https://server.smithery.ai/bigquery/mcp"
    }
  }
}

Add to .vscode/mcp.json.

gemini mcp add --transport http google-bigquery https://server.smithery.ai/bigquery/mcp

Saved to .gemini/settings.json.

What it can do

5 tools

list_dataset_ids1 paramList BigQuery dataset IDs in a Google Cloud project.

Parameter	Type	Description
`projectId`	string	Required. Project ID of the dataset request.

get_dataset_info2 paramsGet metadata information about a BigQuery dataset.

Parameter	Type	Description
`datasetId`	string	Required. Dataset ID of the dataset request.
`projectId`	string	Required. Project ID of the dataset request.

list_table_ids2 paramsList table ids in a BigQuery dataset.

Parameter	Type	Description
`datasetId`	string	Required. Dataset ID of the table request.
`projectId`	string	Required. Project ID of the table request.

get_table_info3 paramsGet metadata information about a BigQuery table.

Parameter	Type	Description
`tableId`	string	Required. Table ID of the table request.
`datasetId`	string	Required. Dataset ID of the table request.
`projectId`	string	Required. Project ID of the table request.

execute_sql3 paramsRun a SQL query in the project and return the result. This tool is restricted to only `SELECT` statements. `INSERT`, `UPDATE`, and `DELET…

Run a SQL query in the project and return the result. This tool is restricted to only `SELECT` statements. `INSERT`, `UPDATE`, and `DELETE` statements and stored procedures aren't allowed. If the query doesn't include a `SELECT` statement, an error is returned. For information on creating queries, see the [GoogleSQL documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax). The `execute_sql` tool can also have side effects if the the query invokes [remote functio

Parameter	Type	Description
`query`	string	Required. The query to execute in the form of a GoogleSQL query.
`dryRun`	boolean	Optional. If set to true, BigQuery doesn't run the job. Instead, if the query is valid, BigQuery returns statistics about the job such as how many bytes would be processed. If the query is invalid, an
`projectId`	string	Required. Project that will be used for query execution and billing.