EXPLORE THE COLLECTION
SQL tools
Format, check and generate SQL, explore joins and look up examples. Queries are processed locally and never executed.
SQL to XML Builder
Use an XML template to generate a query that populates elements from table columns.
Open toolSQL IN Clause Generator
Turn a list of values into a safely escaped SQL IN expression.
Open toolSQL Quote List
Format values as a quoted SQL list, without the IN wrapper.
Open toolSQL CASE Builder
Turn two-column mappings into a SQL CASE expression.
Open toolSQL Join Calculator
Calculate join row counts and preview matching and unmatched keys.
Open toolSQL Syntax Reference
Find PostgreSQL syntax by keyword or task and copy a useful example.
Open toolSQL Syntax Checker
Check SQL syntax, common mistakes and potential performance issues locally for Oracle, SQL Server, PostgreSQL, MySQL/MariaDB and SQLite.
Open toolSQL Formatter
Format SQL locally with dialect-aware layout and unchanged tokens.
Open toolSQL Minifier
Reduce SQL whitespace while preserving quoted values, hints and line boundaries.
Open toolSQL INSERT Builder
Generate INSERT statements from rows of text, numbers and NULL values for your SQL dialect.
Open toolSQL UPDATE Builder
Build UPDATE statements with SET fields, WHERE conditions and an explicit warning for unrestricted changes.
Open toolSQL DELETE Builder
Generate DELETE statements with configurable conditions and a warning before copying an unrestricted deletion.
Open toolSQL CREATE TABLE Builder
Generate CREATE TABLE statements with column types, defaults and primary keys for your SQL dialect.
Open tool