SQL Formatter

text utilitiesPopular

Format, beautify, and minify SQL queries across Standard SQL, PostgreSQL, MySQL, SQLite, and T-SQL dialects.

100% Client-Side — Processed privately & locally in your browser.

Query Templates & Examples

SQL Dialect

Indentation

Keyword Casing

Comma Placement

Raw SQL Query9 lines · 759 chars

Formatted ResultBeautified

WITH active_customers AS (
  SELECT customer_id,
    first_name,
    last_name,
    email,
    created_at,
    ROW_NUMBER() OVER (PARTITION BY country_code
    ORDER BY created_at DESC
    ) AS rank_in_country
  FROM customers
  WHERE status = 'ACTIVE'
      AND deleted_at IS NULL
  )
SELECT c.customer_id,
  c.first_name || ' ' || c.last_name AS full_name,
  c.email,
  COUNT(o.order_id) AS total_orders,
  COALESCE(SUM(o.total_amount), 0) AS lifetime_spent
FROM active_customers c
  LEFT JOIN orders o
  ON o.customer_id = c.customer_id
    AND o.status IN ('COMPLETED', 'SHIPPED')
  INNER JOIN loyalty_tiers lt
  ON lt.tier_id = c.customer_id
WHERE c.rank_in_country <= 10
GROUP BY c.customer_id,
  c.first_name,
  c.last_name,
  c.email
HAVING COUNT(o.order_id) > 2
ORDER BY lifetime_spent DESC,
  c.customer_id ASC
LIMIT 50;

33 lines · 830 chars

Dialect: Standard SQLANSI SQL-92/99/2016

Pro SQL Formatting Capabilities

Zero DependenciesClient-side parsing ensures full security. Your database queries, schemas, and credentials never touch a server.

Clause HierarchyAutomatically indents subqueries, JOIN conditions, CTE blocks, and CASE WHEN statements for clean visual scanning.

Leading vs Trailing CommasToggle comma placement based on your team's style guide or database migration conventions.

1Paste your raw, minified, or unformatted SQL query into the editor.
2Select your SQL dialect (Standard SQL, PostgreSQL, MySQL, SQLite, or T-SQL).
3Configure keyword casing (UPPERCASE, lowercase), indentation spacing, and comma placement.
4Click 'Format SQL' to beautify or 'Minify Query' to compact into a single line.
5Copy formatted SQL or download as a .sql file.

Frequently Asked Questions

Is my data sent to any server?

No. All processing for this tool occurs directly within your web browser using Web APIs and WebAssembly. Your data never leaves your computer.

Can I use this tool offline?

Once loaded, most utilities remain functional even if your connection drops. DevtUtils is designed to be lightweight and resilient.

Related Utilities

Explore other handy tools in text utilities

Popular

JSON Formatter

Prettify, minify and validate your JSON data.

text utilities

Popular

AWS CloudWatch Log Formatter

Format, colorize, and parse raw AWS CloudWatch logs, Lambda execution streams, and embedded JSON payloads.

text utilities

Unix Timestamp Converter

Convert Unix timestamps to human-readable dates and vice versa.

text utilities