drawdb

drawdb-ioAGPL-3.0活跃维护

免费的在线数据库图表编辑器,拖拽画 ER 图就能生成 SQL 建表语句,省去手写 schema 的麻烦。

Free, simple, and intuitive online database diagram editor and SQL generator.

v1.9.0发布于 2026-11-01 17:54 UTC40,293star +19 / 7 天3,362fork同步于 2026-11-10 11:20 UTC

怎么上手

由 README 提炼,执行前请确认
git clone https://github.com/drawdb-io/drawdb
cd drawdb
npm install
npm run dev
硬件要求按 README 说明

README 未说明,纯浏览器前端应用,本地开发需 Node.js 环境

有 Docker 镜像
下载:源码 zip·GitHub Releases(安装包)本站不镜像安装包

项目说明

由 README 自动翻译提炼

浏览器里画数据库 ER 图并生成 SQL 的免费开源编辑器,无需注册账号

免费的在线数据库图表编辑器,拖拽画 ER 图就能生成 SQL 建表语句,省去手写 schema 的麻烦。

核心能力

  • 在浏览器中点击绘制数据库实体关系图
  • 导入导出 SQL 脚本并生成迁移
  • 自定义编辑器外观与配置
  • 无需注册账号即可使用
  • 提供 Docker 镜像一键部署

容易踩的坑

分享功能需另行部署 drawdb-server 并配置 .env.sample 中的环境变量;Docker 镜像默认映射容器 80 端口到宿主机 3000;启用分享时需通过 VITE_BACKEND_URL 传入服务端地址

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

最近发版

1 个版本v1.9.0
  1. v1.9.0v1.9.0 - Import from your database最新正式版2026-11-01 · 2026-11-01 17:54 UTC

    Import from your database

    File → Import from database. Pick your dialect, copy the read-only query drawDB gives you, run it in the SQL client you already use (psql, Workbench, DBeaver, SSMS…), and paste the result back. drawDB draws the diagram and auto-arranges it.

    • Works with PostgreSQL, MySQL, MariaDB, SQL Server, SQLite and Oracle
    • No connection string: your credentials never leave your machine, and drawDB never sees row data

    (#1182)

    Subject areas that hold tables

    Areas now own the tables inside them: move an area and its tables move with it, hide or show a whole group at once, and reorder areas. (#1184, #1185)

    Also in this release

    • Faster canvas on large diagrams (#1172, #1183)
    • SQL headers tab: custom text at the top of every export (#1169)
    • Comments shown in the sidebar (#1159)
    • Touchpad horizontal panning without holding Shift (#1162)
    • Fix: import when NOT NULL is absent (#1171)
    • Fix: autosave for enum-only diagrams and empty edits (#1186)
    • Dependency updates

    Full changelog: https://github.com/drawdb-io/drawdb/compare/v1.8.2...v1.9.0

用户点评

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

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

    README 原文

    未翻译

    DrawDB is a robust and user-friendly database entity relationship diagram (ERD) editor right in your browser. Build diagrams with a few clicks, export and import SQL scripts, generate migrations, customize your editor, and more without creating an account. See the full set of features on here.

    Getting Started

    Local Development

    git clone https://github.com/drawdb-io/drawdb
    cd drawdb
    npm install
    npm run dev
    

    Build

    git clone https://github.com/drawdb-io/drawdb
    cd drawdb
    npm install
    npm run build
    

    Docker Build

    docker build -t drawdb .
    docker run -p 3000:80 drawdb
    

    If you want to enable sharing, set up the server and environment variables according to .env.sample. This is optional unless you need to share files.

    With the Docker image, pass the server URL when starting the container. No rebuild is needed:

    docker run -p 3000:80 -e VITE_BACKEND_URL=https://your-drawdb-server.example.com ghcr.io/drawdb-io/drawdb:latest
    

    Contributing

    Please see CONTRIBUTING.md for guidelines on how to contribute to this project.

    Support