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 هو نظام إصدار مخطط قاعدة البيانات وأداة ترحيل لـ SQLAlchemy. يدير التحديثات التزايدية لهياكل قاعدة البيانات باستخدام نصوص إصدار تدعم كلاً من الترقية والرجوع للحفاظ على تزامن قاعدة البيانات والكود. يستخدم النظام رسماً بيانياً موجهاً غير دوري (DAG) لإدارة الترحيل، مما يسمح بإصدار غير خطي، بما في ذلك التفرع والدمج عبر إصدارات جذرية متعددة. يتضمن أداة مقارنة مخطط مؤتمتة تقارن مخططات قاعدة البيانات الحية مقابل كائنات البيانات الوصفية لتوليد تعليمات الترحيل برمجياً. توفر الأداة قدرات لتطور المخطط القائم على المعاملات لضمان تحديثات ذرية ومنع تلف قاعدة البيانات الجزئي. تتضمن الوظائف الإضافية ترجمة توجيهات الترحيل إلى سلاسل SQL خام للتدقيق والحفاظ على تتبع الإصدار القائم على النصوص عبر جدول قاعدة بيانات مخصص.

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