starlake-ai/yml2ddl
.agents/skills/yml2ddl/SKILL.md
Generate SQL DDL statements from Starlake YAML definitions
$ install --global
skillsauthnpx skillsauth add starlake-ai/starlake-skills yml2ddlInstall 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:37 AM8.4s1 file scanned
SKILL.md
- name:
- yml2ddl
- description:
- Generate SQL DDL statements from Starlake YAML definitions
YML to DDL Skill
Generates SQL DDL (Data Definition Language) statements — CREATE TABLE, ALTER TABLE, etc. — from your Starlake YAML table definitions. Supports multiple target databases through type mappings defined in types/default.sl.yml.
Usage
starlake yml2ddl [options]
Options
--datawarehouse <value>: Target data warehouse name — must match a DDL mapping key intypes/default.sl.yml(required). Examples:bigquery,snowflake,postgres,redshift,synapse,duckdb--connection <value>: JDBC connection name with read/write access (for--applymode)--output <value>: Output directory for generated DDL files (default:./{datawarehouse}/)--catalog <value>: Database catalog name (if applicable)--domain <value>: Generate DDL for this specific domain only (default: all domains)--schemas <value>: Comma-separated list of schemas within the domain to generate DDL for--apply: Execute the generated DDL directly against the database--parallelism <value>: Parallelism level (default: available CPU cores)--reportFormat <value>: Report output format:console,json, orhtml
Configuration Context
Type Mappings in types/default.sl.yml
The DDL generation uses ddlMapping to map Starlake types to database-specific types:
# metadata/types/default.sl.yml
types:
- name: "string"
primitiveType: "string"
ddlMapping:
bigquery: "STRING"
snowflake: "VARCHAR"
postgres: "TEXT"
duckdb: "VARCHAR"
synapse: "NVARCHAR(MAX)"
- name: "long"
primitiveType: "long"
ddlMapping:
bigquery: "INT64"
snowflake: "BIGINT"
postgres: "BIGINT"
duckdb: "BIGINT"
- name: "decimal"
primitiveType: "decimal"
ddlMapping:
bigquery: "NUMERIC"
snowflake: "NUMBER(38,9)"
postgres: "NUMERIC"
Examples
Generate DDL for BigQuery
starlake yml2ddl --datawarehouse bigquery
Generate DDL for Snowflake (Specific Domain)
starlake yml2ddl --datawarehouse snowflake --domain starbake
Generate and Apply DDL to PostgreSQL
starlake yml2ddl --datawarehouse postgres --connection my_pg_conn --apply
Generate DDL to Custom Output Directory
starlake yml2ddl --datawarehouse duckdb --output /tmp/ddl
Generate DDL for Specific Schemas
starlake yml2ddl --datawarehouse snowflake --domain sales --schemas orders,customers
Parallel DDL Generation
starlake yml2ddl --datawarehouse bigquery --parallelism 4
Related Skills
- extract-script - Generate extraction scripts from templates
- xls2yml - Convert Excel to YAML (before DDL generation)
- config - Configuration reference (type mappings)
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