KoguNavi

SQL Formatter

Paste SQL and make it easier to read before sharing or reviewing. This formats whitespace only; it does not execute, validate, or upload SQL.

Local-first

SQL text stays in your browser for this tool. It is not uploaded, stored, logged, validated, or executed.

More tiny tools

Nearby utilities from the KoguNavi toolbox.

Browse all tools
Developer toolsLocal-first

UUID Generator

Generate UUID v4 values locally in your browser.

Open tool

Developer toolsLocal-first

JSON Formatter

Format, validate, and beautify JSON locally in your browser.

Open tool

Developer toolsLocal-first

Hash Generator

Generate SHA hashes for text locally with Web Crypto.

Open tool

Try it with

Basic SELECT

Input

select id,name,email from users where status='active' and created_at >= '2026-01-01' order by created_at desc;

Output

SELECT
  id,
  name,
  email
FROM
  users
WHERE
  status = 'active'
  AND created_at >= '2026-01-01'
ORDER BY
  created_at DESC;

JOIN query

Input

select u.id,u.email,o.total from users u inner join orders o on o.user_id=u.id where o.total > 100 order by o.total desc;

Output

SELECT
  u.id,
  u.email,
  o.total
FROM
  users u
  INNER JOIN orders o ON o.user_id = u.id
WHERE
  o.total > 100
ORDER BY
  o.total DESC;

PostgreSQL LIMIT

Input

select id,title,published_at from posts where published_at is not null order by published_at desc limit 10;

Output

SELECT
  id,
  title,
  published_at
FROM
  posts
WHERE
  published_at IS NOT NULL
ORDER BY
  published_at DESC
LIMIT
  10;

How to use

  1. Paste or type input into the tool.
  2. Run the action or review live output.
  3. Copy the result, or clear the workspace when finished.

Inputs and outputs

SQL input
One or more SQL statements, optionally separated by semicolons.
Formatted SQL
Whitespace-formatted SQL text for review and sharing, or a readable formatting error.

What it helps with

  • Clean messy SQL before sharing
  • Make generated SQL easier to review
  • Format SQL without uploading sensitive queries

Useful for structured workflows

  • Normalize SQL snippets before documentation
  • Format generated SQL for review
  • Prepare SQL examples for markdown output

Good to know

  • Formatting only, not validation.
  • Does not execute SQL.
  • Dialect support may vary.
  • Stored procedures and vendor-specific syntax may not format perfectly.

FAQ

More small answers will be added as the toolbox grows.