query
Execute SELECT statements on BigQuery to fetch data. Auto-applies LIMIT to keep results manageable.
Instructions
Run a SQL query against BigQuery and return results. Only SELECT queries are allowed. A LIMIT clause is automatically added if missing. Claude should use list_datasets, list_tables, and describe_table first to understand the schema before writing queries. IMPORTANT: Base your analysis ONLY on the data returned. Report exact numbers from the results. Do not speculate about causes (e.g. algorithm updates, competitor actions) unless the data explicitly supports it. If the data does not contain enough information to answer a question, say so clearly rather than guessing.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | The SQL query to execute. Only SELECT statements allowed. | |
| max_rows | No | Maximum rows to return (default 100, max 10000) | |
| project_id | No | Override the default project ID |