Awesome GitHub RepositoriesDatabase Schema Introspection Tools

PostgREST is a standalone web server that automatically transforms a PostgreSQL database into a RESTful API. It serves as an API gateway that translates HTTP requests into SQL queries, mapping the database schema directly to endpoints without the need for manual route definitions. The system utilizes a JWT authentication layer to validate user identities and map incoming web requests to specific database roles. This allows the server to delegate authorization and permission enforcement to the internal PostgreSQL role system. It includes a generator for OpenAPI specifications to provide stand

PostgREST is a standalone server process that automatically transforms a relational database schema into a fully functional RESTful API. By querying system catalogs at startup, it maps tables, views, and stored procedures into standardized web endpoints, allowing developers to build backend services by focusing exclusively on database design. The service functions as a declarative engine that translates HTTP requests and query parameters directly into native SQL operations. It maintains stateless request processing and integrates connection pooling to manage high-frequency interactions effici

🔮 Graphile's Crystal Monorepo; home to Grafast, PostGraphile, pg-introspection, pg-sql2 and much more!

PostGraphile is an automated tool that converts a PostgreSQL database schema into a fully functional GraphQL API. It serves as a GraphQL execution engine and schema orchestrator, utilizing database schema introspection to retrieve strongly typed metadata directly from PostgreSQL. The project features a modular system for composing and standardizing GraphQL schemas through plugins, which manage naming conventions and connections. It includes a PostgreSQL query builder that constructs dynamic, SQL-injection-proof queries using tagged template literals. The system employs a declarative query pl

Encore is a distributed systems framework designed to unify backend development, infrastructure provisioning, and observability. It functions as an infrastructure-as-code platform that allows developers to define cloud resources, databases, and messaging topics directly within their application code. By analyzing these declarations at compile-time, the system automatically manages the deployment of cloud resources and security policies, ensuring parity between local development and production environments. The platform distinguishes itself through its integrated development experience, which

django-extensions is a specialized toolset for the Django framework providing utilities for database visualization, application debugging, development environment management, and custom management command execution. It functions as a collection of tools designed to automate development tasks and inspect the internal state of an application. The project provides a database visualization tool for generating diagrams of data models and comparing schemas to map complex relationships. It also includes a debugging utility to intercept email traffic and audit user permissions to troubleshoot applica

xorm is a relational mapper and object-relational mapping tool for Go. It translates Go structures into SQL queries and maps database rows back into native objects, providing a multi-dialect database driver that supports MySQL, PostgreSQL, SQLite, Oracle, SQL Server, and TiDB. The project features a read-write splitting manager that routes modification requests to a primary database and read requests to replicas. It includes a database schema synchronizer to automatically align table structures and indexes with application data models, as well as a fluent SQL query builder for constructing co

GraphQL Editor is a collaborative workspace platform for designing, editing, and managing GraphQL schemas. It provides an interactive graph-based visual editor that lets teams create and explore schemas without writing code, alongside a full-featured Monaco text IDE with real-time syntax validation. The platform supports AI-powered schema generation from natural language prompts, federated schema composition that visualizes type merging across subgraphs, and AST-level schema comparison that highlights structural differences between versions. The platform distinguishes itself through its bidir

GraphQL.NET 是一个用于在 C# 应用程序中构建和执行 GraphQL API 的服务端框架。它提供了一套全面的工具包，用于模式构建、分布式数据图的联合引擎，以及用于管理实时数据流的订阅处理器。 该项目的独特之处在于其灵活的模式构建器，支持程序化的代码优先定义和使用标准模式定义语言的声明式模式优先方法。它包括一个专门的联合引擎，用于将数据图拆分为子图并将其组合成统一的网关，以及一个专门设计用于通过批处理和缓存解决 N+1 查询问题的数据加载器实现。 该框架涵盖了广泛的操作功能，包括用于服务生命周期管理的依赖注入集成、用于字段解析拦截的中间件流水线，以及针对值类型优化以减少内存分配的执行流水线。它还提供用于查询复杂度分析、文档缓存和基于角色的访问控制的工具，以保护 API 端点。 对提前（AOT）模式编译的支持允许该框架在禁止动态代码生成的环境中执行。

