What Can It Do?
- Discover projects and datasets you have access to
- Inspect table metadata including schema and row counts
- Run SQL queries and return structured results
- Power data workflows by chaining outputs to other tools
Where to Use It
In Agents (Recommended)
Add BigQuery as a tool to any agent. The agent can then query and explore your data conversationally, choosing the right actions based on context. To add an MCP tool to your agent:- Open your agent’s configuration
- Click Add tools → Connect an app with MCP
- Search for the integration and select it
- Authenticate with your account
In Workflows (Via Agent Node)
For automated pipelines, use an Agent Node with BigQuery tools. This gives you the flexibility of an agent within a deterministic workflow.As a Custom MCP Node
You can also create a standalone MCP node for a specific action. This generates a reusable node that performs one task, useful when you need the same operation repeatedly in workflows.- Go to your node library and search for the integration
- Click Create a node with AI
- Describe the specific action you want (e.g., “Run this SQL query on my dataset”)
- Test the node and save it for reuse
Custom MCP nodes are single-purpose by design. For tasks that require multiple steps or dynamic decision-making, use an agent instead.
Available Tools
| Tool | Description |
|---|---|
| List Project Ids | List accessible Google Cloud projects |
| List Dataset Ids | List datasets in a project |
| List Table Ids | List tables in a dataset |
| Get Dataset Info | Get dataset metadata |
| Get Table Info | Get table schema and row count |
| Execute SQL | Run a SQL query and return results |
Example Prompts
Use these with your agent or in the Agent Node: Discover projects:Troubleshooting
| Issue | Solution |
|---|---|
| Agent not finding the right data | Specify the project ID and dataset explicitly |
| Action not completing | Check that you’ve authenticated and have BigQuery access |
| Unexpected results | The agent may chain multiple tools (e.g., listing datasets first, then querying). Review the agent’s reasoning to understand its approach. |
| Tool not available | Verify the tool is enabled in your agent’s MCP configuration |
Need Help?
- Agents documentation for setup and best practices
- Agent Node guide for workflow integration
- Gumloop Community for questions and examples
- Contact [email protected] for assistance
Use this integration directly in Claude or Cursor. Connect remotely via the BigQuery MCP server using your Gumloop credentials.