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 es un sistema de versionado de esquemas de base de datos y herramienta de migración para SQLAlchemy. Gestiona actualizaciones incrementales a las estructuras de base de datos utilizando scripts versionados que admiten tanto la actualización como la degradación para mantener la base de datos y el código sincronizados. El sistema utiliza un grafo acíclico dirigido para la gestión de migraciones, lo que permite un versionado no lineal, incluyendo ramificación y fusión a través de múltiples versiones raíz. Incluye una herramienta automatizada de comparación de esquemas que compara esquemas de bases de datos en vivo contra objetos de metadatos para generar programáticamente instrucciones de migración. La herramienta proporciona capacidades para la evolución transaccional de esquemas para asegurar actualizaciones atómicas y prevenir la corrupción parcial de la base de datos. La funcionalidad adicional incluye la traducción de directivas de migración a cadenas SQL sin procesar para auditoría y el mantenimiento del seguimiento de versiones basado en scripts a través de una tabla de base de datos dedicada.

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