Awesome GitHub RepositoriesDatabase Schema Visualizers

这是一个由社区策划的开源软件目录，专为在私有服务器环境和家庭实验室中部署而设计。它作为发现主流云服务独立自托管替代方案的综合资源，使用户能够保持对数字基础设施的完全数据所有权和控制权。 该目录通过层级分类法构建，将庞大的应用程序集合组织成逻辑类别，范围从媒体管理和数据分析到私有通信和团队生产力工具。它通过协作同行评审流程脱颖而出，社区成员验证每个提交的质量和相关性，以确保目录保持准确和可靠。 该项目涵盖了广泛的能力领域，包括基础设施自动化、基于容器的服务部署和声明式配置管理。这些工具协助用户维护可复现的服务器环境，并管理私有硬件上的复杂服务依赖。 该目录作为版本控制仓库进行维护，确保所有更新和社区驱动的变更都是可追踪且透明的。

Prisma is a database toolkit that provides a unified access layer for interacting with relational and document databases. It centers on a declarative schema modeling approach, where developers define their data structures in a human-readable language. This schema serves as the single source of truth, from which the toolkit automatically generates type-safe database clients that provide compile-time validation and editor autocomplete for all data operations. The project distinguishes itself through a high-performance, Rust-based query engine that handles query planning and connection pooling o

Chat2DB is an AI-powered SQL client and multi-database GUI manager designed for managing various relational and NoSQL database systems. It serves as a visual database management tool and a natural language to SQL interface, allowing users to convert plain text descriptions into executable and optimized queries. The platform distinguishes itself through automated business intelligence capabilities, which include the generation of real-time data visualization dashboards and AI-driven data analysis from spreadsheets. To ensure data privacy, it supports secure local AI deployment, enabling large

RedisDesktopManager is a graphical user interface client and database manager for Redis. It serves as a NoSQL database explorer that allows users to visualize, edit, and manage keys and values within a Redis environment without relying on command-line tools. The application focuses on NoSQL data exploration and cache administration, providing a visual way to browse and search through key-value pairs. It includes capabilities for database schema visualization, rendering complex data types such as hashes, lists, and sets in a readable format.

Beekeeper Studio is a cross-platform desktop application designed for database management and SQL development. It provides a unified graphical interface to connect to, query, and modify data across a wide range of relational and NoSQL database systems. The application functions as a comprehensive workspace, integrating tools for schema design, record editing, and data visualization. The project distinguishes itself through a focus on secure, flexible connectivity and AI-assisted workflows. It supports advanced authentication methods, including enterprise single sign-on, multi-factor authentic

ChartDB is a database schema visualizer and entity-relationship diagramming platform designed to help developers understand, design, and document complex data architectures. It functions as a visual workspace where users can create and modify database schemas, define table attributes, and map foreign key relationships. By parsing database metadata or SQL scripts, the tool generates interactive diagrams that provide a clear overview of structural interdependencies and data associations. The platform distinguishes itself through its focus on automated documentation and schema synchronization. I

Ent is a statically typed entity framework for Go that models database structures as a graph of nodes and edges. It functions as a code generation engine that transforms schema definitions into type-safe database clients, query builders, and migration scripts. By representing data as interconnected entities, the framework enables intuitive traversal of complex relationships and ensures that database interactions remain consistent with the application model at compile time. The framework distinguishes itself through its graph-based approach to data modeling and its reliance on compile-time cod

Showdoc is a technical documentation platform and knowledge management system designed to centralize project specifications, internal manuals, and technical guides. Built as a PHP web application, it provides a collaborative environment for teams to organize and share information across software development organizations. The platform distinguishes itself through its ability to automate documentation workflows by parsing source code comments and synchronizing technical records with the current state of a codebase. It also features specialized tools for managing RESTful API documentation and g

This project is an AI-powered IDE extension and LLM coding assistant that provides a conversational interface for generating, refactoring, and debugging code. It functions as an AI agent framework and a Model Context Protocol client, connecting AI models to external data sources and tools to automate complex development tasks. The system is distinguished by its use of autonomous AI agents capable of multi-step task execution, including the ability to read files, modify code, and run terminal commands iteratively. It supports recursive agent orchestration through subagent delegation and employ

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

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

Studio 是一个容器化 SQL 数据库管理工具，提供了一个基于浏览器的图形界面，用于执行查询和管理各种 SQL 数据库。它由一个专门的查询编辑器和专为 Web 数据库管理设计的图形管理界面组成。 该项目具有一个高性能 SQL 查询编辑器，带有自动补全和函数提示，可同时运行多个数据库命令。它包括一个用于创建和修改表列的视觉模式编辑器，以及一个在提交到源之前暂存和预览更改的记录编辑器。 该平台涵盖数据库连接和配置文件同步、多方言 SQL 集成，以及用于向菜单、选项卡和侧边栏添加自定义逻辑的 UI 扩展框架。它利用桌面包装器来桥接在标准 Web 浏览器环境中受限的数据库驱动程序。 该应用程序打包为 Docker 镜像，以确保在不同托管平台上的部署一致性。

