Sepio

Yes! You can paste raw SQL CREATE TABLE DDL statements or DBML scripts directly into Sepio to reverse-engineer visual ERD diagrams in seconds. You can also import existing schemas from TypeScript definitions (Drizzle ORM, TypeORM, Mongoose ODM), Prisma schema files, and Mermaid ERDs, or connect directly via live PostgreSQL and MySQL connection strings for instant database introspection.

Sepio features a built-in AST diagnostic engine that inspects your database design in real time as you model. It flags architectural mistakes before they hit production migrations, including missing primary keys, foreign key data type mismatches (e.g. referencing a UUID with an INT column), unindexed foreign keys that cause severe JOIN latency, duplicate table/column names, and naming convention violations (snake_case, camelCase, PascalCase).

Sepio combines the fluid, drag-and-drop canvas feel of Figma and DrawSQL with the fast code generation of dbdiagram.io. Unlike DrawSQL, which caps free accounts at 15 tables per diagram, Sepio is 100% free with unlimited tables. Unlike dbdiagram.io, which forces a text-only DSL without visual canvas editing, Sepio supports full visual relationship drawing alongside native Drizzle ORM TypeScript export, offline PWA storage, and live multiplayer collaboration. Read our detailed Sepio vs. DrawSQL & dbdiagram comparison or explore our roundup of free DrawSQL alternatives.

Sepio generates production-ready code for type-safe Drizzle ORM TypeScript (pgTable, mysqlTable, sqliteTable), raw PostgreSQL DDL, MySQL DDL, SQLite DDL, Microsoft SQL Server (MSSQL), Oracle SQL, DBML (Database Markup Language), Prisma schemas, and Mermaid.js diagrams, as well as lossless vector SVG and high-resolution PNG image exports for documentation.

Yes. Sepio tracks schema version history with stable element identifiers. When you rename columns, add new fields, alter data types, or introduce new tables, Sepio's migration engine detects the exact delta and generates non-destructive SQL migration scripts (including ALTER TABLE, ADD COLUMN, and RENAME COLUMN statements) rather than forcing destructive drop-and-recreate commands.

Because Drizzle ORM defines database schemas in pure TypeScript Abstract Syntax Trees (ASTs), Sepio can parse your existing Drizzle files directly into an interactive canvas. When you connect tables or modify fields visually, you can immediately export updated, type-safe TypeScript definitions back into your project repository, eliminating out-of-date ERD documentation rot. Learn more in our guide on visual schema modeling with Drizzle ORM and read our Drizzle ORM vs. Prisma schema benchmark.

Yes. Sepio is designed for production architectures. It supports PostgreSQL multi-namespaces (e.g., custom schemas alongside 'public'), composite primary keys, composite foreign key relationships across multiple columns, custom ENUM types, unique constraints, and granular referential action cascades (CASCADE, RESTRICT, SET NULL, NO ACTION). Check out our production RBAC database schema blueprint and our multi-tenant SaaS PostgreSQL guide for complete runnable examples.

No limits! You can design unlimited database diagrams, create hundreds of tables, and export as much code as you need. All local modeling is saved in your browser via IndexedDB with zero artificial paywalls or table caps.

No account required. You can start modeling schemas immediately upon landing on the app. Your work is automatically saved locally in your browser. Signing in is completely optional and unlocks cloud backups, cross-device synchronization, live team multiplayer collaboration, and shareable web links.

When signed into a cloud workspace, multiple developers and architects can collaborate on the same database diagram simultaneously. Sepio uses conflict-free replicated data structures (CRDTs) to sync changes in real time with live cursor presence, avatar badges, version snapshots, and shareable read/edit permission links.

Yes! You can export crisp vector SVG and PNG diagrams for embedding directly into GitHub READMEs, pull request descriptions, and Confluence. You can also generate live, responsive web embed links to embed interactive pan-and-zoom schema diagrams inside Notion pages, internal wikis, or documentation portals.

100% private. In local mode, your schema designs never leave your browser sandbox. When you choose to use cloud sync or multiplayer, data is encrypted both in transit (TLS 1.3) and at rest. We never sell your schema definitions, and your database designs are never used to train machine learning or AI models.