CSV to DDLBash

This bash script converts CSV files to create table DDL.

Execute this Bash

#!/usr/bin/env bash 
[[ $# -eq 1 && "$1" != "-h" && "$1" != "--help" && -f "$1" ]] || {
    echo "Usage: $(basename "$0") <csv_file>" >&2; exit 1 
}

duckdb -noheader -list :memory: <<SQL 
CREATE TABLE ${1%.*} AS SELECT * FROM read_csv_auto('$1'); SELECT sql FROM duckdb_tables() WHERE table_name = '${1%.*}'; 
SQL
Copy code

Maxime Lemaitre

Created 02/16/26