登录

whodb

clideyApache-2.0活跃维护

面向数据库的可视化管理平台，支持 ER 图、数据目录与血缘追踪，并通过 MCP 协议让 AI Agent 直接查询和操作多种数据源。

Where data access meets operational intelligence

0.138.0发布于 2026-10-28 01:37 UTC5,053star +3 / 7 天243fork同步于 2026-11-10 17:37 UTC
数据库管理数据目录数据血缘MCP 协议ER 图
对比 GitHub 官网ai-agentdata-catalogdata-governancedata-integrationdata-lineage

怎么上手

由 README 提炼，执行前请确认
原文 
docker run --rm -it -p 8080:8080 clidey/whodb
硬件要求按 README 说明

README 未说明显存或 GPU 要求；以 Docker 或桌面应用形式运行，无需本地 GPU。

有 Docker 镜像
下载：源码 zip·GitHub Releases（安装包）本站不镜像安装包

项目说明

由 README 自动翻译提炼
没人工点评？写下你的经验

轻量自托管的多数据库工作台，浏览器里浏览编辑数据、跑查询、看表关系

面向数据库的可视化管理平台，支持 ER 图、数据目录与血缘追踪，并通过 MCP 协议让 AI Agent 直接查询和操作多种数据源。

核心能力

  • 表格网格中排序过滤分页并支持行内编辑
  • 用交互式关系图直观查看表与表之间的关联
  • 多单元格查询草稿本带自动补全与历史记录
  • 支持导入导出数据并生成开发用模拟数据
  • 可选接入 Ollama、OpenAI、Anthropic 等用自然语言提问

容易踩的坑

默认监听 8080 端口，启动后需在页面手动填写数据库连接信息；容器重建会丢失加密登录会话，需挂载 /data 并固定 WHODB_ENCRYPTION_KEY；本地 AI 默认连 Ollama localhost:11434 与 LM Studio localhost:1234/v1，Docker 下地址会自动调整，不符时需用环境变量覆盖。

内容由模型根据 README 生成，可能不完整或不准确，以官方文档为准。看原文 README

最近发版

5 个版本0.138.0
全部 release
  1. 0.138.0Release 0.138.0最新正式版2026-10-28 · 2026-10-28 01:37 UTC
    • Security and fixes
      • Guard multipart uploads
      • Limit connection probes
      • Hide advanced profile values
      • DuckDB test fix
    • Features and UI
      • Add a better 404 page
      • Update CLI support and CLI feature fixes
      • Update translations
    • Tooling and maintenance
      • Upgrade to pnpm 12
      • Update analytics
      • Update dependencies

    Installation

    Mac App Store

    Download from the Apple Store

    Microsoft Store

    Download from the Microsoft Store

    Snap Store

    sudo snap install whodb

    View on Snapcraft

    Docker

    docker pull clidey/whodb:0.138.0
docker pull clidey/whodb:latest

    Direct Downloads

    See assets below for platform-specific packages (DMG, MSIX, etc.).

    Documentation

    Upgrade Notes

    To upgrade from a previous version:

    • Docker: Pull the latest image and restart your container
    • Snap: Run sudo snap refresh whodb
    • Desktop Apps: Download and install the new version

    What's Changed

    Full Changelog: https://github.com/clidey/whodb/compare/0.137.0...0.138.0

  2. 0.137.02026-10-28 · 2026-10-28 00:05 UTC
    查看更新说明

    What's Changed

    Full Changelog: https://github.com/clidey/whodb/compare/0.136.0...0.137.0

  3. 0.136.0Release 0.136.02026-10-21 · 2026-10-21 10:44 UTC
    查看更新说明

    Installation

    Mac App Store

    Download from the Apple Store

    Microsoft Store

    Download from the Microsoft Store

    Snap Store

    sudo snap install whodb

    View on Snapcraft

    Docker

    docker pull clidey/whodb:0.136.0
docker pull clidey/whodb:latest

    Direct Downloads

    See assets below for platform-specific packages (DMG, MSIX, etc.).

    Documentation

    Upgrade Notes

    To upgrade from a previous version:

    • Docker: Pull the latest image and restart your container
    • Snap: Run sudo snap refresh whodb
    • Desktop Apps: Download and install the new version

    What's Changed

  4. 0.135.0Release 0.135.02026-10-15 · 2026-10-15 16:20 UTC
    查看更新说明

    Installation

    Mac App Store

    Download from the Apple Store

    Microsoft Store

    Download from the Microsoft Store

    Snap Store

    sudo snap install whodb

    View on Snapcraft

    Docker

    docker pull clidey/whodb:0.135.0
