csvsql
Generate SQL statements for a CSV file or execute those statements directly on a database.
TLDR
Generate a CREATE TABLE SQL statement for a CSV file
$ csvsql [path/to/data.csv]
Import a CSV file into an SQL database
$ csvsql --insert --db "[mysql://user:password@host/database]" [data.csv]
Run an SQL query on a CSV file
$ csvsql --query "[select * from 'data']" [data.csv]