# BigQuery

SecureOfficial RemoteData, Analytics & Code Quality

**Summary:** Official Google Cloud managed remote MCP connector for BigQuery. Run SQL queries, explore datasets and tables, and get data insights through AI tools.

**How Teams Use It:** Teams use the BigQuery MCP server to give AI agents direct SQL access to their data warehouse — exploring schemas, running analytics queries, and generating business insights without a custom integration. Data engineers and analysts can ask questions in natural language and have the agent discover relevant tables, inspect their schemas, and execute read-only queries against production datasets. Teams that need write capabilities can also run DML and DDL statements through the execute_sql tool with appropriate IAM controls.

## Tools

| Tool Name                | Tool Description                                                                                      | Tool Type |
|--------------------------|------------------------------------------------------------------------------------------------------|-----------|
| execute_sql              | Run a SQL query in the project and return the result. Can execute SELECT, INSERT, UPDATE, DELETE, CREATE, and AI/ML functions like AI.FORECAST, ML.EVALUATE, ML.PREDICT. | Update    |
| execute_sql_readonly     | Run a read-only SQL query in the project and return the result. Prefer this tool over execute_sql if possible. | Read      |
| get_dataset_info         | Get metadata information about a BigQuery dataset.                                                  | Read      |
| get_table_info           | Get metadata information about a BigQuery table.                                                    | Read      |
| list_dataset_ids         | List BigQuery dataset IDs in a Google Cloud project.                                                | Read      |
| list_table_ids           | List table ids in a BigQuery dataset.                                                                | Read      |