Skills/Composio App Automation/Claude Skill/Source: Composio Awesome Claude Skills

Google BigQuery 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.

View on GitHub Source Website

Overview

Run SQL queries, explore database schemas, and analyze datasets through the Metabase integration using Rube MCP (Composio).

Core features

Action

Tool

Run SQL query

METABASE_POST_API_DATASET

Run MBQL query

METABASE_POST_API_DATASET

Get query metadata

METABASE_POST_API_DATASET_QUERY_METADATA

Convert to SQL

METABASE_POST_API_DATASET_NATIVE

Get parameter values

METABASE_POST_API_DATASET_PARAMETER_VALUES

List databases

METABASE_GET_API_DATABASE

Get database metadata

METABASE_GET_API_DATABASE_ID_METADATA

Target users

AI builders and operators who want Claude, Codex, Cursor, Gemini CLI, or similar agents to automate Googlebigquery workflows through Composio.

How to use

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.

Effect review

Best for agent workflows that need real app actions with explicit tool discovery, connection checks, and schema-aware execution.

Frequently asked questions

What is Google BigQuery 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.

How do I use Google BigQuery Automation?

What does this skill require?

It requires Rube MCP and an active Composio connection for the Googlebigquery toolkit before executing app actions.

Quick install

Install command

Add https://rube.app/mcp as an MCP server.
RUBE_MANAGE_CONNECTIONS toolkits: ["googlebigquery"]
RUBE_SEARCH_TOOLS before every workflow, then execute with RUBE_MULTI_EXECUTE_TOOL.