SQL Formatter for PostgreSQL

Your data never leaves your browser

Format PostgreSQL queries with CTEs, window functions, and JSONB. Your queries stay in your browser.

Example

WITH active AS (SELECT id, name, COUNT(o.id) as orders FROM users u LEFT JOIN orders o ON u.id = o.user_id WHERE status = 'active' GROUP BY u.id HAVING COUNT(o.id) > 5) SELECT * FROM active ORDER BY orders DESC LIMIT 20;

Try Sql Formatter Now

Tips

1Select PostgreSQL for ::casts and JSONB.
2UPPERCASE keywords.
3Format CTEs separately.

Frequently Asked Questions

PG syntax?

Yes. Type casts, JSONB, arrays.

PL/pgSQL?

SQL formats. Procedural: basic support.

Changes behavior?

No. Whitespace only.