Awesome GitHub RepositoriesDatabase Schema Scaffolding

Yii2 is a professional PHP web framework designed for developing high-performance, scalable enterprise web applications. It utilizes a Model-View-Controller architecture to separate data logic, user interfaces, and request handling, ensuring maintainability for large-scale projects. The framework includes a built-in PHP code generator that automates the creation of boilerplate controllers and models by scanning database schemas. It provides an Active Record object-relational mapping system where classes represent tables and instances represent rows to manage data persistence. Additional capa

This project is a Node.js client for PostgreSQL databases, providing a protocol parser to translate raw binary streams into JavaScript objects. It serves as a driver for executing queries, managing data, and integrating Node.js applications with PostgreSQL backends. The library includes a connection pool manager to reduce network overhead by caching reusable connections and a result streamer that uses cursors to retrieve large datasets incrementally. It also functions as an event listener for subscribing to asynchronous server-side notifications to trigger real-time application events. Broad

Sea-ORM is an asynchronous SQL object-relational mapper and database toolkit for mapping relational tables to strongly typed objects. It provides a relational database mapper for performing CRUD operations across MySQL, PostgreSQL, and SQLite, and includes a programmatic dynamic query builder for constructing complex SQL statements. The project distinguishes itself by providing a GraphQL schema generator that transforms database entities into typed schemas with built-in pagination and filters. It also features a dedicated database migration tool for defining and applying versioned schema chan

Epoxy is an Android library for building complex RecyclerView screens using a model-driven approach. It generates RecyclerView adapter models at compile time from annotated custom views, data binding layouts, or view holders, eliminating the manual boilerplate typically associated with view holders and adapters. The library provides a diffing engine that automatically compares model lists and applies minimal updates with animations for insertions, removals, and moves. The library distinguishes itself through its controller-based model building, where a controller class with a buildModels meth

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

Blog.Core 是一个生产就绪的后端样板，用于使用 ASP.NET Core 构建企业级 API 和微服务。它为分布式系统提供了基础架构，包括用于数据库优先（database-first）脚手架和实现多租户 API 框架的工具。 该项目的特色在于自动数据层生成，可直接从数据库模式生成实体模型和存储库层。它使用标准身份服务器协议实现了集中式身份管理系统，以处理跨多个客户端和项目的身份验证和授权。 该框架涵盖了广泛的企业级功能，包括通过事件总线进行的异步消息处理、分布式内存缓存以及读写数据库流量分离。它结合了具有部门数据限制的基于角色的访问控制，并通过 API 性能分析和活动审计提供系统可观测性。 该系统还包括对用于推送通知的双向服务器-客户端通信、全文搜索集成以及集中式服务配置的支持。

Flask-SQLAlchemy 是一个将 SQLAlchemy 关系数据库工具包与 Flask Web 框架集成的工具包。它通过将数据库表结构定义为 Python 类来实现关系数据建模，并管理 Web 应用程序中数据库记录的持久化和检索。 该项目将数据库会话生命周期绑定到活动的应用程序请求上下文，以确保自动连接清理。它为 Web 数据访问提供了专门的实用程序，包括查询结果分页，以及在请求的数据库记录缺失时自动触发 404 Not Found 响应的机制。 该扩展涵盖了广泛的数据库管理功能，包括声明式模型映射、模式反射和物理表结构的生成。它通过多绑定查询路由支持高级连接管理，并提供用于审计 SQL 查询性能和执行时间的观测工具。

This project is a command-line schema-to-code converter designed to transform diverse data specifications into type-safe Python data structures. It functions as a generator for Pydantic models, dataclasses, and typed dictionaries, enabling developers to maintain synchronization between evolving data contracts and application code. By parsing formats such as JSON Schema, OpenAPI, AsyncAPI, Protobuf, and Avro, the tool automates the creation of native classes that reflect the constraints and metadata defined in the source specifications. The generator distinguishes itself through a highly confi

This project is a code scaffolding tool and database-to-code mapper for Laravel. It functions as a CRUD generator and REST API generator that automates the creation of models, controllers, and administrative interfaces based on database schemas. The tool is distinguished by its template-driven approach, using customizable stub files that allow developers to override default blueprints to enforce specific architectural standards. It provides complete administrative dashboard boilerplates, including integrated authentication, themed UI layouts, and searchable data tables. The system covers a b

linq2db is a type-safe object-relational mapper that translates LINQ expressions into optimized SQL queries for multiple database providers. It functions as a database mapper that links classes to tables and includes a SQL query builder and a command-line schema tool for generating data classes from existing databases. The project provides high-performance bulk data processing for inserting and loading large volumes of records via batch or binary copy methods. It also supports advanced SQL operations, including window functions, common table expressions for recursive hierarchical querying, an

This tool is an automated backend code generator that creates administrative dashboards by inspecting existing relational database structures. It functions as a schema-driven scaffolding utility, parsing table definitions and foreign key constraints to produce functional server-side controllers and user interfaces for record management. The project distinguishes itself through static source code ejection, which outputs human-readable files that developers can manually modify or extend. By analyzing database metadata, it automatically maps relational data to intuitive selection components and