dct-infer

name

dct-infer

description

Use this skill when the user wants to generate SQL CREATE TABLE statements from data files, infer schema from CSV/JSON/Parquet, create database schemas from existing data, or get column types from a file. Triggers include "generate schema", "create table from csv", "infer types", "what's the schema", "get column types", "sql ddl", or when preparing data for SQL databases like DuckDB, PostgreSQL, or similar.

DCT Infer - Generate SQL Schema

Create DuckDB-compatible CREATE TABLE statements by analyzing data file contents.

When to Use

Use this skill when you need to:

• Create database tables from existing data files
• Document the schema of a dataset
• Generate DDL for ETL pipelines
• Understand column types in a file
• Prepare data for SQL-based analysis

Installation

which dct || go build -o dct && chmod +x ./dct

Usage

dct infer <file> [flags]

Flags

• -t, --table <name>: Table name (default: "default")
• -n, --lines <number>: Number of lines to analyze for type inference (useful for large files)
• -o, --output <file>: Output to file instead of stdout

Examples

Basic schema inference:

dct infer data.csv

With custom table name:

dct infer data.parquet -t events

Save schema to file:

dct infer large.ndjson -n 1000 -t users -o schema.sql

Infer from specific number of rows: