BigQuery Analysis
Summary
The BigQuery Analysis MCP Server provides tools for safely executing SQL queries on Google BigQuery datasets. It offers two main capabilities: performing dry runs to validate queries and estimate their processing size, and executing validated queries with built-in safeguards that prevent data manipulation language (DML) statements and limit query size to 1 TB. The server uses application default credentials for authentication and returns query results in JSON format, making it ideal for data analysts and developers who need to perform controlled analytics operations on large datasets without risking costly or destructive operations.
Available Actions(2)
dry_run_query
Perform a dry run of a BigQuery query. Validates the query and estimates its processing size, checking query size against the 1TB limit.
run_query_with_validation
Run a BigQuery query with validation. Detects and rejects DML statements (data modification queries), rejects data processing over 1TB, and executes queries that pass validation, returning the results.
社区评论
暂无评论. 成为第一个评论的人！
登录以参与讨论
