|Project Name||Stars||Downloads||Repos Using This||Packages Using This||Most Recent Commit||Total Releases||Latest Release||Open Issues||License||Language|
|Prisma||31,846||442||3 hours ago||4,993||September 24, 2022||2,920||apache-2.0||TypeScript|
|Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB|
|Graphql Engine||29,837||1||5 hours ago||17||June 22, 2022||2,129||apache-2.0||TypeScript|
|Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.|
|Postgraphile||11,955||76||99||6 days ago||156||May 25, 2022||67||mit||TypeScript|
|Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database!|
|Dbal||9,081||47,946||3,933||5 hours ago||99||April 05, 2022||198||mit||PHP|
|Doctrine Database Abstraction Layer|
|Records||6,956||150||28||2 months ago||11||February 21, 2019||64||isc||Python|
|SQL for Humans™|
|Sqlboiler||5,817||97||12 hours ago||95||August 28, 2022||86||bsd-3-clause||Go|
|Generate a Go ORM tailored to your database schema.|
|Goose||3,954||65||99||4 days ago||46||August 29, 2022||57||other||Go|
|A database migration tool. Supports SQL migrations and Go functions.|
|Dbmate||3,432||1||7 days ago||27||March 25, 2022||16||mit||Go|
|:rocket: A lightweight, framework-agnostic database migration tool.|
|Xo||3,354||2||9||14 days ago||2||April 16, 2021||42||mit||Go|
|Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server|
|Scenic||3,182||114||11||a month ago||18||February 13, 2022||23||mit||Ruby|
|Versioned database views for Rails|
migra is a schema diff tool for PostgreSQL, written in Python. Use it in your python scripts, or from the command line like this:
$ migra postgresql:///a postgresql:///b alter table "public"."products" add column newcolumn text; alter table "public"."products" add constraint "x" CHECK ((price > (0)::numeric));
migra magically figures out all the statements required to get from A to B.
Most features of PostgreSQL are supported.
Migra supports PostgreSQL >= 9 only. Known issues exist with earlier versions. More recent versions are more comprehensively tested. Development resources are limited, and feature support rather than backwards compatibility is prioritised.
Documentation is at databaseci.com/docs/migra.
Schema migrations are without doubt the most cumbersome and annoying part of working with SQL databases. So much so that some people think that schemas themselves are bad!
But schemas are actually good. Enforcing data consistency and structure is a good thing. It’s the migration tooling that is bad, because it’s harder to use than it should be.
migra is an attempt to change that, and make migrations easy, safe, and reliable instead of something to dread.
Contributing is easy. Jump into the issues, find a feature or fix you'd like to work on, and get involved. Or create a new issue and suggest something completely different. If you're unsure about any aspect of the process, just ask.