Format or minify SQL and XML, and check XML is well-formed

Options you can set

• Language
• Indent
• Uppercase SQL keywords
• Keep XML comments when minifying

Good to know

• SQL is formatted, not validated: the formatter doesn't check that a query is correct. Minifying SQL removes comments.
• XML is checked for well-formedness, with the line and column of the first problem. It isn't validated against a schema or DTD.
• Elements that contain text keep their content exactly as written; whitespace between elements is treated as layout.

SQL & XML Formatter FAQ

More developer & text tools in Toolfox

• JSON Formatter Format, minify and validate JSON, with exact error locations.
• CSV ↔ JSON Convert CSV to JSON and JSON to CSV, with clear rules for headers, types and nesting.
• Base64 Encoder / Decoder Encode text or files as Base64, or decode Base64 back to text or a file.
• Hash Generator Calculate SHA-256 and other checksums for text or files, and compare against an expected value.
• QR Code Generator Create QR codes for links, text, Wi-Fi networks and contacts. Export as PNG or SVG.
• Text Diff Compare two texts or text files and see added, removed and changed lines.
• Password Generator Generate strong random passwords or memorable passphrases, with an honest strength estimate. Created on this computer and never stored.
• UUID Generator Generate UUIDs (v4 random, v7 time-ordered), ULIDs and NanoIDs, or inspect pasted IDs for their version and timestamp.
• Lorem Ipsum Generator Generate placeholder text as paragraphs, sentences or words, in plain text or HTML.
• Barcode Generator Create Code 128, EAN-13, EAN-8, UPC-A, Code 39 and ITF barcodes, with check digits computed and validated. Export as PNG or SVG.
• QR Code Reader Read QR codes from photos and screenshots, including links, Wi-Fi details and contact cards.
• Word Counter Count words, characters, sentences and paragraphs, estimate reading time and find the most used keywords.
• Case Converter Change text to UPPERCASE, lowercase, Title Case, Sentence case, camelCase, snake_case and other cases.
• Text Cleaner Trim, de-duplicate, sort and tidy lines, collapse spaces, and strip punctuation or HTML tags.
• Find & Replace Find and replace text, using plain text or regular expressions with group references.
• Regex Tester Test a regular expression against text and see every match with its position and captured groups.
• URL, HTML & Binary Encoder Encode or decode URLs, HTML entities, binary, hex and Unicode escapes.
• URL Parser Break a URL into scheme, host, port, path, query parameters and fragment, with everything decoded.
• JWT Decoder Decode a JSON Web Token to read its header, payload and expiry, and optionally check an HMAC signature.
• Timestamp Converter Convert Unix timestamps to dates and dates to Unix time, in UTC and your local time zone.
• Color Converter Convert colors between HEX, RGB, HSL, HSV and CMYK, find the nearest CSS name and check WCAG contrast.
• Number Base Converter Convert whole numbers of any size between binary, octal, decimal, hexadecimal and any base from 2 to 36.
• Markdown to HTML Convert Markdown to HTML, as a fragment or a complete styled page, or turn HTML back into Markdown.
• JSON, YAML & XML Converter Convert data between JSON, YAML, TOML and XML, with the input format detected automatically.

See all 57 tools →