Loading...
This MCP server provides read and write access to BigQuery, enabling LLMs to query data, inspect schemas, and manage tables within a specified GCP project and location.
Boost this tool
Subscribe to listing upgrades or segmented pushes.
This MCP server provides read and write access to BigQuery, enabling LLMs to query data, inspect schemas, and manage tables within a specified GCP project and location.
This server allows both read and write operations on BigQuery. It's safe when used with appropriate IAM permissions and when queries are carefully vetted. It's risky if the service account has excessive privileges or if the LLM generates malicious queries.
Performance depends on the complexity of the queries and the size of the datasets. Consider using BigQuery's query optimization features.
BigQuery charges for query execution and data storage. Optimize queries to minimize costs.
npx -y @smithery/cli install mcp-server-bigquery --client claude{
"mcpServers": {
"bigquery": {
"command": "uvx",
"args": ["mcp-server-bigquery"],
"env": {
"BIGQUERY_PROJECT": "{{GCP_PROJECT_ID}}",
"BIGQUERY_LOCATION": "{{GCP_LOCATION}}"
}
}
}
}GCP_PROJECT_IDexecute-queryExecutes a SQL query using the BigQuery dialect.
Can modify or delete data, depending on the query.
list-tablesLists all tables in the BigQuery database.
Read-only operation that does not modify data.
describe-tableDescribes the schema of a specific table.
Read-only operation that does not modify data.
Environment Variable
local
This server allows both read and write operations on BigQuery. It's safe when used with appropriate IAM permissions and when queries are carefully vetted. It's risky if the service account has excessive privileges or if the LLM generates malicious queries.
The level of autonomy depends on the configured IAM permissions and the specific queries executed. Exercise caution when granting broad permissions.
Production Tip
Monitor query performance and cost using BigQuery's monitoring tools.
A GCP project ID and either a service account key file or default application credentials are required.
Use the `--dataset` argument or the `BIGQUERY_DATASETS` environment variable to specify a comma-separated list of datasets.
Use the `--timeout` argument or the `BIGQUERY_TIMEOUT` environment variable to set a maximum query execution time.
The server will return an error message indicating the cause of the failure.
Yes, the `execute-query` tool can be used to execute DDL statements for creating and managing tables, views, and other resources.
Yes, BigQuery provides audit logs that track all query executions.
Ensure that the service account used by the server has appropriate IAM permissions and that the network connection is secured using HTTPS.