Agent skill · data analytics · composiohq
googlebigquery-automation
Automate Google BigQuery tasks via Rube MCP (Composio): run SQL queries, explore datasets and metadata, execute MBQL queries via Metabase integration. Always search tools first for current schemas.
Why this skill is useful
Adds specific commands and workflows for automating Google BigQuery tasks via Metabase integration that the AI wouldn't reliably generate on its own.
What it needs
Requires metabase account access. About 3k tokens when loaded. Last updated 2026-07-24. 71,973 stars on the source repository.
What this skill does
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 Prerequisites Rube MCP must be connected (RUBESEARCHTOOLS available) Active connection via RUBEMANAGECONNECTIONS with toolkit metabase A Metabase instance connected to your BigQuery data source Always call RUBESEARCHTOOLS 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 RUBESEARCHTOOLS responds 2. Call RUBEMANAGECONNECTIONS 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 METABASEPOSTAPIDATASET with type native to execute raw SQL queries against your BigQuery database. 2. Run a Structured MBQL Query Use METABASEPOSTAPIDATASET with type query for Metabase Query Language queries with built-in aggregation and filtering. 3. Get Query Metadata Use METABASEPOSTAPIDATASETQUERYMETADATA to retrieve metadata about databases, tables, and fields available for querying. 4. Convert Query to Native SQL Use METABASEPOSTAPIDATASETNATIVE to convert an MBQL query into its native SQL representation. 5. List Available Databases Use METABASEGETAPIDATABASE to discover all database connections configured in Metabase. 6. Get Database Schema Metadata Use METABASEGETAPIDATABASEIDMETADATA to retrieve complete table and field information for a specific database. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills composiohq/googlebigquery-automation