Awesome GitHub RepositoriesSchema State Diffing

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

jOOQ is a type-safe SQL query builder for Java that generates code from live database schemas, enabling compile-time validation of SQL syntax and data types. Its core identity is built around a fluent DSL that mirrors SQL structure, a code generator that maps tables, views, and routines to Java objects, and a multi-dialect engine that translates the same DSL into vendor-specific SQL for over 30 databases. The project also includes a SQL parser and transformer for refactoring or dialect conversion, reactive stream integration for non-blocking query execution, and a JDBC proxy diagnostics tool f

tbls is a Go-based command line utility used for documenting, analyzing, and linting relational database schemas. It functions as a documentation tool that generates structured reports and entity-relationship diagrams in Markdown, JSON, or Excel formats, as well as a schema diff tool for identifying discrepancies between a live database and its documentation. The project allows for schema augmentation and the definition of virtual relationships through external configuration files, enabling metadata overrides and table connections without requiring database migrations or native constraints. I

Alembic ist ein Datenbankschema-Versionierungssystem und Migrationstool für SQLAlchemy. Es verwaltet inkrementelle Updates von Datenbankstrukturen mithilfe versionierter Skripte, die sowohl Upgrades als auch Downgrades unterstützen, um Datenbank und Code synchron zu halten. Das System nutzt einen gerichteten azyklischen Graphen für das Migrationsmanagement, was nicht-lineare Versionierung ermöglicht, einschließlich Branching und Merging über mehrere Root-Versionen hinweg. Es enthält ein automatisiertes Schema-Diffing-Tool, das Live-Datenbankschemata mit Metadatenobjekten vergleicht, um programmatisch Migrationsanweisungen zu generieren. Das Tool bietet Funktionen für transaktionale Schema-Evolution, um atomare Updates sicherzustellen und partielle Datenbankkorruption zu verhindern. Zusätzliche Funktionalität umfasst die Übersetzung von Migrationsdirektiven in rohe SQL-Strings für Audits und die Aufrechterhaltung einer skriptbasierten Versionsverfolgung über eine dedizierte Datenbanktabelle.

apollo-ios is a GraphQL client library for iOS and Apple platforms that enables type-safe network communication. It transforms GraphQL operations into generated Swift models, ensuring that network responses are validated at compile time to eliminate manual mapping. The library features a normalized cache manager that stores entities in a flat structure to maintain data consistency across different application views. It also optimizes network performance using hash-based persisted queries to reduce payload sizes and supports real-time data streaming via WebSockets or HTTP subscriptions. The p

cr-sqlite is a multi-master database replication system that uses conflict-free replicated data types to ensure eventual consistency across distributed nodes. It provides the core capabilities for offline-first data synchronization, allowing multiple database instances to merge concurrent updates and reach a consistent state. The project distinguishes itself through a combination of CRDT-based data replication and a WASM-based database engine, enabling full SQL execution and state persistence within web browsers. It supports peer-to-peer replication and cross-tab synchronization, utilizing ca