Tools Overview: bigquery.googleapis.com

Get MCP tool specifications

To get the MCP tool specifications for all tools in an MCP server, use the tools/list method. The following example demonstrates how to use curl to list all tools and their specifications currently available within the MCP server.

Curl Request
  
curl  
--location  
 'https://bigquery.googleapis.com/mcp' 
  
 \ 
--header  
 'content-type: application/json' 
  
 \ 
--header  
 'accept: application/json, text/event-stream' 
  
 \ 
--data  
 '{ 
 "method": "tools/list", 
 "jsonrpc": "2.0", 
 "id": 1 
 }' 
  
MCP Tools
list_dataset_ids List BigQuery dataset IDs in a Google Cloud project.
get_dataset_info Get metadata information about a BigQuery dataset.
list_table_ids List table ids in a BigQuery dataset.
get_table_info Get metadata information about a BigQuery table.
execute_sql

Run a SQL query in the project and return the result.

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 .

The execute_sql tool can also have side effects if the the query invokes remote functions or Python UDFs .

All queries that are run using the execute_sql tool have a label that identifies the tool as the source. You can use this label to filter the queries using the label and value pair goog-mcp-server: true .

Queries are charged to the project specified in the project_id field.

Design a Mobile Site
View Site in Mobile | Classic
Share by: