Unformat.online
More tools
Clean Text
Strip smart quotes, zero-width characters, non-breaking spaces, and invisible Unicode from any pasted text.
Format JSON
Prettify or minify JSON. Auto-fixes single quotes, trailing commas, and unquoted keys.
Format SQL
Format SQL for MySQL, PostgreSQL, BigQuery, T-SQL, and more — uppercase keywords, proper indentation.
Format YAML
Format and validate YAML. Catches indentation errors in Kubernetes, Docker Compose, and GitHub Actions files.
Format XML
Indent and pretty-print XML. Works with SOAP, RSS, Maven POM, Android manifests, and SVG.
Markdown Viewer
Live split-view editor and renderer — edit on the left, preview on the right.
FileSQL
Drop a CSV or JSON file and query it with SQL instantly — no upload, no server.
Shredder
Remove EXIF, GPS, and author metadata from images and PDFs. Redact secrets from text and log files.
CronScope
Paste a cron schedule and see every run on a 12-month calendar. Never misread a cron expression again.
JWT Debugger
Decode JWTs instantly — view all claims, check expiry, and see the algorithm. Token never leaves your browser.
Base64
Encode text or files to Base64, or decode Base64 strings and preview images inline.
URL Encode / Decode
Encode URLs or decode percent-encoded strings like %20, %3D, %26 — instantly.
UUID Generator
Bulk-generate cryptographically random v4 UUIDs using crypto.randomUUID(). Copy one or all at once.

Format MySQL Online

Beautify MySQL queries with proper indentation and keyword formatting. Paste your MySQL SQL and get clean, readable output instantly — 100% client-side.

Rules:Smart QuotesConverts curly quotes (“” ‘’) to straight quotes. Always active.Non-Breaking SpacesReplaces non-breaking spaces (U+00A0) with regular spaces. Always active.Line EndingsNormalizes CRLF → LF and trims trailing whitespace per line. Always active.Removes invisible zero-width characters (U+200B, U+200C, U+200D) that silently break string comparisons.Strips the Byte Order Mark (U+FEFF) that causes “invalid character” errors in parsers and editors.Removes soft hyphens (U+00AD) from PDFs that show as garbled characters in code editors.Converts mixed tabs/spaces to a consistent indent width. Click to pick a size.Collapses all line breaks into one continuous paragraph. Great for reflowing PDF or email text.Control blank line density. Click to pick Keep 1 or Remove all.Text never leaves your browser
0 characters

MySQL SQL formatting

MySQL is the most widely deployed open-source relational database. Its SQL dialect includes MySQL-specific syntax like LIMIT ... OFFSET, INSERT IGNORE, ON DUPLICATE KEY UPDATE, SHOW TABLES, and backtick-quoted identifiers.

This formatter uses the MySQL dialect to correctly parse and format these constructs. Standard SQL formatters may misinterpret backtick identifiers or MySQL-specific functions — using the right dialect produces accurate output.

How to format MySQL queries

  1. Paste your MySQL SQL query into the text area above.
  2. The formatter is pre-set to MySQL dialect. Adjust keyword casing if needed.
  3. Copy the formatted output with the Copy button or Ctrl+K.

Other SQL formatters