Awesome GitHub RepositoriesDatabase Schema Definitions

ToolJet is a low-code development platform designed for building and deploying internal business applications. It provides a visual interface where users can drag and drop components to design layouts, connect to various data sources, and execute custom logic. The platform is built on a containerized architecture, ensuring that applications remain portable and consistent across different cloud and server environments. The platform distinguishes itself through integrated artificial intelligence capabilities that assist in the generation of user interfaces, database schemas, and data queries fr

SpacetimeDB is a stateful, real-time database platform that executes application logic directly within the database engine. By unifying data storage and business logic, it allows developers to build applications where state transitions are processed through atomic, server-side functions. The platform maintains persistent connections to stream incremental updates to clients, ensuring that local caches remain synchronized with the server state at all times. The platform distinguishes itself by generating type-safe client interfaces directly from server-side schema definitions, ensuring consiste

Dexie.js is a wrapper library for IndexedDB that provides a simplified interface for managing and querying structured data within the browser. It functions as a browser database manager used to maintain persistent application state and store binary blobs and records. The project serves as an offline-first data store that synchronizes browser data with remote servers to maintain consistency across sessions. It also acts as a reactive database store by monitoring data changes in real time to trigger automatic user interface updates, and functions as a client-side search engine for indexing and

This project is a type-safe database toolkit and object-relational mapper designed to enforce structural consistency between database schemas and application code. By leveraging compile-time validation, it ensures that SQL queries and data structures remain synchronized, preventing common errors before the application executes. It provides a comprehensive framework for relational data modeling, allowing developers to define table associations and map database results directly into strongly-typed language objects. The library distinguishes itself through its focus on compile-time safety and au

SQLDelight is a Kotlin database library that validates SQL schema, statements, and migrations at compile time, generating type-safe Kotlin query functions from labeled SQL files. It treats SQL as the source of truth for database definitions, catching schema errors during the build process before they reach production. The library supports multiple database dialects including SQLite, MySQL, PostgreSQL, HSQL, and H2, and generates platform-specific code for Android, iOS, JVM, and JavaScript targets. It provides a platform-specific driver abstraction that handles database connectivity difference

Ecto is an Elixir database toolkit that maps database rows to Elixir structs and validates data changes through changesets before persistence. It provides a language-integrated query syntax for composing database queries, building them incrementally and securely with compile-time expansion into safe SQL. The toolkit connects to multiple database backends including PostgreSQL, MySQL, MSSQL, SQLite3, ClickHouse, and ETS through a pluggable adapter interface. It supports eager and lazy preloading of associated records to eliminate N+1 query problems, and can store nested data structures as embed

ihp is a type-safe web framework and full-stack application orchestrator designed for PostgreSQL. It functions as a server-side rendering framework and a type-safe ORM that automatically generates record types from SQL schemas to ensure compile-time query validation. The platform distinguishes itself by verifying routing, database queries, and templates at compile time to prevent runtime crashes. It implements real-time web interfaces using WebSockets for instant data synchronization and employs server-driven hypermedia for partial DOM patching. The framework covers a broad range of integrat

Standalone Migrations ist ein Ruby-basiertes Dienstprogramm, das Datenbank-Schema-Management und Migrationsfunktionen außerhalb eines vollständigen Web-Frameworks bietet. Es ermöglicht Entwicklern, strukturelle Änderungen an relationalen Datenbanken unter Verwendung von Standard-Migrationsskripten in benutzerdefinierten oder Nicht-Framework-Umgebungen zu verfolgen, zu versionieren und anzuwenden. Das Tool zeichnet sich durch Multi-Datenbank-Isolation aus, was die Verwaltung unabhängiger Datenspeicher innerhalb eines einzigen Projekts durch separate Konfigurationssets und Migrationspfade ermöglicht. Es unterstützt dynamische, umgebungsbewusste Konfiguration, was es erlaubt, Verbindungseinstellungen zur Laufzeit anzupassen, und bietet ein Hook-System zur Ausführung benutzerdefinierter Logik während des Migrationslebenszyklus. Über die Kern-Migrationsaufgaben hinaus enthält das Projekt Dienstprogramme für die gezielte Ausführung spezifischer Dateien, Fremd- und Primärschlüsselkonfiguration sowie die Serialisierung von Datenbankstrukturen in rohe SQL-Dateien. Es ist für die Integration in Deployment-Pipelines für automatisierte Schema-Updates konzipiert und kann auf Legacy-Datenbanken angewendet werden, um sie unter moderne Versionskontroll-Workflows zu bringen.