mrkeyoor.com_
Tue 01 Sept 16:23 UTC
Dataevaluationupdated 22 Aug 2026

dbgate review

DbGate is a desktop and browser-based database manager for relational databases, MongoDB, Redis, and several other engines. It gives developers one place to inspect data, edit schemas, write queries, compare structures, and move records between common file formats.

+15stars / 7d
Verdict

DbGate is a good fit for developers who want one familiar interface across SQL, document, and key-value databases, especially when both desktop and self-hosted web access matter. The source tree is heavier and less uniform than the two-line development start suggests, and current reports around paged results and RDS IAM deserve a trial with your own database. Use the packaged release first, then adopt it only after checking the exact connectors and workflows your team depends on.

We ran it

Lab card: what happened when we ran dbgateScreenshot of dbgate (www.dbgate.io)
Install✓ · 611s1583 packages · 1352 MB
Buildn/ano build script
Testsn/ano test script
Repo1508 files~155,477 lines of source · 21.6 MB · 15 CI workflows · tests dir

Answers from our run

Does dbgate build from source?

Dependencies installed in 611 seconds (1583 packages), and the project has no separate build step. We cloned commit ecf82e6 into a clean Debian container with 3 CPUs and no project-specific setup.

Does dbgate have tests you can run?

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

Who should not use dbgate?

Teams that need every listed connector in the free edition: the README marks Redshift, CosmosDB, Firestore, and Turso support as Premium.

What are the alternatives to dbgate?

DBeaver Community, Beekeeper Studio, CloudBeaver. DbGate is a good fit for developers who want one familiar interface across SQL, document, and key-value databases, especially when both desktop and self-hosted web access matter.

Setup3/5Easy packaged start, heavy and multi-process source setup
Docs4/5Good usage coverage, scattered development verification steps
Community4/5Current push, recent release, and busy issue and PR activity
Maturity4/5Broad daily-use feature set with some serious open regressions

Discussed on

  1. hnShow HN: DbGate – open-source, cross-platform SQL+noSQL database client198 points
  2. hnDbgate: Database Manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite etc.17 points
  3. hnDbGate – open-source database client – now supports SQLite10 points
  4. hnDbGate supports libSQL/Turso database3 points
  5. hnDbGate: The Smartest SQL+noSQL Database Client3 points

Who it’s for

Developers who regularly move between PostgreSQL, MySQL, SQLite, MongoDB, Redis, and other database engines.
Small teams that want a shared browser database client they can host themselves.
People who prefer visual filtering, relationship browsing, schema editing, and import or export tools alongside a code editor.
JavaScript developers who want database operations exposed through reusable packages and a scripting API.

Who it’s NOT for

Teams that need every listed connector in the free edition: the README marks Redshift, CosmosDB, Firestore, and Turso support as Premium.
AWS RDS users depending on MySQL IAM authentication today: issue #1544 reports that the required cleartext authentication option cannot be enabled in DbGate 7.2.5.
Anyone who treats a paged data grid as an unquestioned source of truth: issue #1537 reports filtered and sorted PostgreSQL views showing duplicate rows while omitting others.
Operators expecting a tiny source build: our dependency install occupied 1,352 MB, and the repository uses many Yarn workspaces.
Contributors who expect one root test command: the README sends unit, integration, and Cypress work through separate commands, while our harness found no generic test target.

Setup reality

At commit ecf82e6, installation succeeded in 611 seconds. Yarn installed 1,583 packages and used 1,352 MB on disk. The checkout contained 1,508 files and about 155,477 source lines. Our harness found no generic build or test target, so both steps were skipped.

Using the packaged desktop app is much simpler than developing the repository. The web edition needs a server, persistent storage, database connection details, and browser access. Each database still needs its own host, port, user, password or token, and any required TLS settings.

Source development is a monorepo workflow. The README starts the API and web client together, or asks you to run three terminals for the API, web client, and library watchers. Integration tests require Docker, Electron has a second install inside app, and the checkout had 15 CI workflow files but no Dockerfile.

One database client for mixed stacks

DbGate suits developers whose day does not stay inside one database engine. Its connection list spans PostgreSQL, MySQL, SQL Server, Oracle, SQLite, MongoDB, Redis, ClickHouse, Cassandra, DuckDB, Firebird, and more. The interface combines a SQL editor with table browsing, schema editing, relationship views, imports, exports, charts, and an ER diagram.

A team can keep one set of habits while moving between an application database, an analytics store, and a cache. DbGate runs as an Electron desktop app or a web application. The browser option works for a small team that wants a shared tool without installing a client on every machine.

The free and paid boundaries need reading. The README labels Redshift, CosmosDB, Firestore, and libSQL or Turso as Premium. Server Chat and a ChatGPT account connection were added to Premium in release 7.2.5. DbGate remains GPL-3.0 and free to use, but the matrix is wider than the free connector list. Check the edition against your actual databases.

