Which migration tools can be drawn on PostgreSQL?

Flyway, Liquibase, golang-migrate, Alembic, goose, dbmate, Atlas, Prisma Migrate, DbUp, FluentMigrator, Doctrine Migrations, Laravel, ActiveRecord (Rails), Django, Drizzle ORM, Sqitch, Diesel, EF Core, MikroORM, Knex.js, Sequelize, TypeORM.

Does SchemaDrawer connect to my PostgreSQL database?

No. Every drawing starts a fresh, empty container of the chosen version, runs your migrations in it, reads the schema back and destroys the container.

Supported database

PostgreSQL schema diagrams from migrations

Q: Which PostgreSQL versions does SchemaDrawer support?

10, 11, 12, 13, 14, 15, 16, 17, 18.

Run your migrations on a real PostgreSQL 10, 11, 12, 13, 14, 15, 16, 17, 18 in Docker and get the resulting schema as an SVG. 22 migration tools can draw on PostgreSQL.

Get started PostgreSQL documentation

Versions

Pass the version as the version field with databaseType=POSTGRESQL. Each one is a stock image, started fresh for every drawing.

Version	Image
`10`	`postgres:10`
`11`	`postgres:11`
`12`	`postgres:12`
`13`	`postgres:13`
`14`	`postgres:14`
`15`	`postgres:15`
`16`	`postgres:16`
`17`	`postgres:17`
`18`	`postgres:18`

What the diagram shows on PostgreSQL

Tables land in the public schema. Type names are the internal ones PostgreSQL reports: int4 for INTEGER, int8 for BIGINT, bpchar for CHAR, timestamptz for TIMESTAMP WITH TIME ZONE.

The types are the names the engine's JDBC metadata reports, without lengths: an integer column reads int4, a short text varchar, a calendar date date. Tables are read from public; the migration tool's own bookkeeping table is left out.

Migration tools that draw on PostgreSQL

petclinic on postgresql 18

ER diagram of the PetClinic schema drawn by SchemaDrawer on PostgreSQL 18

The PetClinic sample, drawn from Flyway migrations on PostgreSQL 18. Open the SVG.

Run it

Draw on PostgreSQL 18

The same request works for every tool; only migrationType and the files change.

curl -X POST https://schemadrawer.com/api/v1/drawing \
  -H "Request-Id: $(uuidgen)" \
  -F "userId=5f0c1d2e-3a4b-4c5d-8e6f-7a8b9c0d1e2f" \
  -F "migrationType=FLYWAY" \
  -F "databaseType=POSTGRESQL" \
  -F "version=18" \
  -F "files=@db/migration/V1__create_owners_and_pets.sql" \
  -F "files=@db/migration/V2__create_vets.sql" \
  -F "files=@db/migration/V3__create_visits.sql"
# {"jobId":"0b6e2f4c-8d1a-4c3e-9f7a-2a5b6c7d8e9f"}

- uses: schemadrawercom/action@v1
  with:
    sql-directory: db/migration
    output-path: docs/schema-diagram.svg
    migration-type: FLYWAY
    database-type: POSTGRESQL
    database-version: '18'
    github-token: ${{ secrets.GITHUB_TOKEN }}

From the blog

Reading about PostgreSQL

DatabasesAugust 25, 20266 min read

Draw your PostgreSQL schema now

Upload the migration directory, pick the version you deploy to, get an SVG back.

Get started See examples