docker pull clidey/whodb:latest

    Direct Downloads

    See assets below for platform-specific packages (DMG, MSIX, etc.).

    Documentation

    Upgrade Notes

    To upgrade from a previous version:

    • Docker: Pull the latest image and restart your container
    • Snap: Run sudo snap refresh whodb
    • Desktop Apps: Download and install the new version

    What's Changed

    New Contributors

    Full Changelog: https://github.com/clidey/whodb/compare/0.133.0...0.135.0

  5. 0.134.0Release 0.134.02026-09-30 · 2026-09-30 14:16 UTC
    查看更新说明

    Installation

    Mac App Store

    Download from the Apple Store

    Microsoft Store

    Download from the Microsoft Store

    Snap Store

    sudo snap install whodb

    View on Snapcraft

    Docker

    docker pull clidey/whodb:0.134.0
docker pull clidey/whodb:latest

    Direct Downloads

    See assets below for platform-specific packages (DMG, MSIX, etc.).

    Documentation

    Upgrade Notes

    To upgrade from a previous version:

    • Docker: Pull the latest image and restart your container
    • Snap: Run sudo snap refresh whodb
    • Desktop Apps: Download and install the new version

    Full Changelog: https://github.com/clidey/whodb/compare/0.132.0...0.134.0

用户点评

登录用户的真实使用记录，可按版本和硬件筛选
共 0 条

    还没有人点评。第一个说出真实体验的人最有价值。

    README 原文

    未翻译
    在 GitHub 打开

    WhoDB

    MCP Toplist

    A lightweight, self-hosted workspace for your databases

    Release workflow Release version Release date Total downloads Docker size

    Commits per month Last commit Contributors Closed issues Closed PRs

    License GitHub stars Go TypeScript

    Available on

    Docker Windows macOS Snap CLI

    Quick start · Documentation · Live demo · Community

    WhoDB gives you one place to explore your databases, edit data, run queries, and understand how a schema fits together. It runs in the browser, is easy to self-host, and is available as a desktop app or terminal CLI too.

    Use it when you want to inspect a local database, help a teammate explore unfamiliar data, or work without installing a heavyweight database client. AI features are optional: connect Ollama, OpenAI, Anthropic, LM Studio, or another OpenAI-compatible provider if you want to ask questions in plain English.

    Quick start

    Run WhoDB with Docker:

    docker run --rm -it -p 8080:8080 clidey/whodb

    Then open http://localhost:8080 and enter your database connection details.

    Want to look around first? Try the live demo or watch the video walkthrough.

    What you can do

    • Browse and edit data in a spreadsheet-style grid with sorting, filtering, pagination, and inline editing.
    • Understand a schema visually with an interactive graph of tables and relationships.
    • Work through queries in a scratchpad with multiple cells, autocomplete, history, and results kept alongside each query.
    • Move data in and out with imports, exports, and mock-data generation for development and testing.
    • Ask questions in plain English using a local or hosted AI provider that you choose.
    • Work from your terminal through the WhoDB CLI and its MCP server.

    Supported databases

    WhoDB Community supports:

    • PostgreSQL, CockroachDB, YugabyteDB, and QuestDB
    • MySQL, MariaDB, and TiDB
    • SQLite and DuckDB
    • MongoDB and FerretDB
    • Redis, Valkey, and Dragonfly
    • Elasticsearch and OpenSearch
    • ClickHouse and Memcached

    Support varies by database because not every system has the same concepts or capabilities. The connection screen shows the options available for each source.

    Installation options

    Docker with persistent sessions

    The one-line Docker command is ideal for trying WhoDB. To keep encrypted login sessions when the container is replaced, first generate a key and save it somewhere secure:

    openssl rand -hex 32

    Then mount /data and reuse that key whenever you start the container:

    docker run -it -p 8080:8080 \
  -v whodb-data:/data \
  -e WHODB_ENCRYPTION_KEY=your_saved_64_character_hex_key \
  clidey/whodb

    Keep that key somewhere safe. Changing it invalidates existing sessions. If WhoDB is served through an HTTPS reverse proxy, also set WHODB_SECURE=true so browsers only send the session cookie over HTTPS.

    See the documentation for Docker Compose, connection profiles, SSL, AI providers, and other configuration options.

    Desktop

    CLI and MCP server

    The CLI includes an interactive terminal UI and an MCP server for AI tools:

    # macOS and Linux
