🦐 Jacques - decontaminating schemas

About

Jacques decontaminates database schema dumps. Cleaning, folding and consolidating schemas for use in migrations, sqlc, ORMs, and version control.

Currently supports PostgresSQL. More databases coming soon.

Features:

  • Removes noise: comments, `GRANT`, `REVOKE`, `OWNER TO`, `SET`, session config
  • Consolidates `CREATE TABLE` + `ALTER TABLE` statements into self-contained definitions
  • Inlines foreign key constraints into column definitions
  • Converts sequences to `SERIAL`/`BIGSERIAL` types
  • Handles database-specific types: enums, domains, generated columns
  • Guaranteed semantic equivalence - cleaned output produces identical schema

Experimental Folding

Toggles foldering transformations that can't be end-to-end tested. Because the semantic equivalence can't be tested these schema transformations are opt-in at your own risk - Please check the output carefully!

Jacques on GitHub →

Privacy

Your database schemas very important. Do not paste them into random tools on the internet!

But this tool:

• All processing happens locally in your browser

• No data is sent to any server

• Your schema is never stored or logged

Please feel free to audit the code on github or run it offline yourself

Jacques on GitHub →

Loading Jacques...
Input
Output