# dbgate/dbgate

Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application

Repository: https://github.com/dbgate/dbgate
Canonical: https://ross.abutalabs.com/products/dbgate
Homepage: https://www.dbgate.io
Language: JavaScript
License: GPL-3.0
License Family: copyleft
Topics: sql-server, sql, database-manager, mysql, postgresql, mongodb, sqlite, electron, database-gui, cassandra, clickhouse, cockroachdb, cosmosdb, duckdb, firebird, firestore, libsql, mariadb, oracle, redis
Last push: 2026-08-26T13:54:08+00:00

## Health v2 (maintenance only)
Score: 94/100 (v2, computed 2026-09-03T02:39:23.370411+00:00)
- activity 99, release rhythm 85, longevity 100
- inputs: {"age_days": 2444, "days_push": 7, "days_rel": 20, "gap_med": 7.0, "n_releases_24m": 75}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 7285, forks 468 (observed 2026-08-28T04:09:58.003619+00:00)

## What it is
DbGate is a cross-platform, open-source (no)SQL database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite, Redis and many other databases. It runs as a desktop application on Windows, Linux and Mac, or as a self-hosted web application via npm or Docker.

## Use cases
- browse and edit data in MySQL, PostgreSQL, MongoDB and other databases
- run SQL queries with autocomplete and syntax highlighting
- compare and synchronize database schemas
- import and export data between databases and CSV, JSON, Excel files
- visualize query results as charts and ER diagrams
- manage multiple database connections from one tool
- query databases with natural language AI chat
- run a self-hosted web-based database client with Docker

## When to choose
- you need a free, cross-platform GUI to work with multiple SQL and NoSQL databases simultaneously
- you want a self-hosted web database client deployable via Docker or npm
- you need batch import/export across many formats and databases
- you want schema comparison, ER diagrams and visual query design in one tool

## When to avoid
- you need only a single database's official tooling with vendor-specific administration features
- you require a permissive open-source license (DbGate is GPL-3.0)
- you need premium features like backup/restore tooling, cloud database support or team administration without paying
- you prefer a lightweight CLI-only workflow

## Facets
- artifact type: application
- maturity: active
- function: database, gui, data-visualization, etl, developer-tools
- domain: databases, developer-tools, self-hosted
- platform: windows, cross-platform
- tags: database-gui, sql-client, nosql, mongodb, mysql, postgresql, sqlite, redis, database-manager, schema-compare, data-import-export, data-engineering, linux, macos, web-server, docker, electron, nodejs

## Member repositories
- dbgate/dbgate (main) score 94

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:09:58.003619+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T17:38:52.690098+00:00, confidence not recorded.
  - readme: https://github.com/dbgate/dbgate (fetched 2026-08-28T04:09:58.003619+00:00, sha 89f28ae3fa69)
  - homepage: https://www.dbgate.io (fetched 2026-08-29T08:34:41.007982+00:00, sha 2ce6c5ce29e3)
  - site_page: https://www.dbgate.io/features (fetched 2026-08-29T08:34:41.012764+00:00, sha bb16d6544f98)
  - site_page: https://www.dbgate.io/features/data-browser (fetched 2026-08-29T08:34:41.017515+00:00, sha a353f6533353)
  - site_page: https://www.dbgate.io/features/query (fetched 2026-08-29T08:34:41.019258+00:00, sha cb3dbe554625)
  - site_page: https://www.dbgate.io/features/database-chat (fetched 2026-08-29T08:34:41.020915+00:00, sha d4f0b40ac790)
  - site_page: https://www.dbgate.io/features/import-export (fetched 2026-08-29T08:34:41.022624+00:00, sha f6d9a018c3dd)
  - site_page: https://www.dbgate.io/features/administration (fetched 2026-08-29T08:34:41.024316+00:00, sha a501a66081c7)
  - site_page: https://www.dbgate.io/features/designer (fetched 2026-08-29T08:34:41.025992+00:00, sha 792afd06bbb0)
  - registry_npm: https://registry.npmjs.org/dbgate (fetched 2026-08-29T08:34:41.027534+00:00, sha b8464fb1b6e7)
- Data as of 2026-08-30T08:39:29.467469+00:00.