Version 6.2.0 - AI Assistant, Cassandra support

I am happy to announce new release of DbGate - 6.2.0.

This release brings two important highlights:

  • Long awaited Apache Cassandra support (for all editions)
  • AI Assistant for query console (for Premium only)

AI Assistant (Premium)

AI assistant in DbGate helps you to create and modify SQL queries. It uses internally LLM gpt-4o-mini from OpenAI. Of course, you could open ChhatGPT application and ask for the query directly, but DbGate’s integration knows underlying DB model - table and column names, so result query will better fit to your database.

As a first step, DbGate asks you for your consent about sending table and columns names to DbGate’s AI service - wihtout this AI assistant will now work. We respect your privacy, which is why DbGate will never send any of your database information anywhere without your consent.

After this, AI assistant offers 3 jobs:

  • Text to SQL - you write query in natural language, DbGate will generate SQL query respecting current database schema
  • Complete SQL on cursor - DbGate will try to generate next fragment of your query
  • Make changes on your SQL - in case you have already any query, you could write task in natural language and DbGate will generate new query

More about AI assistant

AI assistant

Apache Cassandra support

Apache Cassandra support is for all editions - is part of free and open-source product. We support almost all scenarious as in other databases:

  • Data browsing, filtering and edition
  • Table editor
  • Data import and export

Cassandra has lot of specifics, eg. it doesn’t support foreign keys - so master/detail views and lookups will not work.

Team premium edition improvements

We also made some improvements and bug fixes for team premium edition and administration interface. Also there are new posibilities, how to configure internal database (eg. you use Azure managed identity). Azure managed identity is also supported for regular Azure SQL connections under Team Premium.

Full changelog after 6.1.0 version

6.2.0

  • ADDED: Query AI Assistant (Premium)
  • ADDED: Cassandra database support
  • ADDED: XML cell data view
  • FIXED: Filtering by value in Oracle #1009
  • FIXED: Operand type clash: uniqueidentifier is incompatible with int #565
  • FIXED: UX in administration
  • FIXED: Error reporting of broken connections (sometimes it caused infinite loading of data grid)
  • ADDED: Azure managed identity support (Team Premium)
  • ADDED: Expanded JSON cell view
  • CHANGED: Open real executed query, when datagrid shows loading error

6.1.6

  • FIXED: Hotfix build process for premium edition

6.1.5

  • FIXED: Serious security hotfix (for Docker and NPM, when using LOGIN and PASSWORD environment variables or LOGIN_PASSWORD_xxx)
  • no changes for desktop app and for Team premium edition, when using storage DB

6.1.4

  • CHANGED: Show Data/Structure button in one place #1015
  • ADDED: Data view coloring (every second row) #1014
  • ADDED: Pin icon for tab in preview mode (#1013)
  • FIXED: Pin icon misplaced #1007
  • ADDED: Set client name when connecting to redis #1004
  • ADDED: Redis loading keys optimalization #1002
  • ADDED: Browse redis keys with preview with keyboard
  • FIXED: Cannot expand tables and views returned from search #1000
  • ADDED: Expand all/Collapse all/Expand document commands in MongoDB JSON view #976
  • ADDED: Configurable page size for MongoDB collection #976
  • ADDED: Redis - SSL connection
  • ADDED: Redis JSON format for String values #852

6.1.3

  • FIXED: Fulltext search now shows correctly columns and SQL code lines
  • ADDED: Configuration of SSH tunnel local host (IPv4 vs IPv6). Should fix majority of SSH tunnel problems
  • FIXED: Handled SSH tunnel connection error, now it shows error instead of connecting forever
  • ADDED: Support of triggers (SQLite)
  • ADDED: Create, drop trigger
  • ADDED: Support for MySQL scheduled events
  • FIXED: Cannot connect to DB using askUser/askPassword mode #995
  • FIXED: Filtering in Oracle #992
  • ADDED: Open table in raw mode #991, #962
  • ADDED: Introduced E2E Cypress tests, test refactor

6.1.1

  • ADDED: Trigger support (SQL Server, PostgreSQL, MySQL, Oracle)
  • FIXED: PostgreSQL and Oracle export #970
  • FIXED: Cursor Becomes Stuck When Escaping “Case” #954
  • CHANGED: Defualt search criteria for tables are names only
  • FIXED: Search in packed list