How does Claude access my BigQuery data?

Claude uses the Rube MCP (Composio) framework to interact with a Metabase instance that is connected to your BigQuery data source as a backend.

Is it possible to explore the schema before querying?

Absolutely. You can use tools like METABASE_GET_API_DATABASE_ID_METADATA to retrieve complete table and field information to understand the schema before building your queries.

What is MBQL and why would I use it?

MBQL (Metabase Query Language) is a structured JSON format that allows you to perform data operations like filtering and aggregation without writing raw SQL, making it easier for Claude to construct programmatic queries.

Do I need to provide BigQuery API keys directly to Claude?

No, you only need to connect your Metabase instance via Rube MCP using the RUBE_MANAGE_CONNECTIONS tool. The authentication is handled by the Composio connection manager.

Can I run complex SQL joins using this skill?

Yes, the skill supports 'native' SQL queries, allowing you to execute any Standard SQL supported by BigQuery, including complex joins, subqueries, and window functions.

Google BigQuery Automation

Name: Google BigQuery Automation
Author: lingxling

bylingxling

•

データベース管理

Automates Google BigQuery workflows via Metabase integration to execute SQL queries, explore schemas, and manage data assets.

This skill empowers Claude to interact directly with Google BigQuery data warehouses through a Metabase-powered integration via Rube MCP. It allows users to execute raw SQL or structured MBQL queries, discover database schemas, and retrieve deep table metadata without leaving the Claude environment. By leveraging Composio's toolsets, it streamlines data analysis, reporting, and database exploration tasks, making it an essential utility for data engineers and analysts who use Claude for data-driven development and business intelligence automation.

主な機能

01Execute native BigQuery SQL queries directly within Claude

0239 GitHub stars

03Run structured MBQL queries for simplified data aggregation and filtering

04Discover and list all database connections configured in your Metabase instance

05Explore database schemas and retrieve detailed table and field metadata

06Convert MBQL queries into native BigQuery SQL syntax for verification

ユースケース

01Ad-hoc database exploration and troubleshooting during software development

02Schema discovery and data validation for building engineering pipelines

03Automated data reporting and trend analysis from BigQuery datasets

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add lingxling/awesome-skills-cn googlebigquery-automation

For use in Claude.ai and ChatGPT

主な機能

01Execute native BigQuery SQL queries directly within Claude

0239 GitHub stars

03Run structured MBQL queries for simplified data aggregation and filtering

04Discover and list all database connections configured in your Metabase instance

05Explore database schemas and retrieve detailed table and field metadata

06Convert MBQL queries into native BigQuery SQL syntax for verification

ユースケース

01Ad-hoc database exploration and troubleshooting during software development

02Schema discovery and data validation for building engineering pipelines

03Automated data reporting and trend analysis from BigQuery datasets

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add lingxling/awesome-skills-cn googlebigquery-automation

For use in Claude.ai and ChatGPT