Yandex WebSQL release notes: 2025

SeptemberSeptember

New featuresNew features

1. Integrated an AI assistant into WebSQL. You can use it to generate queries to databases, analyze their structure, as well as to fix and optimize queries directly from the editor.

2. Added the ability to use the ISODate, UUID, and ObjectId functions in MongoDB. You can use these functions to work with dates, create unique IDs, and generate primary keys for documents.

3. Added the authentication_source parameter that enables selecting a database in the cluster to use for authentication when connecting to MongoDB.

ImprovementsImprovements

1. Removed the error message that appeared on successful connection to a database with a schema export error. This way, you will still be able to query the database.

2. In the management console, added links to the Privacy policy and Terms of use sections to the left-hand menu.

Fixed issuesFixed issues

1. Fixed the issue of random page refreshes when pressing arrow keys and Enter.

2. Fixed the incorrect behavior of the Readonly user management setting in ClickHouse®.

3. Fixed the incorrect behavior of the sha256_password authentication plugin in MySQL®.

4. Fixed the error where catalog data did not load when opening WebSQL from the management console.

AugustAugust

Fixed issuesFixed issues

Fixed incorrect autocompletion of queries when the editor text contained emoji.

JulyJuly

New featuresNew features

1. Added a notification with a link to a survey that collects WebSQL feedback. Please, complete it.

2. The trial feature to run subqueries within a muli-query became basic for all WebSQL users.

3. The query editor now stores the last query written to keep the query in the editor in case of service overloads or after a long break.

4. Added the automatic substitution of the default CA certificate for external connections.

ImprovementsImprovements

1. Improved the query performance reliability.

2. Fixed the appearance of large data amounts in the query results.

JuneJune

New featuresNew features

1. Added support for Greenplum® connections.

2. Added support for pagination in the query editor.

3. Added an option to share a query link from the editor.

ImprovementsImprovements

1. Added support for materialized views and partitioned tables in PostgreSQL connections.

2. Added info on table columns in the connection tree.

3. Improved command autocompletion in Yandex StoreDoc connections.

MayMay

ImprovementsImprovements

1. The editor now features improved query formatting.

2. In multi-queries, metadata is now displayed separately for each subquery.

Fixed issuesFixed issues

1. Fixed an issue with the connection creation dialog rendering.

2. Fixed incorrect rendering of empty values in the query results table.

3. Fixed incorrect editor fonts in Windows.

AprilApril

New featuresNew features

1. You can now resize the columns in the query output section.

2. Added the Open support chat item to the Support center menu.

Fixed issuesFixed issues

1. Fixed timestamp operations for all databases: the database time zone is now used.

2. After a query is run, the cursor focuses on the query editor.

MarchMarch

New featuresNew features

1. Now you can run subqueries within a muli-query in all available database types.

2. Added support for Yandex StoreDoc and Yandex Managed Service for Trino connections (Yandex Managed Service for Trino is currently at the Preview stage).

FebruaryFebruary

New featuresNew features

Now you can run multi-queries for ClickHouse® databases.

Fixed issuesFixed issues

Fixed an issue where certain authors were shown as unknown users in the query history.

JanuaryJanuary

New featuresNew features

1. Added an option to export query results in XLS format.
2. Added an option to attach a screenshot when creating a support ticket.
3. Added a setting for the connection tree to display only those connections the user has access to.
4. Added query formatting to the query editor.
5. Migrated Yandex Cloud connections to Valkey™ managed database clusters to Valkey™.

ImprovementsImprovements

Fixed the behavior of the Share query button where it appeared before running a query.

20242024

NovemberNovember

ImprovementsImprovements

1. Added an icon to the list of connections to indicate the connection control type, automatic or manual .

2. Now you can use WebSQL even if you were unable to export clusters of a certain database type. The successfully exported clusters will be available.

3. Reduced the time for getting the PostgreSQL cluster structure.

4. In ClickHouse®, supported autocompletion of the GRANT and REVOKE commands and improved autocompletion of the SELECT, CREATE, DELETE, ALTER, and INSERT commands.

