Loading...
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}}"
}
}
}
}execute-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.
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.