starlake-ai/extract-bq-schema
.agents/skills/extract-bq-schema/SKILL.md
Extract schemas directly from BigQuery datasets
$ install --global
skillsauthnpx skillsauth add starlake-ai/starlake-skills extract-bq-schemaInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 16, 2026, 3:36 AM12.5s1 file scanned
SKILL.md
- name:
- extract-bq-schema
- description:
- Extract schemas directly from BigQuery datasets
Extract BigQuery Schema Skill
Extracts table schemas directly from BigQuery datasets into Starlake YAML configuration files. Unlike extract-schema which uses JDBC, this command uses the BigQuery API directly for better metadata extraction.
Usage
starlake extract-bq-schema [options]
Options
--connection <value>: BigQuery connection reference fromapplication.sl.yml--database <value>: GCP Project ID--tables <value>: Comma-separated list ofdataset.tablepairs to extract--external: Include external datasets defined in_config.sl.yml--write <value>: Write mode for output:OVERWRITE,APPEND--accessToken <value>: Access token for GCP authentication--persist <value>: Persist results to files (true/false)--reportFormat <value>: Report output format:console,json, orhtml
Configuration Context
Requires a BigQuery connection in application.sl.yml:
# metadata/application.sl.yml
version: 1
application:
connections:
bigquery:
type: "bigquery"
options:
location: "europe-west1"
authType: "APPLICATION_DEFAULT"
authScopes: "https://www.googleapis.com/auth/cloud-platform"
writeMethod: "direct"
Examples
Extract All Schemas from a Project
starlake extract-bq-schema --database my-gcp-project
Extract Specific Tables
starlake extract-bq-schema --database my-gcp-project --tables sales.orders,sales.customers
Extract with Persist
starlake extract-bq-schema --database my-gcp-project --persist true
Extract Including External Datasets
starlake extract-bq-schema --database my-gcp-project --external
Related Skills
- extract-schema - Extract schema via JDBC
- bq-info - Get BigQuery table information
- extract - Extract both schema and data
Related Skills
starlake-ai/starflow-transform-design
development
VerifiedTrustedCommunity
Design SQL transformations for data pipelines with quality checks and dependency management. Use when the user says "design transforms" or "create SQL transformations".
1SKILL.mdUpdated Apr 16, 2026
starlake-ai/starflow-sprint-planning
devops
VerifiedTrustedCommunity
Plan and track sprint progress for data pipeline implementation. Use when the user says "sprint planning" or "plan data sprint".
1SKILL.mdUpdated Apr 16, 2026
starlake-ai/starflow-source-analysis
testing
VerifiedTrustedCommunity
Analyze data sources in depth: schema, quality, volume, and extraction strategy. Use when the user says "analyze data source" or "profile this data source".
1SKILL.mdUpdated Apr 16, 2026
starlake-ai/starflow-schema-design
data-ai
VerifiedTrustedCommunity
Design Starlake-compatible table schemas with types, constraints, privacy, and expectations. Use when the user says "design schema" or "create table definition".
1SKILL.mdUpdated Apr 16, 2026