Daily work is visual and practical

The table browser goes beyond a plain grid. It has Excel-style and multi-value filters, form views for wide records, foreign-key lookups, master-detail navigation, and expandable related columns. Edits can be previewed as a SQL change script. DbGate can edit indexes and relationships, then compare and synchronize structures. Those tools cover jobs that otherwise bounce between a query editor, an admin console, and exporters.

Imports and exports cover CSV, Excel, JSON, NDJSON, XML, and DBF. An archive feature stores data as NDJSON, and the application can browse large NDJSON files directly. Charts and geographic views can be exported to HTML. This does not prove DbGate can replace an engine-specific administration tool, but it makes the application useful for inspection and ordinary data changes across a mixed stack.

The concern is correctness at the edge of the grid. Open issue #1537 reports a filtered and sorted PostgreSQL table view that duplicates some rows while hiding the same number of other rows. The total count remains correct, which makes the failure easy to miss. Until that report is resolved and verified, teams doing sensitive review work should compare suspect results with an explicit query or another client.

What happened when we ran it

We cloned commit ecf82e6 into an unprivileged Debian container with 3 CPUs, 8 GB of RAM, no secrets, and the node:22-bookworm image. The repository had 1,508 files, roughly 155,477 lines of source, and a 21.6 MB checkout. Yarn installation completed in 611 seconds, bringing in 1,583 packages and leaving 1,352 MB on disk. That is a successful install with a large dependency footprint.

Our harness looked for standard root build and test targets. It found neither, so it skipped both steps. The README documents workspace unit tests, Docker-backed integration tests, and Cypress end-to-end tests. The root package also exposes named build commands for libraries, the API, web client, plugins, and Electron. Generic automation cannot verify the project through build and test without project-specific instructions.

The checkout had a tests directory, monorepo workspaces, and 15 CI workflow files. It had no Dockerfile in the measured tree. The published product offers a Docker image, but contributors should follow the repository's own multi-command paths instead of expecting a conventional single-package Node project.

Source development takes several moving parts

The README's shortest development path is yarn followed by yarn start, which launches the API and web client concurrently. The controlled route uses three terminals: API on port 3000, web development on port 5001, and watchers for TypeScript libraries and plugins. Electron development adds another install inside app, then its own start command.

Tests are split by purpose. A workspace command runs a package's unit tests. Integration tests live in their own directory and require Docker. Cypress opens the end-to-end suite. This layout is reasonable for a project shipping a web server, desktop application, plugins, and database drivers, but contributors must know which slice they changed. A root verification command would make first contributions safer.

Self-hosting brings normal database-client risk. The server needs credentials for every configured connection and network access to those databases. Release 7.2.5 fixed SSRF, local file reads, unsafe plugin operations, path escapes, and script injection. Those fixes are a reason to stay current. They also show why a shared instance belongs behind authentication and controlled network boundaries.

Project health and the decision

The repository was pushed on August 21, 2026, and release 7.2.5 arrived on August 13. Recent issues and pull requests were moving on August 20 and 21. GitHub reported 447 open issues and PRs combined, which is a sizable queue, but the dates show active maintenance. The repository had about 7,269 stars when checked.

Current bug reports matter more than the star count. Issue #1544 says MySQL cleartext authentication cannot be enabled after a driver change, breaking the reporter's AWS RDS IAM path. Issue #1538 reports the hosted web app hanging while it waits for structure on the first session, then working after a reload. Along with the table paging report, these are specific cases to reproduce during evaluation.

DbGate earns a trial when database variety is the problem and a browser option has real value. Start with the packaged desktop app or official image, connect non-production databases, and test sorting, exports, authentication, and schema changes against your normal workload. Teams centered on one SQL engine may prefer a narrower client. Mixed-database teams can get more from DbGate if they validate the exact paths they plan to trust.

Alternatives

ProjectWhat it isPick it when
DBeaver Community gh↗A mature desktop database client with a large driver ecosystem and an Eclipse foundation.pick this instead when desktop depth, driver coverage, and long-established workflows matter more than a browser edition.
Beekeeper StudioA polished desktop SQL client with a narrower, approachable interface.pick this instead when your work is mostly SQL and you want fewer database and deployment concepts in the UI.
CloudBeaverA browser database manager built for shared server deployment.pick this instead when a centrally managed web client is the main requirement and desktop use is secondary.

What people are saying

  1. [github-trending] dbgate/dbgate

Sources

  1. DbGate README
  2. DbGate repository
  3. DbGate 7.2.5 release
  4. MySQL cleartext authentication report
  5. Paged table duplicate row report

More data reviews

turso · TrackersListCollection · dash · getcontact-cli · awesome-zhuiju-free · iggy · the whole board →