BigQuery

List BigQuery dataset IDs and BigLake namespaces in a Google Cloud project. Supports pagination. Use `pageSize` to limit results and `pageToken` to retrieve next page.

Get metadata information about a BigQuery dataset or BigLake namespace.

List table ids in a BigQuery dataset or BigLake namespace. Supports pagination. Use `pageSize` to limit results and `pageToken` to retrieve next page.

Get metadata information about a BigQuery table or BigLake table.

Run a read-only SQL query in the project and return the result. Prefer this tool over `execute_sql` if possible. This tool is restricted to only `SELECT` statements. `INSERT`, `UPDATE`, and `DELETE` statements and stored procedures aren't allowed. If the query doesn't include a `SELECT` statement, an error is returned. For information on creating queries, see the [GoogleSQL documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax). IMPORTANT: For predictive and analytical tasks (forecasting, anomaly detection, key driver / root cause analysis, classification, churn prediction, or text generation), ALWAYS execute computation in-warehouse using BigQuery native AI/ML functions (`AI.FORECAST`, `AI.DETECT_ANOMALIES`, `AI.KEY_DRIVERS`, `AI.CLASSIFY`, `AI.GENERATE`) rather than exporting raw rows to a local Python sandbox. In-warehouse execution scales to billions of rows, preserves governance, and eliminates data egress latency. Example Queries: ```sql -- Count the number of penguins in each island. SELECT island, COUNT(*) AS population FROM bigquery-public-data.ml_datasets.penguins GROUP BY island -- Forecast data using AI.FORECAST SELECT * FROM AI.FORECAST(TABLE `project.dataset.my_table`, data_col => 'num_trips', timestamp_col => 'date', id_cols => ['usertype'], horizon => 30) -- Detect anomalies in time series data using AI.DETECT_ANOMALIES SELECT * FROM AI.DETECT_ANOMALIES( TABLE `project.dataset.historical_metrics`, TABLE `project.dataset.recent_metrics`, data_col => 'num_requests', timestamp_col => 'timestamp' ) -- Identify key drivers of metric changes using AI.KEY_DRIVERS SELECT * FROM AI.KEY_DRIVERS( TABLE `project.dataset.sales_summary`, metric_col => 'total_revenue', dimension_cols => ['region', 'product_category'], interest_label_col => 'is_current_quarter' ) -- Classify text into categories using AI.CLASSIFY SELECT ticket_id, AI.CLASSIFY(ticket_text, ['Billing', 'Technical Support', 'Feature Request']) AS category FROM `project.dataset.support_tickets` -- Generate text or summaries using AI.GENERATE SELECT review_id, AI.GENERATE(CONCAT('Summarize this customer review: ', review_text)).result AS summary FROM `project.dataset.reviews` ``` Queries executed using the `execute_sql_readonly` tool will always have the job label `goog-mcp-server: true` automatically set in addition to any custom `labels` provided in the request. Queries are charged to the project specified in the `projectId` field. Query Execution Behavior: * If the query completes within the synchronous timeout (default 20 seconds or custom `timeoutMs`), the tool returns `jobComplete: true` and the initial result rows directly. For fast queries, `jobId` may be omitted as no persistent background job is created; no polling is needed. * If the query takes longer than `timeoutMs`, the tool returns `jobComplete: false` and a `jobId` and `location`. In this case, use the `get_query_results` tool with `jobId` and `location` to poll until `jobComplete: true`, or use `cancel_job` to abort the running query. * The tool returns at most 3,000 rows, and `totalRows` gives the full count. If the response has a `pageToken`, more rows are available: to read the next page, call the `get_query_results` tool with the returned `jobId`, `location`, and `pageToken`. * You can optionally specify `timeoutMs` to configure the maximum synchronous wait time in milliseconds (defaults to 20,000 ms), and `jobTimeoutMs` to enforce a hard server-side timeout after which BigQuery automatically terminates the job.

Run a SQL query in the project and return the result. Prefer the `execute_sql_readonly` tool if possible. This tool can execute any query that bigquery supports including: * SQL Queries (`SELECT`, `INSERT`, `UPDATE`, `DELETE`, `CREATE`, etc.) * AI/ML functions like `AI.FORECAST`, `AI.KEY_DRIVERS`, `ML.EVALUATE`, `ML.PREDICT` * Any other query that bigquery supports. Example Queries: ```sql -- Insert data into a table. INSERT INTO `my_project.my_dataset`.my_table (name, age) VALUES ('Alice', 30); -- Create a table. CREATE TABLE `my_project.my_dataset`.my_table ( name STRING, age INT64); -- DELETE data from a table. DELETE FROM `my_project.my_dataset`.my_table WHERE name = 'Alice'; -- Create Dataset CREATE SCHEMA `my_project.my_dataset` OPTIONS (location = 'US'); -- Drop table DROP TABLE `my_project.my_dataset`.my_table; -- Drop dataset DROP SCHEMA `my_project.my_dataset`; -- Create Model CREATE OR REPLACE MODEL `my_project.my_dataset.my_model` OPTIONS ( model_type = 'LINEAR_REG' LS_INIT_LEARN_RATE=0.15, L1_REG=1, MAX_ITERATIONS=5, DATA_SPLIT_METHOD='SEQ', DATA_SPLIT_EVAL_FRACTION=0.3, DATA_SPLIT_COL='timestamp') AS SELECT col1, col2, timestamp, label FROM `my_project.my_dataset.my_table`; ``` Queries executed using the `execute_sql` tool will always have the default job label `goog-mcp-server: true` automatically set in addition to any custom `labels` provided in the request. Queries are charged to the project specified in the `projectId` field. Query Execution Behavior: * If the query completes within the synchronous timeout (default 20 seconds or custom `timeoutMs`), the tool returns `jobComplete: true` and the initial result rows directly. For fast queries, `jobId` may be omitted as no persistent background job is created; no polling is needed. * If the query takes longer than `timeoutMs`, the tool returns `jobComplete: false` and a `jobId` and `location`. In this case, use the `get_query_results` tool with `jobId` and `location` to poll until `jobComplete: true`, or use `cancel_job` to abort the running query. * The tool returns at most 3,000 rows, and `totalRows` gives the full count. If the response has a `pageToken`, more rows are available: to read the next page, call the `get_query_results` tool with the returned `jobId`, `location`, and `pageToken`. * You can optionally specify `timeoutMs` to configure the maximum synchronous wait time in milliseconds (defaults to 20,000 ms), and `jobTimeoutMs` to enforce a hard server-side timeout after which BigQuery automatically terminates the job.

Get the results of a BigQuery SQL query job. Use this tool ONLY when: 1. A previous `execute_sql` or `execute_sql_readonly` call returned `jobComplete: false` with a `jobId` (poll with this tool until `jobComplete: true`), OR 2. You need to paginate through additional rows using `pageToken` or `startIndex` for a previously completed job. Do NOT call this tool if the query already returned `jobComplete: true` with all rows (no `pageToken`). Supports pagination. Use `maxResults` to limit results (3,000 by default) and `pageToken` to retrieve the next page of results. A response has a `pageToken` only when more rows are available.

Cancel a running BigQuery job. Use this tool to cancel a query job that is currently executing (i.e. returned `jobComplete: false` with a `jobId` from `execute_sql` or `execute_sql_readonly`). Specify the `jobId` to abort.

Get information and status about a BigQuery job. Use this tool to check the status, statistics, or configuration of a job using its `jobId`.