Skip to content
Back to search

mcp-server-bigquery

A Model Context Protocol server that provides access to BigQuery

Safety scan

A static text scan, not a guarantee. Select the badge to see what was scanned and every finding.

Checked today
Badge for your README
findsafeskills safety rating

Markdown

[![findsafeskills safety rating](/api/listings/lucashild--mcp-server-bigquery/badge.svg)](/listings/lucashild--mcp-server-bigquery)

HTML

<a href="/listings/lucashild--mcp-server-bigquery"><img src="/api/listings/lucashild--mcp-server-bigquery/badge.svg" alt="findsafeskills safety rating" /></a>

Install

i

Install instructions from the README

As written by the repo's author. findsafeskills has not verified these steps.

Installing via Smithery

To install BigQuery Server for Claude Desktop automatically via [Smithery](https://smithery.ai/server/mcp-server-bigquery):

npx -y @smithery/cli install mcp-server-bigquery --client claude

Claude Code

claude mcp add bigquery --scope user --transport stdio -- uvx mcp-server-bigquery --project {PROJECT_ID} --location {{LOCATION}}

Claude Desktop

On MacOS: `~/Library/Application\ Support/Claude/claude_desktop_config.json` On Windows: `%APPDATA%/Claude/claude_desktop_config.json`

{
  "mcpServers": {
    "bigquery": {
      "command": "uvx",
      "args": ["mcp-server-bigquery"],
      "env": {
        "BIGQUERY_PROJECT": "{{GCP_PROJECT_ID}}",
        "BIGQUERY_LOCATION": "{{GCP_LOCATION}}"
      }
    }
  }
}

What was scanned

The files the safety scan read, as written by the repository's author and shown as plain text. Lines with a finding are marked.

README.md · README · 41 lines

View this file on GitHub (read at the repository's current version: the scan did not record which commit it read)

This file has changed since it was scanned, so this is not exactly the text that was scanned, and no line is marked. The findings are listed with the safety scan above.

  1. # BigQuery MCP server
  2. ![BigQuery MCP Server](https://raw.githubusercontent.com/LucasHild/mcp-server-bigquery/main/assets/banner.png)
  3. A Model Context Protocol server that provides access to BigQuery. This server enables LLMs to inspect database schemas and execute queries.
  4. ## Components
  5. ### Tools
  6. The server implements three tools:
  7. - `execute-query`: Executes a SQL query using BigQuery dialect
  8. - `list-tables`: Lists all tables in the BigQuery database
  9. - `describe-table`: Describes the schema of a specific table
  10. ## Configuration
  11. The server can be configured either with command line arguments or environment variables.
  12. | Argument | Environment Variable | Required | Description |
  13. | ------------ | -------------------- | -------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
  14. | `--project` | `BIGQUERY_PROJECT` | Yes | The GCP project ID. |
  15. | `--location` | `BIGQUERY_LOCATION` | Yes | The GCP location (e.g. `europe-west9`). |
  16. | `--dataset` | `BIGQUERY_DATASETS` | No | Only take specific BigQuery datasets into consideration. Several datasets can be specified by repeating the argument (e.g. `--dataset my_dataset_1 --dataset my_dataset_2`) or by joining them with a comma in the environment variable (e.g. `BIGQUERY_DATASETS=my_dataset_1,my_dataset_2`). If not provided, all datasets in the project will be considered. |
  17. | `--key-file` | `BIGQUERY_KEY_FILE` | No | Path to a service account key file for BigQuery. If not provided, the server will use the default credentials. |
  18. | `--timeout` | `BIGQUERY_TIMEOUT` | No | Maximum time in seconds to wait for a query to complete. If not provided, queries will wait indefinitely. |
  19. ## Installation
  20. ### Claude Code
  21. ```bash
  22. claude mcp add bigquery --scope user -- uvx mcp-server-bigquery --project {{GCP_PROJECT_ID}} --location {{GCP_LOCATION}}
  23. ```
  24. ### Codex
  25. ```bash
  26. codex mcp add bigquery -- uvx mcp-server-bigquery --project {{GCP_PROJECT_ID}} --location {{GCP_LOCATION}}
  27. ```

Ratings and comments

Sign in to rate this skill.

Sign in

Free to use. If it’s helped, pass it on.