Tool for generating automatic migrations/schema diff

This page summarizes the projects mentioned and recommended in the original post on /r/PostgreSQL

Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SaaSHub - Software Alternatives and Reviews
  • atlas

    Manage your database schema as code (by ariga)

  • One of https://atlasgo.io's creators here.

  • pgdiff

    Compares the PostgreSQL schema between two databases and generates SQL statements that can be run manually against the second database to make their schemas match.

  • I used to use pgdiff for this — https://github.com/joncrlsn/pgdiff

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

    WorkOS logo
  • migra

    Like diff but for PostgreSQL schemas

  • I've had a lot of success with: https://github.com/djrobstep/migra

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts