BEAD— Browser Emergency Assistance Desk

SQL Formatter

Pretty-print SQL across 14 dialects — Postgres, MySQL, BigQuery, Snowflake, and more.

DialectKeywordsIndentBlank lines

Input

Formatted

SELECT
  u.id,
  u.email,
  count(o.id) AS order_count
FROM
  users u
  LEFT JOIN orders o ON o.user_id = u.id
WHERE
  u.created_at > '2024-01-01'
GROUP BY
  u.id,
  u.email
HAVING
  count(o.id) > 3
ORDER BY
  order_count DESC
LIMIT
  50;

You might also like

SQL CREATE TABLE GeneratorInfer column types from sample data and emit CREATE TABLE for PostgreSQL, MySQL, SQLite, or SQL Server.
JSON Formatter & ValidatorPretty-print, minify, and validate JSON.
XML Formatter & ValidatorPretty-print or minify XML and validate that it's well-formed.
Escape / UnescapeEscape or unescape strings for JSON, JavaScript, HTML attribute, XML, and SQL contexts.

Used in these workflows

SQL CleanupPretty-print messy SQL.