Free database schema tools
Small tools for the jobs around a schema: converting it, reading it out of code, checking it, and working out the migration between two versions. Each one runs on its page with no account, using the same converters as DB Planner itself, for PostgreSQL, MySQL, and SQL Server.
Diagram a database you already have
One page per database, each built around the dump its own tooling writes.
- PostgreSQL ER diagram tool
From pg_dump --schema-only to an ER diagram, types intact.
- MySQL ER diagram tool
From mysqldump --no-data to an ER diagram with its foreign keys.
- SQL Server ER diagram tool
From an SSMS schema script to an ER diagram, without a connection.
Convert between SQL and DBML
For a schema that exists as a dump, or as DBML that needs to become a database.
- SQL to DBML converter
Paste a PostgreSQL, MySQL, or SQL Server schema and get DBML.
- DBML to SQL converter
Generate PostgreSQL, MySQL, or SQL Server DDL from DBML.
Read a schema out of application code
For a schema that lives in an ORM. Each reads the code into DBML, ready to draw.
- Prisma schema to ER diagram
Read a schema.prisma into DBML and draw it as a diagram.
- Django models to ER diagram
Read a models.py into DBML, join tables included.
- Rails schema to ER diagram
Read db/schema.rb into DBML with its foreign keys.
- EF Core to ER diagram
Read a model snapshot or entity classes into DBML.
- TypeORM to ER diagram
Read *.entity.ts files into DBML with their relations.
Generate, check, and migrate
For a schema you are changing: the code for it, what is wrong with it, and how to get there.
- DBML to Prisma and Drizzle
Generate Prisma, Drizzle, SQLAlchemy, TypeScript, or Zod from a schema.
- Database schema checker
Score a schema and list what a reviewer would flag.
- SQL migration generator
Diff two schemas and get the migration script between them.
When the schema needs to be a diagram a team can edit together, that is the ER diagram tool these were taken from. Or start from a ready-made schema template.