AliSQL is a fork of MySQL by Alibaba that extends the relational database management system with enhancements for high performance, scalability, and enterprise-grade availability. It retains the core MySQL identity as a SQL-based database for storing, organizing, and retrieving structured data, while adding optimizations for large-scale transactional and analytical workloads. The project differentiates itself through a set of Alibaba-specific improvements, including a columnar engine for accelerating analytical queries directly on MySQL tables, and a distributed, shared-nothing NDB Cluster en

whodb 是一个多数据库管理界面和笔记本客户端，旨在探索和管理包括 Postgres、MySQL、MongoDB 和 Redis 在内的各种引擎的数据。它作为一个统一层，通过图形界面管理数据库连接、记录和模式。 该项目具有自然语言查询界面，使用大语言模型将简单的英语翻译成可执行的 SQL 或 NoSQL 查询。这得益于模式感知提示（schema-aware prompting），它将数据库元数据注入模型上下文，以确保生成的查询与实际表定义匹配。 其他功能包括将外键元数据转换为交互式图网络的模式可视化工具，以及用于创建模拟数据集的合成数据生成器。该工具还提供了一种笔记本式的执行模型，用于将查询组织成顺序单元格，支持 CSV 和 JSON 等格式的数据导出，以及用于环境管理的命令行界面。

Liam 是一个数据库模式可视化工具和交互式实体关系图生成器。它解析 SQL 模式和 ORM 格式以创建数据库结构的视觉表示，允许用户分析表关系并导航复杂的布局。 该项目通过 CI/CD 流水线集成脱颖而出，充当文档自动化工具，在部署期间将图表与数据库模式更改同步。它支持通过基于坐标的视图链接共享模式的特定视角，这些链接捕获精确的缩放级别和过滤后的视图。 该工具提供了广泛的可视化功能，包括带有平移和缩放功能的交互式画布渲染、用于减少视觉混乱的状态驱动视图过滤，以及用于重组布局的手动节点操作。它还支持生成用于内部存储库的静态图表。

TablePro is a cross-platform database management client designed for browsing, querying, and administering both SQL and NoSQL databases. It functions as a unified workspace that integrates a code-centric SQL editor with schema visualization tools, allowing developers to manage complex data models and execute queries across diverse database engines. The application distinguishes itself through an agentic AI integration layer that connects language models directly to database tools, enabling automated query generation, optimization, and error fixing with configurable approval gates. It features

TypeDB 是一款强类型图数据库和知识图谱管理系统。它作为多模型数据存储，将关系、文档和图结构统一到一个环境中，既充当 ACID 兼容数据库，又充当声明式查询引擎。 该系统通过使用 n 元超图建模和多态类型层级脱颖而出。它采用强类型模式来强制执行结构规则并验证数据完整性，允许在查询执行期间自动解析复杂关系的基于类型的多态推理和基于角色的接口多态性。 该平台涵盖了广泛的功能，包括通过制表（tabling）计算递归关系、快照隔离事务和声明式数据检索。它还通过基于共识的集群复制、基于角色的访问控制以及与 AI 代理的集成以进行结构化数据检索，支持高可用性。 管理通过命令行界面支持，系统提供用于可视化图模式和审计管理活动的工具。

rails-erd 是一个 Ruby on Rails ERD 生成器和数据库模式可视化工具。它作为一个自动化图表工具，分析模型关联和属性，以创建图形化的领域模型。 该工具将关联和继承模式映射为可视化的实体关系图，包括对可视化单表继承的特定支持。它允许自定义关系符号，使用户能够在简化箭头和 Bachman 符号之间切换。 该系统提供用于技术文档的多格式图表导出，并允许配置图表布局。它利用基于反射的元数据检查，以编程方式发现数据层内的属性和关联。

Kùzu is an embedded property graph database engine designed for high-performance analytical queries and local data management. It operates as a library within the host application process, utilizing a columnar-based storage architecture and just-in-time query compilation to execute complex graph traversals and pattern matching efficiently. By mapping database files directly into system memory, it ensures data durability and high-speed access while maintaining ACID-compliant transactional integrity. The engine distinguishes itself by integrating vector similarity search and full-text search di

dbtpl 是一个数据库模型生成器和模式内省工具，可从 SQL 数据库模式生成类型安全的源代码和数据模型。它作为一个命令行工具，将 SQL 类型映射到 Go 结构体和执行函数，同时提供了一个基于模板的系统，用于创建自定义源代码和模式定义。 该工具支持多种数据库引擎，包括 PostgreSQL、MySQL、SQLite、Oracle 和 SQL Server。它的独特之处在于允许用户通过文本模板定义自定义输出格式，并能为 Django Web 框架生成兼容的模型定义。 其功能还包括生成用于数据库迁移和镜像的 SQL 脚本，以及以 JSON 或 YAML 格式导出模式表示。此外，它还可以生成 dot 文件以可视化数据库关系和结构图。