KoguNavi

KoguNavi tool

SQL Formatter

Paste SQL and tidy the whitespace so queries are easier to read before review, notes, or documentation.

Local in browser

Runs in your browser for this tool.

Current tools are designed to run in your browser. As a general habit, avoid pasting passwords, private keys, or production secrets into any website.

What it helps with

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

How to use

  1. Paste one or more SQL statements into the input area.
  2. Choose the dialect and formatting options that match your query.
  3. Click Format, then review and copy the formatted SQL.

Examples

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;

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

Does this tool execute SQL?
No. It only formats SQL text. It does not connect to a database or run queries.
Does it validate SQL correctness?
No. Formatting can make SQL easier to read, but it is not a SQL validator.
Which dialects are available?
The tool includes Standard SQL, MySQL, PostgreSQL, SQLite, BigQuery, Snowflake, and SQL Server / T-SQL options.

Related tools

Nearby utilities from the KoguNavi toolbox.

Browse all tools

Developer tools · Local in browser

Cron Expression Explainer

Explain standard 5-field cron expressions locally.

Open tool →

Developer tools · Local in browser

Regex Tester

Test JavaScript regular expressions locally against sample text.

Open tool →

Developer tools · Local in browser

UUID Generator

Generate UUID v4 values locally in your browser.

Open tool →