BigQuery MCP server

A Model Context Protocol server that provides access to BigQuery. This server enables LLMs to inspect database schemas and execute queries.

Components

Tools

The server implements one tool:

• execute-query: Executes a SQL query using BigQuery dialect
• list-tables: Lists all tables in the BigQuery database
• describe-table: Describes the schema of a specific table

Configuration

The server can be configured either with command line arguments or environment variables.

| Argument | Environment Variable | Required | Description | | ------------ | -------------------- | -------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | --project | BIGQUERY_PROJECT | Yes | The GCP project ID. | | | | Yes | The GCP location (e.g. ). | | | | No | Only take specific BigQuery datasets into consideration. Several datasets can be specified by repeating the argument (e.g. ) or by joining them with a comma in the environment variable (e.g. ). If not provided, all datasets in the project will be considered. | | | | No | Path to a service account key file for BigQuery. If not provided, the server will use the default credentials. | | | | No | Maximum time in seconds to wait for a query to complete. If not provided, queries will wait indefinitely. |