a apiary.
← All tools

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 tool

SQL IN Clause Generator

Turn a list of values into a safely escaped SQL IN expression.

Open tool

SQL Quote List

Format values as a quoted SQL list, without the IN wrapper.

Open tool

SQL CASE Builder

Turn two-column mappings into a SQL CASE expression.

Open tool

SQL Join Calculator

Calculate join row counts and preview matching and unmatched keys.

Open tool

SQL Syntax Reference

Find PostgreSQL syntax by keyword or task and copy a useful example.

Open tool

SQL Syntax Checker

Check SQL syntax, common mistakes and potential performance issues locally for Oracle, SQL Server, PostgreSQL, MySQL/MariaDB and SQLite.

Open tool

SQL Formatter

Format SQL locally with dialect-aware layout and unchanged tokens.

Open tool

SQL Minifier

Reduce SQL whitespace while preserving quoted values, hints and line boundaries.

Open tool

SQL INSERT Builder

Generate INSERT statements from rows of text, numbers and NULL values for your SQL dialect.

Open tool

SQL UPDATE Builder

Build UPDATE statements with SET fields, WHERE conditions and an explicit warning for unrestricted changes.

Open tool

SQL DELETE Builder

Generate DELETE statements with configurable conditions and a warning before copying an unrestricted deletion.

Open tool

SQL CREATE TABLE Builder

Generate CREATE TABLE statements with column types, defaults and primary keys for your SQL dialect.

Open tool