Fixed issuesFixed issues

1. Fixed an issue when working with tables whose names begin with a capital letter in PostgreSQL.

2. Fixed an issue with displaying numeric data types as strings in ClickHouse®.

3. Fixed the duplication of Valkey™ in the Database type list when creating an external connection.

OctoberOctober

ImprovementsImprovements

1. You can now share the result right after the query was executed.

2. Reduced processing time for fast queries.

SeptemberSeptember

New featuresNew features

1. Now you can connect to non-sharded Valkey™ clusters.

2. Added the websql.auditor, websql.executedQueries.auditor, and websql.savedQueries.auditor roles to view query metadata and related access permissions.

ImprovementsImprovements

1. Added the experiment of displaying connections as database users.

2. PostgreSQL tables are now displayed as database objects even if the user does not have access to these tables.

3. Added the display of empty PostgreSQL schemas to the list of database objects.

Fixed issuesFixed issues

The backend query timeout was set to 25 seconds.

AugustAugust

ImprovementsImprovements

1. Added access permission management interfaces for completed and saved queries.

2. Integrated cloud-based time settings.

3. Added the modal window interface for contacting technical support.

4. Now only the tables the user has access to are displayed in PostgreSQL databases.

5. Added statistics for completed queries.

Fixed issuesFixed issues

Fixed the filter workflow on the completed queries page.

JulyJuly

ImprovementsImprovements

1. The query history displays authors of completed queries.

2. Enabled running queries without exporting the connection structure.

3. Added support for long-running database queries.

4. Added information about databases and certificates to the connection card.

Fixed issuesFixed issues

1. Fixed an error when running all DML queries in a ClickHouse® cluster.

2. Fixed the query editor issue for Safari version 15.

JuneJune

New featuresNew features

1. The Connections tab now displays the Yandex Cloud managed database clusters from the selected folder available to the user. This speeds up the process of creating connections to these clusters, as most of the cluster information is populated automatically. Also updates were made to the forms for creating connections.

2. WebSQL is the first service integrated with Yandex MetaData Hub. All connections are stored in Connection Manager, but you can also manage (create, delete, and edit) them from the WebSQL interface. All changes you make in WebSQL are displayed in Connection Manager and vice versa.

3. You can now publish saved and historical queries. Once published, the query will be available to all folder users. This action cannot be undone — you can only delete the query you published. Roles allow you to manage user access to a published query: you can grant permissions for viewing and editing a query or managing its access permissions.

4. The WebSQL interface now allows you to share links to various entities. For example, you can send a link to a connection, saved query you published, or page with access permissions for a published query to your colleague.

Fixed issuesFixed issues

Improved user query storage mechanism: queries are now linked to the user's account. No matter what device or browser was used to access WebSQL, the user will see all their previous queries.

MayMay

ImprovementsImprovements

Updated the service favicon .

Fixed issuesFixed issues

Fixed an error on connection to a database in which no tables or schemas (for PostgreSQL) had been created.

AprilApril

Fixed issuesFixed issues

Fixed a bug that caused the interface to become unavailable when selecting a high-contrast theme in the management console.

MarchMarch

New featuresNew features

1. Added viewing sequence information in PostgreSQL database schemas.

2. In the query editor, added role tips for PostgreSQL databases.

FebruaryFebruary

New featuresNew features

1. New improved autocompletion feature for SQL queries in the query editor.

2. If the table has indexes or triggers, information about them will appear in separate table information sections.

3. The autocompletion feature provides information about indexes and triggers.

Fixed issuesFixed issues

Fixed the incorrect display of variables when opening saved queries.

JanuaryJanuary

New featuresNew features

1. Grouping by date in the query history.

2. Visual settings of the editor.

3. Managing the transfer of the WebSQL SSL certificate upon connection.

4. Support for views in the database structure.

5. Grouping by connection type: external, demo, and Yandex Cloud connections.

6. Simplified modal window for reconnecting.