Query & data builders
SELECT, INSERT, UPDATE, DELETE, JOIN and CREATE — plus fake test rows.
16 tools · nothing uploaded
/
- ALTER TABLE GeneratorBuild an ALTER TABLE to add, drop, rename or retype a column.
- CREATE TABLE GeneratorBuild a CREATE TABLE statement column by column.
- CSV to SQL INSERT GeneratorTurn CSV rows straight into INSERT statements.
- DELETE Query GeneratorBuild a DELETE statement that will not empty the table by accident.
- Fake SQL Data GeneratorFill a table with realistic names, emails and dates from its CREATE TABLE.
- INSERT Query GeneratorBuild an INSERT statement with values quoted correctly.
- JSON to SQL INSERT GeneratorTurn a JSON array straight into INSERT statements.
- SELECT Query GeneratorBuild a SELECT with conditions, grouping, sorting and a limit.
- SQL INDEX GeneratorBuild a CREATE INDEX statement, single column or composite.
- SQL JOIN GeneratorBuild an INNER, LEFT, RIGHT, FULL or CROSS JOIN between two tables.
- SQL Pagination GeneratorAdd the right LIMIT, OFFSET or FETCH NEXT for your database.
- SQL Random Data GeneratorGenerate random values that match each column type.
- SQL Test Data GeneratorGenerate predictable, sequential rows for a table you are testing.
- SQL WHERE Clause BuilderBuild a WHERE clause from conditions, with IN and BETWEEN handled.
- UPDATE Query GeneratorBuild an UPDATE statement with a WHERE clause you can see.
- XML to SQL INSERT GeneratorTurn repeated XML records into INSERT statements.