mrkeyoor.com_
Sat 07 Nov 20:52 UTC
Dataevaluationupdated 25 Oct 2026

drawdb review

drawDB is a browser-based database entity relationship diagram editor and SQL generator. Its README describes diagram editing, SQL import and export, and migration generation without an account. In our recorded run on October 4, 2026, commit ee550b4 completed dependency installation in 22 seconds and the build command in 17 seconds. Browser editing and SQL correctness were not tested.

+53stars / 7d
Verdict

drawDB is worth evaluating for visual schema drafting if you will inspect and validate exported SQL. Our October 4, 2026 run of ee550b4 established successful dependency installation and a successful build, with five recorded dependency advisories and unknown audit coverage. It did not establish browser reliability, SQL fidelity or sharing behavior. Budget for the optional sharing server, check the license against your policy, and try a representative schema before adopting it.

We ran it

Lab card: what happened when we ran drawdbScreenshot of drawdb (drawdb.app)
Install✓ · 22s1890 packages · 618 MB
Build✓ · 17s
Testsn/ano test script
Known vulns50 critical · 3 high · 1 moderate · 1 low (npm audit)
Repo295 files~52,534 lines of source · 3.6 MB · 2 CI workflows · Dockerfile

Answers from our run

Does drawdb build from source?

Dependencies installed in 22 seconds (1890 packages), and the build succeeded in 17 seconds. We cloned commit ee550b4 into a clean Debian container with 3 CPUs and no project-specific setup.

Does drawdb have tests you can run?

Not through a standard command: the project exposes no test script or target that our harness could run.

Does drawdb have known vulnerabilities in its dependencies?

npm audit flagged 5 known advisories in the dependency tree at the time of our run.

Who should not use drawdb?

Teams requiring browser behavior or SQL round trips to have been validated by this review: our run covered installation and building only.

What are the alternatives to drawdb?

ChartDB, Azimutt. drawDB is worth evaluating for visual schema drafting if you will inspect and validate exported SQL.

Setup3/5Baseline with important gaps: our October 4, 2026 run of ee550b4 completed installation in 22 seconds and building in 17 seconds; the recorded installation size was 618 MB. Docker and the optional sharing server were not tested.
Docs3/5Documented baseline: the supplied README includes npm and Docker commands and explains optional sharing configuration. It does not establish SQL round-trip correctness.
Community3/5Observed participation with limits: issue discussions include maintainer replies and contributor follow-up. This evidence does not establish adoption, response-time guarantees or support quality across the project.
Maturity3/5Baseline with important validation gaps: ee550b4 built successfully, but the harness skipped tests for lack of a test script and did not exercise browser or SQL behavior. Issue 1144 supplies version-specific reports rather than a verified current-release conclusion.

Discussed on

  1. hnShow HN: Online database diagram editor311 points
  2. hnShow HN: DrawDB – turn any live database into an ER diagram with one query5 points
  3. hnDrawDB: Online database diagram editor and SQL generator4 points

Who it’s for

Developers evaluating a visual editor for relational schema design.
Teams willing to review generated SQL before using it in migrations.
Self-hosters who can configure an additional server if they need file sharing.
Students who want to examine database structures visually.

Who it’s NOT for

Teams requiring browser behavior or SQL round trips to have been validated by this review: our run covered installation and building only.
Deployments expecting file sharing from the frontend alone: the README requires an optional server and environment configuration.
Release processes requiring zero reported dependency advisories: our dated run recorded five, with audit coverage unknown.
Organizations whose software policy excludes AGPL-3.0 software.

Setup reality

In our recorded run on October 4, 2026 at 03:39:08.843 UTC, commit ee550b4117a6e1b5366205faa5cee713ee1d4e3b completed the npm dependency installation step in 21,960 ms, rounded to 22 seconds, and the build command in 16,806 ms, rounded to 17 seconds. Both exited successfully. Vite v8.1.0 separately reported an internal build duration of 11.59 seconds; that is narrower than the measured command duration.

The recorded configuration was 3 CPUs, 8 GB of memory and image lab-node:22; detection recorded Node major 22. This does not establish an exact runtime patch version or broader compatibility. The dependency summary recorded count 1,890 and installation size 618 MB. That count is not a verified number of packages downloaded or audited. npm audit recorded five advisories: three high, one moderate, one low and zero critical. Audit coverage is unknown.

Tests were skipped because the harness found no test script. Detection listed dev, build, lint and preview scripts, no tests directory, two CI workflows, a Dockerfile and a compose file. This does not establish that the project has no tests anywhere. The repository summary recorded 295 files, about 52,534 source lines and 3.6 MB.

The README documents npm development and build paths plus Docker commands. It says file sharing requires a server and environment configuration, with VITE_BACKEND_URL supplied at container startup without rebuilding. Our run did not exercise Docker, browser editing, persistence, sharing, SQL round trips or an installed binary.

A successful build leaves the database checks to you

A diagram can help explain a schema, but our drawDB build did not establish that exported SQL recreates it correctly. That distinction matters when choosing an editor for migration work.

The drawDB README describes a browser ERD editor that can build diagrams, import and export SQL scripts, and generate migrations without creating an account. Those are documented capabilities. Our recorded run covered dependency installation and a production build, rather than the browser workflow.

