BigQuery
Connect to Google BigQuery to query and analyze large-scale data using SQL.
Key Features
- List GCP projects
- Execute SQL queries
- List tables and view schemas
- Explore datasets
Basic Information
Authentication Method
OAuth 2.0 authentication with Google account.
Required Permissions
https://www.googleapis.com/auth/bigquery: Full access to BigQueryhttps://www.googleapis.com/auth/userinfo.email: User email information
Input Parameters
- Read Only Mode (Optional): When enabled, only SELECT queries can be executed.
📝
The use of raw or derived user data received from Workspace APIs will adhere to the Google User Data Policy, including the Limited Use requirements.
Supported MCP Tools
Project Management Tools
list_projects
Lists all GCP projects where the user has BigQuery access.
Query Tools
execute_query
Executes a SQL query using BigQuery dialect.
Table Management Tools
list_tables
Lists all tables in the BigQuery database.
describe_table
Describes the schema of a specific table.
Usage Example
For example,
- If you enter “Show me the structure of the sales table in BigQuery” in the prompt,
- LLM calls the
describe_tabletool via MCP to retrieve the table schema. - Then, it responds in the chat based on the tool call result.
Notes
- When Read Only mode is disabled, INSERT, UPDATE, DELETE queries can also be executed, so use with caution.
- Large data queries may incur costs.
- Check BigQuery’s query limits and quotas.
Last updated on