HomeIn-Clause Generator

Welcome to SQL Generator

This site provides tools to generate SQL statements from your local files so you can easily run ad hoc analytics on your data. It currently provides two types of tools:

  • SQL Table Generators that convert your data into SQL CREATE TABLE and INSERT INTO TABLE statements. Works for spreadsheet files (CSV, TSV, and excel), JSON files, and pasted tabular data.
  • SQL In-Clause Generator converts your data into WHERE or WHERE NOT statements so you can easily filter the data sets already in your warehouse.

All operations are performed client-side so your data never leaves your computer. Additionally, this is open source so feel free to clone the GitHub repository and host it yourself.