
database client · DbGate
DbGate
Open-source database client for SQL and NoSQL engines on Windows, macOS and Linux, with Premium at $120 a year.
In short
- The Community edition is free and open source under GPL-3.01,3.
- Premium for one person costs $120 a year, or $12 a month1,14.
- Premium adds the visual query designer, structure compare and AI tools5,10,11,12.
- The docs name MySQL, PostgreSQL, SQL Server, Oracle, SQLite, MariaDB, MongoDB and Redis5.
- Version 7.3.2 was released on 8 October 20264.
DbGate suits developers who want a free open-source client that also covers MongoDB and Redis, and who may pay $120 a year for the query designer and compare tools1,5,10,12. The catch: the vendor's pages name no BigQuery or Snowflake support, no query plan viewer and no perpetual licence for Premium, and the vendor's GitHub lists seven security advisories5,14,15.
Best for: Developers who want a free open-source client, with paid tools for query design and compare.
Where the points come from
Systems 6 of 6 points
| Rule | What is published | Points |
|---|---|---|
| Other systems | macOS, LinuxThe download page offers Premium installers for macOS and an AppImage for Linux13. | 6 / 6 |
Databases 19 of 27 points
| Rule | What is published | Points |
|---|---|---|
| Main SQL engines | PostgreSQL, MySQL or MariaDB, SQL Server, Oracle, SQLiteThe docs and home page list MySQL, PostgreSQL, SQL Server, Oracle, SQLite and MariaDB5,2. | 15 / 15 |
| NoSQL and cloud engines | MongoDB, RedisThe docs name MongoDB and Redis; BigQuery and Snowflake are not named5. | 4 / 8 |
| JDBC or ODBC drivers | Not publishedNot published on the vendor's docs overview or features pages5,7. | 0 / 4 |
Connections and trust 17 of 17 points
Tools 25 of 29 points
| Rule | What is published | Points |
|---|---|---|
| SQL code completion | YesThe SQL editor suggests tables, columns and keywords from the connected schema9. | 4 / 4 |
| Visual query builder | YesThe query designer builds SQL by adding tables to a canvas and picking columns; Premium only10. | 3 / 3 |
| ER diagrams | YesThe docs say ER diagrams show tables and their relations for a whole database or chosen tables; only advanced settings are Premium16. | 4 / 4 |
| Schema or data compare | YesCompare and deploy models compares structure and synchronises databases; Premium only12. | 4 / 4 |
| Import from CSV or Excel | YesThe docs say a file source such as CSV can be imported into a table; the features page lists CSV and Excel17,8. | 4 / 4 |
| Export formats | CSV, Excel, JSONThe import and export page lists CSV, Excel and JSON among its formats8. | 3 / 3 |
| Query plan viewer | Not publishedNot published on the vendor's SQL editor docs or features pages7,9. | 0 / 4 |
| AI assistant | YesDatabase chat writes SQL and Explain gives fixes for errors; Premium and Team Premium, no beta label11. | 3 / 3 |
Price 12 of 21 points
| Rule | What is published | Points |
|---|---|---|
| Free edition | YesCommunity is free; the README says it is free to use for any purpose3. | 6 / 6 |
| Perpetual licence | Not publishedNot published on the vendor's purchase page, which lists only yearly and monthly subscriptions14. | 0 / 5 |
| Cheapest paid plan | $120/yrPremium for one user, $120 billed yearly1,14. | 6 / 10 |
The rule behind each line: how we score database clients.
Plans and prices
As the vendor lists them, before tax. Prices are in US dollars unless the plan shows euros; the points use US dollars, with euros converted at the ECB rate.
| Plan | Price as listed | Per month | Notes |
|---|---|---|---|
| Community1 person | Free1 | $0 | Open source; unlimited connections; desktop and web apps |
| Premium1 person | $120/year or $12/month1,14 | $10 | Adds query designer, data compare, AI tools; 30-day trial |
| Team Premium2 or more users | $150/user/year or $15/user/month1 | $12.50 | Adds administration, external identity providers and Azure Managed Identity; 2 or more users |
Premium is $12 a month or $120 a year, with a free 30-day trial1,14.
Strengths
Limits
- The visual query designer, structure compare and AI tools are Premium only10,11,12.
- Premium is sold as a $120 yearly or $12 monthly subscription; no perpetual licence is described14.
- The docs overview does not name BigQuery or Snowflake5.
- The vendor's GitHub lists seven published security advisories, three rated critical on 20 May 202615.
Concerns on record
- The vendor's GitHub security page lists seven published advisories for DbGate, including three rated critical on 20 May 2026 such as unauthenticated remote code execution via the JSON script runner15.
What DbGate says
Vendor claims. We show them, but they earn no points.
- DbGate says it works everywhere, on Windows, Linux, Mac and in a web browser, without compromises in features3.
Other database clients
- 1
DBeaverDevelopers and analysts who work with many database engines91/100$113/yrcheapest paid plan - 2
DbVisualizerDevelopers who connect to many engines and want a free edition for basic work84/100$199/yrcheapest paid plan - 3
Beekeeper StudioDevelopers who want a multi-engine client with a free open-source edition81/100$108/yrcheapest paid plan - 4
DataGripDevelopers who write a lot of SQL and want an IDE-style editor81/100$121.93/yrcheapest paid plan
Sources
- DbGate editions and pricing, DbGate. Accessed 8 Oct 2026.
- DbGate, DbGate. Accessed 8 Oct 2026.
- dbgate/dbgate, GitHub. Accessed 8 Oct 2026.
- Releases, dbgate/dbgate, GitHub. Accessed 8 Oct 2026.
- DbGate documentation, DbGate. Accessed 8 Oct 2026.
- Getting Started, DbGate docs. Accessed 8 Oct 2026.
- DbGate features, DbGate. Accessed 8 Oct 2026.
- Import and export, DbGate. Accessed 8 Oct 2026.
- SQL editor, DbGate docs. Accessed 8 Oct 2026.
- Query designer, DbGate docs. Accessed 8 Oct 2026.
- AI features, DbGate docs. Accessed 8 Oct 2026.
- Database operations, DbGate docs. Accessed 8 Oct 2026.
- Download DbGate Premium, DbGate. Accessed 8 Oct 2026.
- Purchase DbGate Premium, DbGate. Accessed 8 Oct 2026.
- Security advisories, dbgate/dbgate, GitHub. Accessed 8 Oct 2026.
- ER diagrams, DbGate docs. Accessed 8 Oct 2026.
- Export and import, DbGate docs. Accessed 8 Oct 2026.
Website: dbgate.io · Markdown version · We are not affiliated with DbGate.