curl -fsSL https://raw.githubusercontent.com/clidey/whodb/main/cli/install/install.sh | bash

# or install with npm
npm install -g @clidey/whodb

    whodb             # open the terminal UI
whodb mcp serve   # start the MCP server

    See the CLI guide for connection examples and the full command reference.

    AI providers

    You can add a hosted AI provider directly from WhoDB—no backend configuration or restart is required. Open Chat, choose Add Provider from the provider menu, then select OpenAI, Anthropic, or Gemini and enter your API key. WhoDB will fetch the available models from that provider.

    Ollama and LM Studio are available as local options in WhoDB Community. By default, the backend looks for Ollama at localhost:11434 and LM Studio at localhost:1234/v1, with local addresses adjusted automatically for Docker and WSL. Use WHODB_OLLAMA_HOST, WHODB_OLLAMA_PORT, or WHODB_LMSTUDIO_BASE_URL only when those defaults are not suitable for your setup.

    Optional backend provider configuration

    Environment variables let deployment administrators declare providers when the server starts. This is useful for preconfiguring OpenAI or Anthropic, changing provider endpoints, or adding an OpenAI-compatible service for everyone using that deployment:

    • WHODB_OPENAI_* for OpenAI
    • WHODB_ANTHROPIC_* for Anthropic
    • WHODB_OLLAMA_* for Ollama connection settings
    • WHODB_LMSTUDIO_* for LM Studio connection settings
    • WHODB_AI_GENERIC_<ID>_* for OpenAI-compatible providers

    See the installation guide for the complete environment variable list and the AI provider guide for setup examples.

    WhoDB Community and WhoDB Platform

    This repository contains WhoDB Community, the Apache-2.0-licensed database workspace described above. It is free to self-host and is the best place to start if you want to explore and work with databases.

    WhoDB Platform is the commercial, self-hosted edition for organizations that need shared projects, more data sources, SSO, fine-grained access controls, audit logs, pipelines, reporting, and internal apps. You can read the WhoDB overview or compare plans on the pricing page.

    Development

    WhoDB has a Go backend and a React/TypeScript frontend. For local development, run them in separate terminals.

    Requirements:

    • Go
    • Node.js and pnpm

    Start the backend:

    cd core
go run ./cmd/whodb

    Start the frontend:

    cd frontend
pnpm install
pnpm start

    The frontend opens at http://localhost:3000 and talks to the backend on port 8080. See the CE build and run guide for generation and build commands.

    Contributing

    Bug reports, feature ideas, documentation improvements, and code contributions are all welcome.

    More screenshots

    Query scratchpad

    Add and edit records

    Build filters visually

    Export data

    Support

    WhoDB is licensed under the Apache License 2.0.

    If WhoDB saves you time, consider giving the project a star.

    相关项目

    同分类里 star 最高的项目
    对比全部 →
    vector
    vectordotdev·Rust

    高性能可观测性数据管道，用 Rust 编写，统一采集、转换并转发日志、指标和事件，替代多套采集代理。

    可观测性+4数据管道 / ETL
    22838+232.4kv0.61.02026-11-10 17:13 UTC
    rocketride-server
    rocketride-org·Python

    高性能 AI 流水线引擎，C++ 内核搭配 50+ 可扩展 Python 节点，支持多模型提供商、向量数据库和 Agent 编排，可在 IDE 中构建调试 LLM 工作流。

    流水线引擎+4数据管道 / ETL
    20064+198.7kvscode-v1.6.0-prerelease2026-11-10 17:12 UTC
    dagster
    dagster-io·Python

    用 Python 编排数据管道和资产，把开发、生产到可观测性串起来，适合数据工程和 MLOps 场景。

    数据编排+4数据管道 / ETL
    16386+102.4k1.13.292026-11-09 20:13 UTC
    maestro
    Netflix·Java

    Netflix 开源的工作流编排器，用 DAG 定义和调度批处理、ETL/ELT 数据管道，让大规模数据作业按依赖关系自动执行。

    工作流编排+4数据管道 / ETL
    38523112026-11-06 19:34 UTC