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

Format SQL queries with consistent keyword casing, indentation and line breaks (MySQL, PostgreSQL, SQL Server, Oracle, SQLite).

Database Open tool

Compress SQL to a single line by removing comments and extra whitespace.

Database Open tool

Check SQL statements for syntax problems, unbalanced parentheses, unterminated strings and risky patterns.

Database Open tool

Convert CSV data into CREATE TABLE and INSERT statements with inferred column types.

Database Open tool

Convert a JSON array of objects into SQL INSERT statements (with optional CREATE TABLE).

Database Open tool