Version 6.5.0 - DbGate cloud, Firebird support

Published: 2025-06-17

I am glad to announce new DbGate release, 6.5. This release brings important changes, which could really simplify your life with databases.

DbGate Cloud — Built for Teams, Designed for Trust

Collaborate effortlessly with your team using cloud-stored connections, SQL scripts, ER diagrams, and other DbGate objects. DbGate Cloud keeps your workspace synchronized and ready—whether you’re solo or part of a distributed team.

All data is stored securely, with privacy and access control at the core.

Premium Edition users enjoy unlimited access to all cloud features. The Community Edition includes limited cloud functionality (up to 5 connections, 5 SQL files, and no shared folders). You could use DbGate cloud without limitations in Premium edition.

DbGate cloud also offer public knowledge base of various SQL scripts and charts, for database performance tuning tasks.

Support of Firebird database

We added support for a new database engine – Firebird SQL. Firebird is a lightweight, open-source relational database that offers powerful features such as stored procedures, triggers, and full ACID compliance. It is known for its small footprint, high performance, and ease of deployment, making it suitable for both embedded and enterprise-level applications. With Firebird support, you can now connect, query, and manage Firebird databases alongside your other data sources.

Charts from query results

DbGate has complete new charting engine. Charts are automatically created from query result. Of course, you could configure everything, if you are not satisfied with auto-detected measures. Chart definition is saved to the begining of SQL query (as SQL front matter), so you will see the same chart after reopening saved SQL query.

Full changelog after 6.4.0 release

6.5.0

ADDED: DbGate cloud - online storage for connections, SQL scripts and other objects
ADDED: Public knowledge base - common SQL scripts for specific DB engines (table sizes, index stats etc.)
ADDED: Query results could be visualised in charts (Premium)
REMOVED: Chart from selection, active charts - replaced by query result charts
ADDED: FirebirdSQL support
ADDED: SQL front matter - properties of SQL script
ADDED: Auto-execute SQL script on open (saved in SQL front matter)
CHANGED: Smaller widget icon panel
CHANGED: Applications and Single-connection mode removed from widget icon panel
CHANGED: Temporarily disabled MongoDB profiler support
FIXED: Pie chart distorted if settings change #838
FIXED: SQL server generated insert statement should exclude computed and timestamp columns #1111
ADDED: Added option “Show all columns when searching” #1118
ADDED: Copy cells/rows (e.g. column names) from Structure view #1119
ADDED: Setting “Show table aliases in code completion” #1122
FIXED: Vulnerability - check file paths in web version
FIXED: Very slow render of tables with very log cells

6.4.2

ADDED: Source label to docker container #1105
FIXED: DbGate restart needed to take effect after trigger is created/deleted on mariadb #1112
ADDED: View PostgreSQL query console output #1108
FIXED: Single quote generete MySql error #1107
ADDED: Ability to limit query result count #1098
CHANGED: Correct processing of bigint columns #1087 #1055 #583
CHANGED: Improved and optimalized algorithm of loading redis keys #1062, #1034
FIXED: Fixed loading Redis keys with :: in key name