Show HN: SQL Generator – OS React App for SQL Table/Insert Statement Generation (opens in new tab)

(github.com)

12 pointsryanwaldorf1y ago3 comments

This open-source app lets you convert spreadsheet files (e.g. CSV/excel), JSON files, or pasted data to SQL in-clauses or CREATE TABLE/INSERT INTO TABLE combinations. Let's you easily move data into your warehouse for ad hoc analyses. All processing is client-side so your data stays with you. I have it hosted at sqlgenerator.io but you can also clone it and self-host it for security with your own internal applications.

3 comments

memset1y ago

Can you share an example on how to use it? For example, start with some example data as the input?

ryanwaldorfOP1y ago

You can download one of the NZ government's Annual Enterprise Surveys here: https://www.stats.govt.nz/large-datasets/csv-files-for-downl.... Then simply go to the Excel to SQL tab (https://sqlgenerator.io/#/sql-converter/excel-to-sql) and press upload file. It will generate SQL CREATE TABLE and INSERT INTO TABLE statements for you. You can then download it as a file or simply copy and paste it into your query editor.

Additionally, if you want to make any changes like including only certain columns or changing column types/names you can do that via the inputs below the generated SQL. Any changes you make are immediately reflected in the SQL generated.

YuxiaoZ1y ago

Really cool app! Thanks for sharing this Ryan and excited to try it out.

j / k navigate · click thread line to collapse