This skill provides step-by-step usage patterns for managing Google BigQuery via the bq CLI. It equips the agent to list datasets and tables, inspect schemas, run standard-SQL queries, estimate costs with dry runs, load CSV/JSON data, and create time-partitioned or clustered tables. The instructions emphasise safe exploratory querying (LIMIT, dry_run) and operational tasks like schema inspection and table metadata retrieval.
Use this skill when a user needs to query BigQuery data, check table schemas or metadata, load local CSV/NDJSON files into BigQuery, or create partitioned tables for cost-efficient storage. It is ideal for ad-hoc data exploration, quick counts, debugging schema issues, and scripted data loads.
Compatible with agents that can run shell/CLI commands and access GCP credentials (bq/gcloud workflows).
Cette compétence n'a pas encore été examinée par notre pipeline d'audit automatisé.
Dagster
Build and manage Dagster data pipelines -- create assets, jobs, schedules, sensors, and resources.
Dlt
Build data ingestion pipelines with dlt (data load tool) -- extract from APIs, databases, and files, then load to any destination.
dbt CLI Assistant
Run and manage dbt projects via the dbt CLI — initialise projects, run/build models, run tests, generate docs, and debug pipelines.
Metabase (dashboard & questions manager)
Manage Metabase instances: create and run questions, manage dashboards and collections, and interact with the Metabase REST API for analytics workflows.
PostgreSQL
Query and manage PostgreSQL databases via psql: run queries, inspect schemas and tables, check active connections, and perform basic administration and exports.
