Getting a SQL Table Definition From a CSV File

Make sure you have sqlite3 available:

$ sudo apt install sqlite3

Also, make sure your .csv file has a header.

Then:

$ sqlite3 <<EOF \
.mode csv \
.import "~/my_data.csv" my_table \
.schema my_table \
EOF

Kudos to this Stack Overflow answer.