Show HN: SQL Generator – OS React App for SQL Table/Insert Statement Generation

[ryanwaldorf]

https://github.com/ryanwaldorf/sqlgenerator

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.

[memset]

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

[ryanwaldorf → memset]

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.

[YuxiaoZ]

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