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.
コミュニティレビュー
まだレビューはありません. 最初のレビューを投稿しましょう!
会話に参加するにはサインインしてください