GraphQL Platform is a comprehensive GraphQL ecosystem for .NET that provides a spec-compliant server framework for building APIs and gateways, along with a typed C# client for consuming GraphQL services. At its core, it translates C# classes and methods into a GraphQL schema using code-first or fluent descriptor approaches, enabling developers to define their API structure directly from their existing .NET code. The platform distinguishes itself through several integrated capabilities that address common GraphQL production concerns. It includes a DataLoader batching and caching engine that gr

SurveyKing 是一个自托管的问卷调查平台，专为在私有基础设施上创建、部署和分析在线问卷及数据收集表单而设计。它集成了用于构建自定义审批流程的业务工作流自动化工具，以及用于管理题库和颁发数字证书的在线考试系统。该平台还包含一个心理测评工具，用于管理带有自定义维度评分的性格测试和量表。 该系统利用大语言模型问卷生成器，将自然语言提示转换为结构化的专业问卷和考试题目。它具有可视化的拖拽式审批工作流设计器，支持条件分支和多级规则。 该平台涵盖问卷设计功能，包括投票管理和专业研究工具，以及用于协调 360 度评估的绩效管理。其他功能包括带有可视化报告的实时数据分析、用于个性化打印的模板化文档渲染，以及用于管理系统权限的基于角色的访问控制。

WPGraphQL is a GraphQL interface for WordPress that transforms a WordPress installation into a headless content source. It functions as a GraphQL schema provider that maps database structures and relational data into a standardized schema, exposing posts, pages, and custom data types through a single flexible endpoint. The project includes an integrated API query builder and schema explorer, allowing for the visual composition of queries and real-time validation of responses. It provides a system for extending the schema with custom fields and relationships to expose specific business data.

CRUD is an administrative interface framework and code generation package designed to build customized control panels, data management dashboards, and record-handling workflows within PHP and Model controllers. The architecture combines server-side template rendering, database relationship introspection, session persistence, and extensible field type registries to assemble backend interfaces. It provides full data lifecycle management, supporting searchable and paginated data tables, creation and editing forms, bulk record operations, hierarchical entry reordering, and data export capabilities

Flowchart Fun is a text-based diagram generator and interactive visual canvas editor that automatically transforms plain text input and natural language prompts into structured flowcharts and diagrams without requiring manual node placement. The application combines automated layout algorithms and structural templates with a web canvas interface for organizing layouts, applying custom shapes, borders, colors, and text sizes to diagram nodes and edges. The platform includes multi-format export pipelines that convert finished charts directly into vector graphics, raster images, and document dat

Motor-admin 是一个无代码管理平台，旨在管理关系数据库记录并构建内部界面。它作为一个图形化管理工具，自动发现数据库模式以生成功能面板，允许用户在无需手动编码的情况下执行记录操作并构建可视化仪表板。 该平台通过其声明式配置系统脱颖而出，该系统将仪表板布局和资源设置序列化为可移植的数据结构。这使得跨开发、测试和生产环境的管理环境能够保持一致的同步。此外，它集成了一个事件驱动引擎，可直接从界面操作触发自定义业务逻辑和外部 API 调用，并提供包括基于 SAML 的单点登录和精细的基于角色的访问控制在内的企业级安全功能。 除了核心管理外，该平台还提供了一套用于数据可视化和操作监督的综合套件。它支持通过动态查询执行创建自定义报告和性能指标，同时为配置数据库记录的显示、过滤和排序方式提供了灵活的工具。

Data API builder is a service that automatically generates REST and GraphQL endpoints directly from database schemas and stored procedures. By interpreting database metadata, it provides immediate programmatic access to information without requiring the development of custom backend routes or manual query logic. The engine distinguishes itself through a metadata-driven translation layer that maps incoming HTTP requests to native database queries while enforcing granular, role-based access control and row-level security policies. It includes a dedicated bridge for AI agents, allowing these sys

This project is an interactive educational platform and comprehensive curriculum designed to teach developers how to build, query, and integrate GraphQL APIs into full-stack applications. It provides a structured learning environment for mastering core concepts such as schema design, query execution, and the implementation of data-driven interfaces. The platform distinguishes itself by focusing on the practical application of real-time data synchronization and backend architecture. It guides users through the process of connecting frontend frameworks to relational databases, implementing role