Generate SQL statements from CSV files with csvsql. Convert CSV data to SQL, import into databases, and run queries directly. Free online tool, no registration required.
csvsql
Generate SQL statements for a CSV file or execute those statements directly on a database. Included in csvkit. More information: https://csvkit.readthedocs.io/en/latest/scripts/csvsql.html.
- Generate a
CREATE TABLESQL 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}}