Analyzes a CSV file and generates database table schema, all within the browser
JavaScript HTML CSS
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
src wrap jts fields in fields property Apr 27, 2016
styles add footer Apr 22, 2016
test add tests and linter Apr 26, 2016
vendor init of csv-schema Apr 22, 2016
.babelrc add tests and linter Apr 26, 2016
.gitignore init Feb 8, 2016
README.md add tests and linter Apr 26, 2016
index.html add tag manager / GA Apr 24, 2016
package.json add tests and linter Apr 26, 2016
webpack.config.js use babel-polyfill in build Apr 26, 2016

README.md

CSV Schema

Analyzes a CSV file and generates database table schema, all within the browser

screenshot of application

This application parses CSV files (including huge ones) within the browser. It analyzes each field to suggest the best database field type, max length, and whether or not there are any null values. From there, you can rename fields, ignore them, override field types/lengths, etc. and generate database table creation sql for MySQL, MariaDB, Postres, Oracle, or SQLite3.

Development

  • Install dependencies using npm install
  • Run a development server using npm start
  • Run linter and tests using npm test
  • Run a production build using npm run build
  • Deploy the application to surge using npm run deploy

This application uses PapaParse for CSV parsing and Knex.js for SQL query building.