PostgreSQL Query Generator

SQL Tools

Build Postgres SELECT, INSERT, UPDATE, DELETE and DDL from a form.

Runs entirely in your browser โ€” nothing is uploaded

Features

  • SELECT with joins, filters, grouping, ordering and limits.
  • INSERT, UPDATE, DELETE and CREATE TABLE from the same form.
  • Postgres-native types, RETURNING and ON CONFLICT support.
  • Double-quoted identifiers where they are needed.

How to use the PostgreSQL Query Generator

  1. 1Choose the statement type and target table.
  2. 2Fill in columns, conditions and clauses.
  3. 3Copy the generated Postgres SQL.

Frequently asked questions

Why are some identifiers quoted?

Postgres folds unquoted identifiers to lower case, so anything with capitals, spaces or reserved words must be double-quoted to survive.