starlake-ai/extract-script
.agents/skills/extract-script/SKILL.md
Generate extraction scripts from Mustache/SSP templates
$ install --global
skillsauthnpx skillsauth add starlake-ai/starlake-skills extract-scriptInstall 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 AM10.1s1 file scanned
SKILL.md
- name:
- extract-script
- description:
- Generate extraction scripts from Mustache/SSP templates
Extract Script Skill
Generates extraction scripts from Mustache or SSP (Scalate) templates. This is useful for generating custom SQL DDL scripts (CREATE, ALTER, DROP) for different database platforms.
Usage
starlake extract-script [options]
Options
--domain <value>: Comma-separated list of domains to generate scripts for (default: all)--template <value>: Path to the template directory containing Mustache/SSP templates (required)--audit-schema <value>: Audit DB schema that will contain the audit export table (required)--delta-column <value>: Default date column used for incremental extraction tracking--reportFormat <value>: Report output format:console,json, orhtml
Configuration Context
DDL Templates
Templates are organized by database platform in metadata/extract/ddl/:
metadata/extract/ddl/
├── bigquery/
│ ├── create.ssp
│ ├── alter.ssp
│ └── drop.ssp
├── postgres/
│ └── drop.ssp
└── synapse/
├── create.ssp
├── alter.ssp
└── drop.ssp
Template Variables
Templates receive the following variables:
- Domain/schema information (name, tables)
- Table attributes (columns, types, constraints)
- Database-specific type mappings from
types/default.sl.yml
Examples
Generate DDL Scripts for All Domains
starlake extract-script --template metadata/extract/ddl/bigquery --audit-schema audit
Generate Scripts for Specific Domains
starlake extract-script --domain sales,hr --template metadata/extract/ddl/postgres --audit-schema audit
Generate with Delta Column for Incremental
starlake extract-script --template metadata/extract/ddl/synapse --audit-schema audit --delta-column updated_at
Related Skills
- extract-schema - Extract schema from database
- yml2ddl - Generate DDL from YAML definitions
- 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