Format SQL queries with consistent keyword casing, indentation and line breaks (MySQL, PostgreSQL, SQL Server, Oracle, SQLite).
Database
SQL & Database Tools
These tools work on SQL as text, so you can use them with any database — PostgreSQL, MySQL, SQL Server, Oracle or SQLite — without connecting to anything. Format a long query so it can be reviewed, minify it for a log line, or check the syntax before it reaches production.
The generators save the tedious part of database work: turning a spreadsheet export or a JSON file into INSERT statements, or a list of IDs into a correctly quoted IN clause.
Tools in this category
Compress SQL to a single line by removing comments and extra whitespace.
Database
Check SQL statements for syntax problems, unbalanced parentheses, unterminated strings and risky patterns.
Database
Generate INSERT statements from a table definition, sample rows, CSV or JSON.
Database
Turn a list of values (one per line or comma separated) into a quoted SQL IN (...) clause.
Database
Convert tabular data into a SQL VALUES list or a VALUES-based derived table.
Database
Convert CSV data into CREATE TABLE and INSERT statements with inferred column types.
Database
Convert a JSON array of objects into SQL INSERT statements (with optional CREATE TABLE).
Database
Guides
More guides