googlebigquery-automation

Name: googlebigquery-automation
Availability: InStock
Author: Composio

Automate SQL query execution and metadata exploration for Google BigQuery via Metabase integration.

74.2k|8.5k|Updated Oct 17, 2025

Search Tags:#mcp #sql #Database #Automation #bigquery #metabase

Ready to run

npx skills add https://github.com/ComposioHQ/awesome-claude-skills --skill googlebigquery-automation

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: googlebigquery-automation
Source: https://github.com/ComposioHQ/awesome-claude-skills/tree/main/composio-skills/googlebigquery-automation
Command: npx skills add https://github.com/ComposioHQ/awesome-claude-skills --skill googlebigquery-automation

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill removes the friction of manually navigating complex database interfaces, allowing you to execute queries and retrieve schema information directly through your AI agent.

Core Features & Use Cases

Native SQL Execution: Run raw BigQuery SQL queries directly against your connected databases.
Schema Discovery: Explore database, table, and field metadata to understand your data structure before querying.
MBQL Support: Utilize Metabase Query Language for structured data aggregation and filtering without writing raw SQL.
Use Case: Quickly generate a report on user activity by first listing available databases, inspecting the schema of the 'users' table, and then executing a native SQL query to aggregate sign-ups by date.

Quick Start

Use the googlebigquery-automation skill to list all available databases and then run a native SQL query to select the first ten rows from the users table.

Frequently Asked Questions about googlebigquery-automation

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I run a SQL query against BigQuery using this skill?▼

Use the METABASE_POST_API_DATASET tool with the type parameter set to 'native'. Provide your Metabase database ID and the raw SQL query string within the native object.

What is the difference between native and MBQL queries?▼

Native queries allow you to write standard SQL directly, providing maximum flexibility. MBQL queries use Metabase's structured query language, which is better for building reusable, filterable reports without writing raw SQL.

How do I find the correct database ID for my BigQuery instance?▼

Call the METABASE_GET_API_DATABASE tool to retrieve a list of all configured databases in your Metabase instance, which includes their internal integer IDs.

Can I use parameterized queries to prevent SQL injection?▼

Yes, use the template_tags parameter within your native SQL query object to safely inject variables into your queries.

Why does my query return an error regarding the database ID?▼

The database parameter requires the Metabase-internal integer ID, not the BigQuery project name. Ensure you are using the ID returned by the METABASE_GET_API_DATABASE tool.