Loading page
About this tool
Format SQLite SQL with clause-aligned line breaks, keyword casing and full support for PRAGMA statements and SQLite quoting.
This formatter rewrites SQLite SQL with each major clause — SELECT, FROM, JOIN, WHERE, GROUP BY, ORDER BY, LIMIT — on its own line, keywords case-folded against the official SQLite keyword list, and conditions split at top-level AND/OR. It understands SQLite specifics that generic formatters trip over: PRAGMA statements, doubled-quote string escapes ('It''s'), [bracket] and `backtick` identifiers, and ?, :name, @name and $name bind parameters. Formatting is purely lexical, so the output executes identically to the input.
Open SQLite Query Formatter on AltFTool — it loads instantly in your browser.
Paste your code or data sample into the workspace.
Pick the format, conversion, or analysis you need.
Copy the polished result straight back into your project.
PRAGMA, bind parameters, [bracket] identifiers and '' escapes are parsed correctly, not mangled.
Only whitespace and keyword letter-case change; strings and identifiers are untouched byte for byte.
Unterminated strings, comments and bracket identifiers are reported with their position instead of producing broken output.
No. SQLite ignores extra whitespace and treats keywords case-insensitively, so a purely lexical reformat produces a byte-different but semantically identical statement. This tool never reorders tokens, only inserts line breaks and changes keyword letter-case.
Double it: 'It''s done' is the string It's done. SQLite follows the SQL standard here and does not support backslash escapes inside string literals, which is why this formatter treats '' as part of the same string token rather than the end of one.
Four: "double quotes" (the SQL standard), `backticks` (MySQL compatibility), [square brackets] (SQL Server compatibility) and no quoting at all for identifiers that are not keywords. All four are recognised by this formatter and passed through unchanged.
PRAGMA is SQLite's mechanism for reading and changing library behaviour per connection or per database file — for example PRAGMA foreign_keys = ON enables foreign-key enforcement and PRAGMA journal_mode = WAL switches to write-ahead logging. PRAGMA is SQLite-only, which is why general SQL formatters often refuse to parse it.