For developers considering drawDB, the useful next step is to import a representative schema, inspect the diagram, export the SQL and apply it to a disposable database. Compare the resulting database metadata with the intended schema before using the output in a migration. This is a recommended acceptance check, not work completed in our run.

What our October 4 run established

Our stored run began on October 4, 2026 at 03:39:08.843 UTC and used commit ee550b4117a6e1b5366205faa5cee713ee1d4e3b, abbreviated ee550b4. Dependency installation succeeded in 21,960 ms, rounded to 22 seconds. The build command succeeded in 16,806 ms, rounded to 17 seconds. Inside that command, Vite v8.1.0 reported its own build duration of 11.59 seconds. These timings describe different scopes.

The recorded configuration was 3 CPUs, 8 GB of memory and image lab-node:22, with Node major 22 recorded by detection. We have no exact runtime patch version in this evidence. One successful build does not establish compatibility across Node versions or deployment environments.

The dependency summary recorded count 1,890 and installation size 618 MB. Treat that count as a stored dependency metric, not a count of packages downloaded or audited. The repository summary recorded 295 files, about 52,534 source lines and a 3.6 MB checkout.

npm audit recorded five dependency advisories: three high, one moderate, one low and zero critical. Audit coverage is unknown. These findings do not establish exploitability in the deployed editor, and zero critical findings do not establish safety. Review the affected dependency paths against your release policy.

The build emitted a direct-eval warning involving lottie-web and a chunk-size warning. They did not fail the build and do not independently establish a security defect or measured browser slowdown.

The harness skipped tests because it found no test script. Detection listed dev, build, lint and preview scripts, no tests directory, and two CI workflows. That is narrower than proving that no tests exist. We did not test browser controls, diagram persistence, SQL imports and exports, sharing, Docker deployment or an installed binary.

Sharing adds a server

The README documents local npm development, a production build and Docker commands. It says the server is optional unless you need to share files. For Docker, it documents passing VITE_BACKEND_URL when starting the container without rebuilding the image.

Evaluate that server configuration alongside the frontend if shared files are part of your intended workflow. Our frontend build provides no evidence about the sharing service's operation or reliability.

PostgreSQL defaults need a focused acceptance check

Issue 1144 contains a report from a user running the v1.8.1 Docker image in Firefox on Linux. The report describes warnings for defaults on TEXT and VARCHAR without a length, plus difficulty representing an empty-string default. These are reported observations, not results from our sandbox.

A separate issue commenter describes checks on main at f418c29 using PostgreSQL 16.11. The commenter explicitly says the reported v1.8.1/Firefox environment remained untested. The supplied thread also records a referencing commit, 6bd5af6, on October 21, 2026. That reference alone does not establish that a fix was merged, released or resolves every default-handling case.

For your own acceptance check, distinguish an absent default, SQL NULL, an empty string, literal quotes and whitespace. Include the types and constraints your application actually uses. Our October 4 build cannot answer whether those cases work in your chosen version.

Choose alternatives by the starting task

ChartDB's README describes running a query to retrieve schema JSON and importing that result into its diagram editor. Evaluate it when an existing database is your starting point. The project describes itself as Public Beta; this review did not test its import or export behavior.

Azimutt's README describes exploring schemas through search, displaying selected tables and columns, following relationships, and adding documentation. Evaluate it when navigating and documenting an existing schema matters more than starting a new diagram. Its description does not establish a speed advantage over drawDB.

SchemaSpy is omitted from the recommendations because no primary-source extract supporting its role was supplied.

How to read the scores

These are editorial evidence ratings, not benchmark results or an overall product ranking. The scale is 1 for substantial demonstrated obstacles, 2 for material limitations, 3 for a documented or observed baseline with important gaps, 4 for strong validation across the relevant workflow, and 5 for extensive corroborated validation. Missing evidence limits a rating; it does not prove poor product quality.

Setup receives 3/5 because installation and building succeeded, while deployment and sharing remain untested. Documentation receives 3/5 because the supplied README gives setup commands and the sharing configuration boundary, but does not establish SQL round-trip correctness. Community receives 3/5 because the supplied issue discussions show maintainer and contributor participation, without establishing response-time or support guarantees. Maturity receives 3/5 because a successful build coexists with unresolved validation questions and reported behavior that needs version-specific checking.

The recorded license is AGPL-3.0. Check its terms against your deployment policy rather than treating all network use as prohibited. If the license fits, start with one representative schema and verify the exported result before expanding adoption.

Alternatives

ProjectWhat it isPick it when
ChartDBA web database diagram editor whose README describes importing schema JSON produced by a single query.Choose it for evaluation when your starting point is an existing database and you want its query-to-JSON schema import workflow. Its README labels the project Public Beta; we did not test it.
AzimuttA database exploration tool whose README describes schema search, selective table display, relationship navigation and documentation.Choose it for evaluation when understanding and documenting a large existing schema is the main task. These are documented capabilities, not a measured performance advantage over drawDB.

What people are saying

  1. [github-trending] drawdb-io/drawdb

Sources

  1. drawDB README and repository
  2. drawDB open issues and pull requests
  3. Save As bug report 1155
  4. PostgreSQL default handling bug 1144
  5. Large-diagram navigation request 1110
  6. drawDB AGPL-3.0 license

More data reviews

rerun · telegraf · rocksdb · redash · akshare · DB-GPT · the whole board →