Can I run standard SQL queries with this skill?

Yes, you can execute native BigQuery SQL using the METABASE_POST_API_DATASET tool by specifying the 'native' query type.

Does this skill require direct BigQuery API keys?

No, this skill connects through Metabase via Rube MCP, utilizing your existing Metabase connection to BigQuery without requiring additional API keys in Claude.

How do I find my database and table IDs?

Use the METABASE_GET_API_DATABASE tool to list available databases and METABASE_GET_API_DATABASE_ID_METADATA to discover specific table and field IDs.

What is MBQL and how is it used?

MBQL is the Metabase Query Language, a structured format used by this skill to perform aggregations and filters without needing to write raw SQL strings.

Are there limits on the amount of data returned?

Yes, you can specify a 'max-results' constraint in your queries to manage the volume of data returned to Claude, ensuring efficient processing.

Google BigQuery Automation

Name: Google BigQuery Automation
Author: ComposioHQ

byComposioHQ

•

47,559

•

数据库管理

Automates Google BigQuery data operations, schema exploration, and complex SQL or MBQL queries via Metabase integration.

This skill empowers Claude to interact directly with Google BigQuery data warehouses through a Metabase-mediated Rube MCP connection. It allows for seamless execution of native SQL and structured MBQL queries, comprehensive schema exploration, and metadata retrieval without leaving the AI interface. By abstracting the complexities of database connections and providing tools for discovering table structures and field IDs, it enables developers and data analysts to perform ad-hoc data analysis, verify data integrity, and automate reporting workflows directly within their Claude-powered workspace.

主要功能

01Automate database schema discovery and comprehensive metadata exploration

02Retrieve parameter values and field-level metadata for precise query construction

0347,559 GitHub stars

04Convert structured MBQL queries into native SQL for debugging and verification

05Execute native BigQuery SQL queries with custom constraints and result limits

06Run structured MBQL queries for simplified aggregation, filtering, and grouping

使用场景

01Prototyping and testing complex data queries during application development

02Automated database schema documentation and exploratory data analysis

03Performing ad-hoc data analysis and generating reports on BigQuery datasets

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add composiohq/awesome-claude-skills googlebigquery-automation

For use in Claude.ai and ChatGPT

Download Skill