skills.rest
ComposioHQ
ComposioHQOFFICIAL
Explore all skills by this author →
Website𝕏@composioGitHub

googlebigquery-automation

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
One-click install
npx skills add https://github.com/ComposioHQ/awesome-claude-skills --skill googlebigquery-automation
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
bingo2getherbingo2gether

google-calendar-automation

Automate Google Calendar event creation, scheduling, availability checks, and attendee management via Rube MCP.

Community
Intermediate
m19cm19c

databricks-aibi-dashboards

Automate creation, testing, and deployment of Databricks AI/BI dashboards.

Community
Advanced
AstorYHAstorYH
15

bigquery-dataset-query

Query BigQuery datasets with SQL and return results as dictionaries.

Community
Intermediate
rose4320rose4320

gcp-pipeline-orchestration

Automate generation, deployment, and triggering of Google Cloud Composer pipelines.

Community
Advanced