starlake-ai/cnxload
.agents/skills/cnxload/SKILL.md
Load files (Parquet/CSV/JSON) into a JDBC table
$ install --global
skillsauthnpx skillsauth add starlake-ai/starlake-skills cnxloadInstall 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.1s1 file scanned
SKILL.md
- name:
- cnxload
- description:
- Load files (Parquet/CSV/JSON) into a JDBC table
Connection Load Skill
Loads data from Parquet, CSV, or JSON files directly into a JDBC database table. This provides a simple way to push data into any JDBC-compatible database without going through the full Starlake load pipeline.
Usage
starlake cnxload [options]
Options
--source_file <value>: Full path to the source file (required). Supports Parquet, CSV, JSON--output_table <value>: Target JDBC table inschema.tableformat (required)--options k1=v1,k2=v2: JDBC connection options:driver: JDBC driver class (e.g.org.postgresql.Driver)user: Database userpassword: Database passwordurl: JDBC URL (e.g.jdbc:postgresql://localhost:5432/mydb)partitions: Number of partitions for parallel writebatchSize: Batch size for inserts
--write_strategy <value>: Write strategy:APPEND,OVERWRITE--reportFormat <value>: Report output format:console,json, orhtml
Examples
Load Parquet to PostgreSQL
starlake cnxload \
--source_file /data/orders.parquet \
--output_table public.orders \
--options driver=org.postgresql.Driver,url=jdbc:postgresql://localhost:5432/mydb,user=admin,password=secret \
--write_strategy APPEND
Load CSV to Database
starlake cnxload \
--source_file /data/customers.csv \
--output_table public.customers \
--options driver=org.postgresql.Driver,url=jdbc:postgresql://localhost:5432/mydb,user=admin,password=secret \
--write_strategy OVERWRITE
Load with Batch Options
starlake cnxload \
--source_file /data/orders.parquet \
--output_table sales.orders \
--options driver=com.mysql.cj.jdbc.Driver,url=jdbc:mysql://localhost:3306/mydb,user=root,password=secret,batchSize=5000 \
--write_strategy APPEND
Related Skills
- load - Full Starlake load pipeline
- esload - Load data into Elasticsearch
- kafkaload - Load/offload data to/from Kafka
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