Unformat.online
More tools
Clean Text
Strip smart quotes, zero-width characters, non-breaking spaces, and invisible Unicode from any pasted text.
Markdown Viewer
Live split-view editor and renderer — edit on the left, preview on the right.
Text Diff Checker
Compare two texts, JSON payloads, or config files and see exactly what changed, line by line.
Log File Viewer
Open multi-gigabyte log files instantly — chunked indexing and virtual scrolling handle 10GB+ files without freezing your tab.
FileSQL
Drop a CSV or JSON file and query it with SQL instantly — no upload, no server.
Format SQL
Format SQL for MySQL, PostgreSQL, BigQuery, T-SQL, and more — uppercase keywords, proper indentation.
Schema Visualizer
Paste CREATE TABLE statements and get an ER diagram instantly — tables, columns, keys, and foreign-key relationships.
Format JSON
Prettify or minify JSON. Auto-fixes single quotes, trailing commas, and unquoted keys.
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.
JWT Debugger
Decode JWTs instantly — view all claims, check expiry, and see the algorithm. Token never leaves your browser.
Shredder
Remove EXIF, GPS, and author metadata from images and PDFs. Redact secrets from text and log files.
SSL Certificate Checker
Check any domain's SSL/TLS certificate — expiry, issuer, and Subject Alternative Names.
CronScope
Paste a cron schedule and see every run on a 12-month calendar. Never misread a cron expression again.
Regex Tester
Test regex patterns against sample text with live-highlighted matches, or pick from a library of ready-made patterns — no regex knowledge required.
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.

DDL to ER Diagram

Paste a CREATE TABLE script — a migration file, a pg_dump, a schema.sql — and see it as a diagram immediately. No dialect to pick, no account, nothing uploaded.

Loading tool…

DDL this tool reads directly

Migration files

The CREATE TABLE / ALTER TABLE steps from Rails, Django, Prisma, Alembic, Flyway, or Liquibase migrations.

pg_dump --schema-only

PostgreSQL's own schema export — dollar-quoted function bodies and all.

mysqldump --no-data

MySQL/MariaDB's schema-only dump, backticks and ENGINE clauses included.

SSMS Generate Scripts

SQL Server's bracketed identifiers, IDENTITY columns, and GO batch separators.

A schema.sql file

Whatever your team keeps checked into the repo as the source of truth.

SHOW CREATE TABLE output

Copy-pasted straight from a database client — no cleanup needed first.

Where DDL actually comes from

Most people don't sit down and write a clean CREATE TABLE script by hand — DDL shows up as a byproduct of something else. An ORM generates it as a migration. A DBA exports it with pg_dump --schema-only or mysqldump --no-data before a deploy. A teammate pastes the output of SHOW CREATE TABLE into a Slack thread. None of that is tidy, and none of it needs to be before you paste it here.

The parser is deliberately tolerant: unrelated statements — indexes, grants, comments, inserts — are recognized and skipped rather than treated as errors, and one malformed statement in a large file doesn't stop the rest from rendering. Paste the whole thing; it sorts out what matters.

What you get back

An interactive, pannable ER diagram with tables grouped by how they actually reference each other, relationship lines anchored to the specific foreign-key column, and 1 / 0..N cardinality badges inferred from your constraints — plus a plain-English summary and copy-ready sample JOIN queries. The full breakdown of the notation, the grouping logic, and every export format lives on the main SQL Schema Visualizer page.

Frequently asked questions

What counts as DDL here?

CREATE TABLE and ALTER TABLE statements — the ones that define columns, primary keys, and foreign keys. Everything else in a typical migration or dump (CREATE INDEX, INSERT, GRANT, COMMENT ON, and so on) is recognized and silently skipped rather than flagged as an error, so you can paste a whole file without cleaning it up first.

Can I paste an entire migration file, not just one CREATE TABLE?

Yes — that is the common case. Each statement is parsed independently, so if one table definition has a typo, the rest of the file still parses and renders; the problem is reported with its line number rather than blocking everything else.

Does it matter which database the DDL came from?

The dialect is auto-detected from the DDL text — PostgreSQL, MySQL, SQL Server, SQLite, and BigQuery are all supported, including each one's quirks like dollar-quoted function bodies, backtick identifiers, bracketed names, or IDENTITY columns.

Is this the same tool as the main Schema Visualizer?

Yes — this page is a focused entry point for people who already have a DDL script in hand. The full tool, including the notation guide and every export option, lives at the Schema Visualizer.

Related tools