googlebigquery-automationlisted

# Google BigQuery Automation via Rube MCP Run SQL queries, explore database schemas, and analyze datasets through the Metabase integration using Rube MCP (Composio). **Toolkit docs**: [composio.dev/toolkits/googlebigquery](https://composio.dev/toolkits/googlebigquery) ## Prerequisites - Rube MCP must be connected (RUBE_SEARCH_TOOLS available) - Active connection via `RUBE_MANAGE_CONNECTIONS` with toolkit `metabase` - A Metabase instance connected to your BigQuery data source - Always call `RUBE_SEARCH_TOOLS` first to get current tool schemas ## Setup **Get Rube MCP**: Add `https://rube.app/mcp` as an MCP server in your client configuration. No API keys needed — just add the endpoint and it works. 1. Verify Rube MCP is available by confirming `RUBE_SEARCH_TOOLS` responds 2. Call `RUBE_MANAGE_CONNECTIONS` with toolkit `metabase` 3. If connection is not ACTIVE, follow the returned auth link to complete setup 4. Confirm connection status shows ACTIVE before running any workflows > **Note**: BigQuery data is accessed through Metabase, a business intelligence tool that connects to BigQuery as a data source. The tools below execute queries and retrieve metadata through Metabase's API. ## Core Workflows ### 1. Run a Native SQL Query Use `METABASE_POST_API_DATASET` with type `native` to execute raw SQL queries against your BigQuery database. ``` Tool: METABASE_POST_API_DATASET Parameters: - database (required): Metabase database ID (integer) - type (required): "native" for