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).
Example Queries:
-- Count the number of penguins in each island.
SELECT island, COUNT(*) AS population
FROM bigquery-public-data.ml_datasets.penguins GROUP BY island
-- Evaluate a bigquery ML Model.
SELECT * FROM ML.EVALUATE(MODEL `my_dataset.my_model`)
-- Evaluate BigQuery ML model on custom data
SELECT * FROM ML.EVALUATE(MODEL `my_dataset.my_model`,
(SELECT * FROM `my_dataset.my_table`))
-- Predict using BigQuery ML model:
SELECT * FROM ML.PREDICT(MODEL `my_dataset.my_model`,
(SELECT * FROM `my_dataset.my_table`))
-- 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)
Queries executed using the `execute_sql_readonly` tool will have the job label
`goog-mcp-server: true` automatically set. Queries are charged to the project specified
in the `project_id` field.
Connector