The AI SQL assistant generates queries from natural language using database metadata you can access. It supports follow-ups, history, sharing, streaming, cancellation, and recovery after a refresh. Generated SQL can be inserted into the editor for manual execution. (#405)
Administrators can configure OpenAI-compatible endpoints, DeepSeek, Kimi, MiniMax, and DashScope, test the connection, and store credentials encrypted. (#405)
Elasticsearch support covers 7.10+, 8.x, and 9.x, with queries and writes on exact indexes, aggregations, index and mapping or settings management, and a console-style request editor. It integrates permissions, auditing, masking, and export. Eligible document queries can paginate automatically on 7.12+. (#391)
YashanDB supports Oracle and MySQL compatibility modes for connections, object browsing, SQL queries, and structure management. Thanks to @ComingWen. (#388)
The SQL workspace can connect, disconnect, and reconnect without losing tabs, drafts, or results. Disconnecting interrupts queries and rolls back uncommitted manual transactions. Reconnecting leaves prior SQL execution to the user. (#398)
The SQL workspace shows loading placeholders by section and keeps existing DataSources and objects visible while refreshing. (#398)
Users without DataSource access can request permissions or see how to contact an administrator from the SQL workspace. (#398)
The DataSource list shows environments, with tooltips for long names and horizontal scrolling. (#398)
Automatically executed tickets connect to the selected database and schema instead of accidentally using the default database on engines such as PostgreSQL. Thanks to @sunjiajie. (#279)
Ticket lists and details identify applicants by their unique login when no display name is set. (#407)
Docker deployments continue writing application logs after log rotation. (#398)
MySQL table details load when a table has a functional unique index, and index access methods no longer confuse SQL review's index classification. (#398)
Automatic ticket execution reports failures when a rollback fails and can still report its final state when resetting autocommit is unnecessary. (#398)
Packaging failures for automatically executed tickets now report scheduler errors and the specific cause. (#398)