to-sql

Node.js script to read .csv, .tsv, and Excel spreadsheets into a series of standard SQL CREATE TABLE and INSERT statements.

$ npm install -g to-sql

Example:

$ to-sql MySpreadsheet.xlsx
Creating table Sheet1
Inserting 171 rows
Creating table Sheet2
Inserting 0 rows

Uses the fabulous xlsx library for parsing the Excel spreadsheet.

It does some simple regular expression-based type inference, automatically distinguishing between TEXT, INTEGER, and REAL, as well as some formats of DATE and TIME.

To-do

• Support more types in the type inference part
• Infer foreign relationships if possible

License

Copyright 2016-2017 Christopher Brown. MIT Licensed