# Declarative Database Schema Migration Tools

> Search results for `declarative schema management that diffs and migrates databases` on awesome-repositories.com. 114 total matches; showing the first 50.

Explore on the web: https://awesome-repositories.com/q/declarative-schema-management-that-diffs-and-migrates-databases

**Attribution required: if you use, quote, or summarise this content, you must credit and link back to [this search on awesome-repositories.com](https://awesome-repositories.com/q/declarative-schema-management-that-diffs-and-migrates-databases).**

## Results

- [golang-migrate/migrate](https://awesome-repositories.com/repository/golang-migrate-migrate.md) (18,118 ⭐) — This project is a command-line utility designed to manage database schema versioning and automate incremental schema updates. It functions as a version control system for database structures, ensuring consistency across environments by tracking applied migrations in a dedicated metadata table and executing scripts in a sequential, reliable manner.

The tool distinguishes itself through a driver-based abstraction layer that supports a wide range of database engines, including various SQL and distributed cloud databases. It provides robust concurrency control through advisory locking, which prev
- [drizzle-team/drizzle-orm](https://awesome-repositories.com/repository/drizzle-team-drizzle-orm.md) (34,835 ⭐) — Drizzle ORM is a TypeScript-native database toolkit providing type-safe SQL query building, schema management, and automated migrations across PostgreSQL, MySQL, SQLite, and SingleStore.
- [dotnet/efcore](https://awesome-repositories.com/repository/dotnet-efcore.md) (14,587 ⭐) — Entity Framework Core is an object-relational mapper that enables developers to interact with database systems using strongly-typed code. It serves as a comprehensive data access framework, providing a unified interface for mapping application objects to relational and non-relational database schemas while managing the lifecycle of data operations through a central context.

The project distinguishes itself through a provider-based architecture that decouples core data access logic from specific database engines, allowing for consistent interaction across diverse storage systems. It features a
- [insforge/insforge](https://awesome-repositories.com/repository/insforge-insforge.md) (11,794 ⭐) — InsForge is a backend-as-a-service platform that provides an integrated suite of tools for managing relational databases, identity provision, object storage, and serverless compute. It functions as an open-source identity provider and a PostgreSQL database manager featuring integrated vector storage and row-level security.

The platform serves as an LLM orchestration gateway, offering a unified endpoint to route requests across various AI providers through an OpenAI-compatible interface. It enables AI-driven application generation and connects AI agents to backend resources using a standardize
- [doctrine/dbal](https://awesome-repositories.com/repository/doctrine-dbal.md) (9,699 ⭐) — This project is a SQL database abstraction layer that provides a consistent object-oriented interface for interacting with multiple relational database systems. It includes a driver wrapper to standardize connections and result sets, a fluent query builder for constructing portable SQL statements, and a type mapper for converting database-specific data types into native application types and vice versa.

The library enables programmatic schema management through a schema manager that can introspect database metadata, model structures as objects, and generate the SQL required to migrate between
- [awesome-selfhosted/awesome-selfhosted](https://awesome-repositories.com/repository/awesome-selfhosted-awesome-selfhosted.md) (299,516 ⭐) — This project is a community-curated directory of open-source software designed for deployment in private server environments and home labs. It serves as a comprehensive resource for discovering independent, self-hosted alternatives to mainstream cloud services, enabling users to maintain full data ownership and control over their digital infrastructure.

The directory is structured through a hierarchical taxonomy that organizes a vast collection of applications into logical categories, ranging from media management and data analytics to private communication and team productivity tools. It dis
- [avelino/awesome-go](https://awesome-repositories.com/repository/avelino-awesome-go.md) (175,576 ⭐) — This project serves as a comprehensive language ecosystem index, functioning as a centralized, community-curated directory for the Go programming language. It organizes a vast landscape of software components, libraries, and development tools into a structured, navigable hierarchy, enabling developers to efficiently discover resources tailored to specific functional domains.

The repository distinguishes itself through a decentralized contribution model, where community-driven updates ensure the index remains current with the rapidly evolving software landscape. Beyond simple resource listing,
- [stripe/pg-schema-diff](https://awesome-repositories.com/repository/stripe-pg-schema-diff.md) (859 ⭐) — Go library for diffing Postgres schemas and generating SQL migrations
- [ariga/atlas](https://awesome-repositories.com/repository/ariga-atlas.md) (8,096 ⭐) — Atlas is a SQL database schema management tool and database infrastructure as code framework. It provides a declarative database migration engine that computes the difference between a desired schema state and the current database state to automatically generate the necessary SQL for transitions.

The project distinguishes itself through a comprehensive suite of analysis and visualization tools, including a database schema linter that detects destructive changes and data loss risks. It also features a SQL schema visualization tool capable of generating entity-relationship diagrams from extract
- [bytebase/bytebase](https://awesome-repositories.com/repository/bytebase-bytebase.md) (14,151 ⭐) — Bytebase is a database DevSecOps platform and management console designed to orchestrate schema migrations, deployments, and security audits across multiple database engines. It serves as a SQL GitOps tool that synchronizes database states with configurations stored in Git repositories to manage infrastructure as code.

The platform distinguishes itself through a multi-database management console that provides a single interface for relational and NoSQL databases. It includes a security layer for role-based access control, database activity auditing, and column-level data masking to protect se
- [prisma/prisma](https://awesome-repositories.com/repository/prisma-prisma.md) (46,366 ⭐) — Prisma is a database toolkit that provides a unified access layer for interacting with relational and document databases. It centers on a declarative schema modeling approach, where developers define their data structures in a human-readable language. This schema serves as the single source of truth, from which the toolkit automatically generates type-safe database clients that provide compile-time validation and editor autocomplete for all data operations.

The project distinguishes itself through a high-performance, Rust-based query engine that handles query planning and connection pooling o
- [xethron/migrations-generator](https://awesome-repositories.com/repository/xethron-migrations-generator.md) (3,323 ⭐) — Laravel Migrations Generator: Automatically generate your migrations from an existing database schema.
- [spree/spree](https://awesome-repositories.com/repository/spree-spree.md) (15,230 ⭐) — This project is a modular e-commerce platform built on Ruby on Rails, designed to serve as a comprehensive engine for managing online retail operations. It provides the foundational infrastructure to handle complex product catalogs, customer order lifecycles, and global payment processing within a unified system.

The platform distinguishes itself through a headless, API-first architecture that decouples backend commerce logic from custom frontend storefronts. It supports multi-tenant environments, allowing for the management of multiple independent retail storefronts or marketplaces from a si
- [larapulse/migrator](https://awesome-repositories.com/repository/larapulse-migrator.md) (25 ⭐) — MySQL database migrator
- [evershopcommerce/evershop](https://awesome-repositories.com/repository/evershopcommerce-evershop.md) (10,141 ⭐) — EverShop is a TypeScript-first, modular e-commerce platform built with GraphQL and React. It provides a full-featured online store system for managing products, orders, customers, and site content through a React-based administrative interface, with a GraphQL API layer that serves both the admin panel and storefront.

The platform is designed around a module-based extension architecture, where core functionality is split into independent modules that can be added, removed, or overridden without modifying the core codebase. Storefront appearance and behavior are controlled through a theme syste
- [adlio/schema](https://awesome-repositories.com/repository/adlio-schema.md) (43 ⭐) — Embedded schema migration package for Go
- [holistics/dbml](https://awesome-repositories.com/repository/holistics-dbml.md) (3,520 ⭐) — DBML is a domain-specific language and schema definition language used for documenting database architecture and design. It provides a human-readable text format for defining database tables, columns, and relationships in a standardized way.

The project functions as a relational schema parser and SQL schema generator. It transforms declarative design specifications into an abstract syntax tree for programmatic manipulation and converts these definitions into executable SQL statements across various database dialects.

The system covers relational data modeling, database schema design, and arc
- [lopezator/migrator](https://awesome-repositories.com/repository/lopezator-migrator.md) (178 ⭐) — Dead simple Go database migration library.
- [prismagraphql/prisma](https://awesome-repositories.com/repository/prismagraphql-prisma.md) (16,393 ⭐) — Prisma is a type-safe database object-relational mapper that uses a declarative schema to map data models to relational and document databases. It provides a unified toolkit for data access, combining a database driver with tools for schema management and record manipulation.

The project features a multi-database driver that standardizes interactions across PostgreSQL, MySQL, and MongoDB. It includes a system for tracking and applying structural schema migrations across different environments and a graphical user interface for browsing and editing database records.

The system ensures data in
- [agno-agi/agno](https://awesome-repositories.com/repository/agno-agi-agno.md) (40,717 ⭐) — Agno is an agent operating system designed to manage the lifecycle, tool execution, and persistent state of autonomous agents across distributed infrastructure. It provides a unified runtime environment that wraps diverse agent frameworks into a consistent, interoperable protocol, allowing developers to build and deploy complex multi-agent systems that coordinate tasks and delegate sub-processes.

The platform distinguishes itself through a robust governance and orchestration layer that includes human-in-the-loop approval gates, role-based access control, and a centralized API gateway. It feat
- [cakephp/migrations](https://awesome-repositories.com/repository/cakephp-migrations.md) (138 ⭐) — This is a Database Migrations system for CakePHP.
- [mouredev/hello-sql](https://awesome-repositories.com/repository/mouredev-hello-sql.md) (8,826 ⭐) — hello-sql is a collection of educational resources and practical guides designed for mastering relational database design, SQL query writing, and schema mapping. It provides a set of lessons and exercises for practicing the creation and manipulation of data within relational databases.

The project includes a database schema workbook for designing tables and mapping relationships, alongside a dedicated SQL query guide for writing selection, filtering, and aggregation statements. These resources are delivered through a relational database tutorial and a broader SQL learning resource.

The mater
- [cockroachdb/cockroach](https://awesome-repositories.com/repository/cockroachdb-cockroach.md) (32,207 ⭐) — Cockroach is a distributed SQL database designed to scale horizontally across multiple nodes while maintaining strict ACID compliance and global data consistency. It functions as a relational database engine that automatically partitions data into ranges, rebalancing them across a cluster to accommodate growing storage and throughput requirements. By utilizing a distributed consensus protocol, the system ensures that all nodes agree on the order of operations, providing fault tolerance and continuous availability even in the event of hardware failures.

The system distinguishes itself through
- [rubenv/sql-migrate](https://awesome-repositories.com/repository/rubenv-sql-migrate.md) (3,411 ⭐) — SQL schema migration tool for Go.
- [vladfaust/migrate.cr](https://awesome-repositories.com/repository/vladfaust-migrate-cr.md) (33 ⭐) — A database migration solution 🚜
- [activepieces/activepieces](https://awesome-repositories.com/repository/activepieces-activepieces.md) (20,887 ⭐) — Activepieces is an open-source, self-hosted workflow automation platform designed to connect third-party applications through modular triggers and actions. It provides a low-code integration framework that allows users to build, manage, and execute complex business logic sequences within isolated, sandboxed environments.

The platform distinguishes itself through its focus on embeddability and enterprise-grade security. It features an embedded automation builder that can be integrated into external applications via iframes, supported by comprehensive identity and access management tools such a
- [stephencelis/sqlite.swift](https://awesome-repositories.com/repository/stephencelis-sqlite-swift.md) (10,167 ⭐) — SQLite.swift is a type-safe Swift wrapper and object-relational mapping layer that provides a bridge for interacting with SQLite databases. It functions as a database driver that allows for embedded database management and local data persistence within Swift applications.

The project distinguishes itself through a type-safe expression builder that verifies SQL statement syntax and intent at compile time. It includes specialized support for high-performance text matching via full-text search integration and provides mechanisms for securing sensitive data through database encryption.

The libra
- [ajv-validator/ajv](https://awesome-repositories.com/repository/ajv-validator-ajv.md) (14,733 ⭐) — Ajv is a high-performance data validation framework that compiles JSON schemas into optimized, standalone JavaScript functions. By transforming declarative schema definitions into executable code, it eliminates runtime interpretation overhead and provides a secure, efficient way to enforce data integrity across both browser and server environments.

The library distinguishes itself through its focus on performance and type safety. It employs advanced compilation techniques, including abstract syntax tree optimization and function caching, to ensure rapid validation. Beyond standard checks, it
- [wasp-lang/wasp](https://awesome-repositories.com/repository/wasp-lang-wasp.md) (18,146 ⭐) — Wasp is a declarative full-stack web framework that enables developers to build and deploy applications by defining their architecture in a centralized configuration. By using a high-level specification, the framework automates the orchestration of frontend, backend, and database components, ensuring that infrastructure concerns like routing, authentication, and data modeling are handled consistently across the entire stack.

The framework distinguishes itself through its compiler-driven approach, which translates declarative configurations into cohesive, production-ready codebases. It provide
- [salsita/node-pg-migrate](https://awesome-repositories.com/repository/salsita-node-pg-migrate.md) (1,467 ⭐) — Node.js database migration management for PostgreSQL
- [vendurehq/vendure](https://awesome-repositories.com/repository/vendurehq-vendure.md) (7,924 ⭐) — Vendure is a Node.js e-commerce engine and headless commerce framework built with NestJS and TypeScript. It serves as a multi-channel commerce platform that manages product catalogs, orders, and customers via a strongly typed GraphQL API.

The platform is distinguished by its highly extensible architecture, featuring a customizable administrative dashboard where developers can inject custom React components and entity views. It supports multi-channel commerce, allowing the isolation of products, currencies, and regional catalogs from a single unified backend.

The engine covers a broad range o
- [ruckus/ruckusing-migrations](https://awesome-repositories.com/repository/ruckus-ruckusing-migrations.md) (502 ⭐) — Database migrations for PHP ala ActiveRecord Migrations with support for MySQL, Postgres, SQLite
- [dandavison/delta](https://awesome-repositories.com/repository/dandavison-delta.md) (31,136 ⭐) — Delta is a command-line pager that enhances the readability of terminal output by applying syntax highlighting and structured formatting to text streams. It functions as a specialized interface for version control systems, transforming standard output into color-coded, human-readable views.

The tool distinguishes itself through its ability to render side-by-side diff comparisons and visualize merge conflicts with clear, semantic highlighting. It dynamically calculates column widths and text alignment to fit complex file comparisons within the constraints of a terminal window, while allowing u
- [miguelgrinberg/flask-migrate](https://awesome-repositories.com/repository/miguelgrinberg-flask-migrate.md) (2,408 ⭐) — SQLAlchemy database migrations for Flask applications using Alembic
- [prestodb/presto](https://awesome-repositories.com/repository/prestodb-presto.md) (16,711 ⭐) — Presto is a distributed SQL query engine designed for high-performance analytical processing across heterogeneous data sources. It functions as a data federation platform and massively parallel processing engine, allowing users to execute interactive queries against diverse storage systems without requiring data migration. By mapping remote metadata and structures to a unified relational namespace, it enables seamless cross-platform analysis through a standard SQL interface.

The engine distinguishes itself through a pluggable connector architecture and a shared-nothing distributed processing
- [go-xorm/xorm](https://awesome-repositories.com/repository/go-xorm-xorm.md) (6,628 ⭐) — xorm is a relational mapper and object-relational mapping tool for Go. It translates Go structures into SQL queries and maps database rows back into native objects, providing a multi-dialect database driver that supports MySQL, PostgreSQL, SQLite, Oracle, SQL Server, and TiDB.

The project features a read-write splitting manager that routes modification requests to a primary database and read requests to replicas. It includes a database schema synchronizer to automatically align table structures and indexes with application data models, as well as a fluent SQL query builder for constructing co
- [freshrss/freshrss](https://awesome-repositories.com/repository/freshrss-freshrss.md) (14,059 ⭐) — FreshRSS is an open-source, self-hosted web feed aggregator designed to collect, organize, and display content from multiple websites in a single, centralized interface. It functions as a comprehensive reader for standard syndication formats, allowing users to track updates from various sources while maintaining full control over their data and privacy. The platform supports multi-user environments, enabling individual account management and personalized reading experiences.

The application distinguishes itself through its robust synchronization and extensibility capabilities. It provides a s
- [seppevs/migrate-mongo](https://awesome-repositories.com/repository/seppevs-migrate-mongo.md) (1,027 ⭐) — A database migration tool for MongoDB in Node
- [analysis-tools-dev/static-analysis](https://awesome-repositories.com/repository/analysis-tools-dev-static-analysis.md) (14,389 ⭐) — This project is a comprehensive, curated directory of static analysis, linting, and security scanning utilities. It serves as a central resource for developers to discover, compare, and select tools based on specific programming languages, licensing models, and integration requirements.

The directory distinguishes itself by providing deep metadata for each listed utility, including community-driven popularity rankings, maintenance status, and deployment methods. By aggregating these tools into a single searchable index, it enables teams to identify solutions for enforcing coding standards, ma
- [schema-inspector/schema-inspector](https://awesome-repositories.com/repository/schema-inspector-schema-inspector.md) (503 ⭐) — Schema-Inspector is a simple JavaScript object sanitization and validation module.
- [hhyo/archery](https://awesome-repositories.com/repository/hhyo-archery.md) (6,929 ⭐) — Archery is a suite of specialized utilities for database schema migration, SQL audit and review, mapping parsing, and performance analysis. It functions as a centralized platform for reviewing, executing, and auditing SQL queries across multiple database environments through controlled workflows.

The platform includes a mapping parser that converts XML files into readable SQL statements to simplify the review of application-generated queries. It also provides tools for parsing slow query logs and analyzing execution patterns to optimize database indexes and speeds.

The system covers broad da
- [prisma/migrate](https://awesome-repositories.com/repository/prisma-migrate.md) (761 ⭐) — Issues for Prisma Migrate are now tracked at prisma/prisma. This repo was used to track issues for Prisma Migrate Experimental and is now deprecated.
- [aimeos/upscheme](https://awesome-repositories.com/repository/aimeos-upscheme.md) (2,601 ⭐)
- [judasn/intellij-idea-tutorial](https://awesome-repositories.com/repository/judasn-intellij-idea-tutorial.md) (22,113 ⭐) — This project is an instructional user guide and software development workflow tutorial designed to help users master a professional integrated development environment. It provides educational content and step-by-step instructions for optimizing coding productivity and navigating development tools across various language versions.

The material specifically covers the configuration of Java-centric environments, including setting up the operating system, managing dependencies, and tuning memory settings. It offers detailed guidance on utilizing professional tools to streamline development proces
- [ent/ent](https://awesome-repositories.com/repository/ent-ent.md) (17,110 ⭐) — Ent is a statically typed entity framework for Go that models database structures as a graph of nodes and edges. It functions as a code generation engine that transforms schema definitions into type-safe database clients, query builders, and migration scripts. By representing data as interconnected entities, the framework enables intuitive traversal of complex relationships and ensures that database interactions remain consistent with the application model at compile time.

The framework distinguishes itself through its graph-based approach to data modeling and its reliance on compile-time cod
- [windofshadow/that](https://awesome-repositories.com/repository/windofshadow-that.md) (121 ⭐) — This repository contains the Pytorch implementation of the THAT methods in the following paper:
- [mikro-orm/mikro-orm](https://awesome-repositories.com/repository/mikro-orm-mikro-orm.md) (9,085 ⭐) — Mikro-ORM is a TypeScript-based object-relational mapping system that provides a unified persistence layer for Node.js applications. It translates TypeScript entities into relational or document-based database schemas, supporting a variety of engines including PostgreSQL, MySQL, MariaDB, MS SQL Server, SQLite, and MongoDB.

The project implements the data mapper pattern to decouple in-memory domain models from the database persistence layer. It utilizes a unit of work pattern to track entity changes in memory and commit them in a single coordinated database transaction.

The library covers com
- [anomalyco/opentui](https://awesome-repositories.com/repository/anomalyco-opentui.md) (12,131 ⭐) — Opentui is a terminal user interface framework for building interactive command line applications. It provides a component-based system featuring a flexbox layout engine, a virtual node component tree, and a low-level 2D cell array renderer.

The project is distinguished by a sophisticated keyboard binding engine that maps complex multi-stroke sequences and chords to named commands using prioritized, reactive layers. It also implements a plugin architecture that allows external modules to inject custom UI components into designated layout slots and extend input logic at runtime.

Its capabilit
- [wemake-services/django-test-migrations](https://awesome-repositories.com/repository/wemake-services-django-test-migrations.md) (571 ⭐) — Test django schema and data migrations, including migrations' order and best practices.
- [openbeer/schema.sql](https://awesome-repositories.com/repository/openbeer-schema-sql.md) (9 ⭐) — beer.db database schema (tables, views, etc.) scripts (in SQL) and documentation