YDB CLI changelog

Version 2.26.0

Released on September 25, 2025. To update to version 2.26.0, select the Downloads section.

Features

  • Added the --no-merge and --no-cache options to the ydb monitoring healthcheck command.
  • Added query compilation time statistics to the ydb workload * run commands.
  • Added the --retries option to the ydb tools restore command, allowing to set the number of retries for every upload data request.
  • (Requires server v25.4+) Added the --replace-sys-acl option to the ydb tools restore command, which specifies whether to replace the ACL for system objects.

Version 2.25.0

Released on September 1, 2025. To update to version 2.25.0, select the Downloads section.

Features

  • Added final execute statistics to the ydb workload * run commands.
  • Added the --start-offset option to the ydb topic read command, which specifies a starting position for reading from the selected partition.
  • (Requires server v25.3+) Added a new paths approach in the ydb export s3 and ydb import s3 commands with the new --include option instead of the --item option.
  • (Requires server v25.3+) Added support for encryption features in the ydb export s3 and ydb import s3 commands.
  • (Requires server v25.3+) (Experimental) Added the ydb admin cluster bridge commands to manage a cluster in the bridge mode: list, switchover, failover, takedown, rejoin.

Improvements

  • User and password authentication options are now parsed independently, allowing them to be sourced from different priority levels. For example, the username can be specified via the --user option while the password is retrieved from the YDB_PASSWORD environment variable.
  • Changed the default logging level from EMERGENCY to WARN for commands that support multiple verbosity levels.

Backward incompatible changes

  • Removed the --float-mode option from the ydb workload tpch run and ydb workload tpcds run commands. Float mode is now inferred automatically from the table schema created during the init phase.

Bug fixes

  • Fixed a bug where the ydb import file csv command with the --newline-delimited option could get stuck when processing input with invalid data.
  • Fixed an issue with the progress bar display in the ydb workload clickbench import files command: incorrect percentage values and excessive line breaks caused duplicate progress lines.
  • Fixed a bug where the ydb workload topic write command could crash with an Unknown AckedMessageId error due to an internal race condition.
  • Fixed decimal type comparison in the ydb workload * run commands.

Version 2.24.1

Released on July 28, 2025. To update to version 2.24.1, select the Downloads section.

Bug fixes

  • Fixed a bug where the ydb tools dump command silently skipped schema objects of unsupported types and created empty directories for them in the destination folder on the file system.

Version 2.24.0

Released on July 23, 2025. To update to version 2.24.0, select the Downloads section.

Features

  • Added the ability for the ydb workload tpch and ydb workload tpcds commands to use a fractional value for the --scale option, specifying a percentage of the full benchmark's data size and workload.
  • Added the ydb workload tpcc check command to check TPC-C data consistency.

Improvements

  • Changed the default storage type in ydb workload * init commands to column (from row), and the default datetime mode to datetime32 (from datetime64).

Bug fixes

  • Fixed an issue where the ydb import file csv command could get stuck during execution.

Version 2.23.0

Released on July 16, 2025. To update to version 2.23.0, select the Downloads section.

Features

  • Added the ydb workload tpcc command to run a TPC-C benchmark.
  • Added the ydb workload vector select command to benchmark vector index performance and recall.
  • Added the ydb tools infer csv command to generate a CREATE TABLE SQL query from a CSV data file.

Improvements

  • Enhanced processing of special values (null, /dev/null, stdout, cout, console, stderr, and cerr) for the --output option in the ydb workload * run commands.
  • The ydb workload commands now work with absolute paths for database scheme objects.
  • Improvements in the ydb interactive mode:
    • Added server connection check and hotkeys description.
    • Improved inline hints.
    • Added table column names completion.
    • Added schema caching.

Bug fixes

  • Fixed an issue where the ydb tools restore command was not working on Windows.

Version 2.22.1

Released on June 17, 2025. To update to version 2.22.1, select the Downloads section.

Bug fixes

  • Fixed an issue where the certificate was not read from a file if the path to the file was specified in the profile with the ca-file field.
  • Fixed an issue where the ydb workload query import and ydb workload clickbench import files commands displayed number of rows instead of number of bytes in progress state.

Version 2.22.0

Released on June 4, 2025. To update to version 2.22.0, select the Downloads section.

Features

  • Added scheme object names completion in interactive mode.
  • Enhanced the capabilities of the ydb workload query command: added ydb workload query init, ydb workload query import, and ydb workload query clean commands, and modified the ydb workload query run command. Using these commands, you can initialize tables, populate them with data, perform load testing, and clean up the data afterwards.
  • Added the --threads option to the ydb workload clickbench run, ydb workload tpch run, and ydb workload tpcds run commands. This option allows to specify the number of threads sending the queries.
  • (Requires server v25.1+) (Experimental) Added the ydb admin cluster config version command to show the configuration version (V1/V2) on nodes.

Backward incompatible changes

  • Removed the --executor option from the ydb workload * run commands. The generic executor is now always used.

Bug fixes

  • Fixed an issue where the ydb workload * clean commands were deleting all contents from the target directory, instead of just the tables created by the init command.

Version 2.21.0

Released on May 22, 2025. To update to version 2.21.0, select the Downloads section.

Features

  • Added the --no-discovery global option, allowing to skip discovery and connect to user-provided endpoint directly.
  • Added new options for workload commands:
    • Added the --scale option to the ydb workload tpch init and ydb workload tpcds init commands to set the percentage of the benchmark's data size and workload to use, relative to full scale.
    • Added the --retries option to the ydb workload <clickbench|tpch|tpcds> run commands to specify maximum retry count for every request.
    • Added the --partition-size option to the ydb workload <clickbench|tpcds|tpch> init commands to set maximum partition size in megabytes for row tables.
    • Added date range parameters (--date-to, --date-from) to the ydb workload log run command to support uniform primary key distribution.
  • Enhanced backup and restore functionality:
    • Added the --replace and --verify-existence options to the ydb tools restore command to control the removal of existing objects that match those in the backup before restoration.
    • Improved the ydb tools dump command by not saving replica tables with ASYNC REPLICATION and their changefeeds to local backups. It prevents duplication of changefeeds and reduces the amount of space the backup takes on disk.
  • Enhanced CLI usability:
    • Detailed help message (-hh) now shows the whole subcommand tree.
    • Added automatic pair insertion for brackets in ydb interactive mode.
    • Added support for files with BOM (Byte Order Mark) in the ydb import file commands.
  • (Requires server v25.1+) (Experimental) Improved the ydb debug latency command:
    • Added the --min-inflight parameter to set minimum number of concurrent requests (default: 1).
    • Added the --percentile option to specify custom latency percentiles.
    • Enhanced the output with additional gRPC ping measurements.

Bug fixes

  • The ydb operation get command now properly handles running operations.
  • Fixed errors in the ydb scheme rmdir command:
    • Fixed an issue where the command was trying to delete subdomains.
    • Fixed deletion order: external tables are now deleted before external data sources due to possible dependencies between them.
    • Added support for coordination nodes in recursive removal.
  • Fixed return code of the ydb workload * run --check-canonical command when results differ from canonical ones.
  • Fixed an issue where CLI was attempting to read parameters from stdin even without available data.
  • (Requires server v25.1+) (Experimental) Fixed an authorization error in the ydb admin database restore command when restoring from a backup containing multiple database administrator accounts.

Version 2.20.0

Released on March 5, 2025. To update to version 2.20.0, select the Downloads section.

Features

  • Added topics support in the ydb tools dump and ydb tools restore commands. In this release, only topic settings are retained; messages are not included in the backup.
  • Added coordination nodes support in the ydb tools dump and ydb tools restore commands.
  • Added the new ydb workload log import generator command.
  • Added new global options for client certificates in SSL/TLS connections:
    • --client-cert-file: File containing a client certificate for SSL/TLS connections (PKCS#12 or PEM-encoded).
    • --client-cert-key-file: File containing a PEM-encoded private key for the client certificate.
    • --client-cert-key-password-file: File containing a password for the private key (if the key is encrypted).
  • Queries in the ydb workload run command are now executed in random order.
  • (Requires server v25.1+) Added support for external data sources and external tables in the ydb tools dump and ydb tools restore commands.
  • (Experimental) Added the ydb admin node config init command to initialize a directory with node configuration files.
  • (Requires server v25.1+) (Experimental) Added the ydb admin cluster config generate command to generate a dynamic configuration file from a cluster static configuration file.
  • (Requires server v25.1+) (Experimental) Added the command ydb admin cluster dump and the command ydb admin cluster restore for dumping all cluster-level data. These dumps contain a list of databases with metadata, users, and groups but do not include schema objects.
  • (Requires server v25.1+) (Experimental) Added the ydb admin database dump and ydb admin database restore commands for dumping all database-level data. These dumps contain database metadata, schema objects, their data, users, and groups.
  • (Requires server v25.1+) (Experimental) Added the --dedicated-storage-section and --dedicated-cluster-section options to the ydb admin cluster config fetch command, allowing cluster and storage config sections to be fetched separately.

Bug fixes

  • Fixed a bug where the ydb auth get-token command attempted to authenticate twice: once while listing endpoints and again while executing the actual token request.
  • Fixed a bug where the ydb import file csv command was saving progress even if a batch upload had failed.
  • Fixed a bug where some errors could be ignored when restoring from a local backup with the ydb tools restore command.
  • Fixed a memory leak in the data generator for the ydb workload tpcds benchmark.

Version 2.19.0

Released on February 5, 2025. To update to version 2.19.0, select the Downloads section.

Features

  • Added changefeeds support in the ydb tools dump and ydb tools restore commands.
  • Added CREATE TABLE text suggestion on schema error during the ydb import file csv command.
  • Added statistics output on the current progress of the query in the ydb workload command.
  • Added query text to the error message if a query fails in the ydb workload run command.
  • Added a message if the global timeout expired in the ydb workload run command.
  • (Requires server v25.1+) Added views support in the ydb export s3 and ydb import s3. Views are exported as CREATE VIEW YQL statements, which are executed on import.
  • (Requires server v25.1+) Added the --skip-checksum-validation option to the ydb import s3 command to skip server-side checksum validation.
  • (Requires server v25.1+) (Experimental) Added new options for the ydb debug ping command: --chain-length, --chain-work-duration, --no-tail-chain.
  • (Requires server v25.1+) (Experimental) Added new options for the ydb admin storage fetch command: --dedicated-storage-section and --dedicated-cluster-section.
  • (Requires server v25.1+) (Experimental) Added new options for the ydb admin storage replace command: --filename, --dedicated-cluster-yaml, --dedicated-storage-yaml, --enable-dedicated-storage-section and --disable-dedicated-storage-section.

Bug fixes

  • Fixed a bug where the arm64 YDB CLI binary was downloading the amd64 binary to replace itself during the ydb update command. To update already installed binaries to the latest arm64 version, YDB CLI should be reinstalled.
  • Fixed the return code of the ydb workload run command.
  • Fixed a bug where the ydb workload tpch import generator and ydb workload tpcds import generator commands were failing because not all tables had been created.
  • Fixed a bug with backslashes in the ydb workload commands paths on Windows.

Version 2.18.0

Released on December 24, 2024. To update to version 2.18.0, select the Downloads section.

Features

  • Added support for views in local backups: ydb tools dump and ydb tools restore. Views are backed up as CREATE VIEW queries saved in the create_view.sql files, which can be executed to recreate the original views.
  • Added new options to the ydb workload topic run command: --tx-commit-interval and --tx-commit-messages, allowing you to specify the interval between transaction commits in milliseconds or in the number of messages written, respectively.
  • Made the --consumer flag in the ydb topic read command optional. In the non-subscriber reading mode, the partition IDs must be specified with the --partition-ids option. In this case, the read is performed without saving the offset commit.
  • The ydb import file csv command now saves the import progress. Relaunching the import command will resume the process from the row where it was interrupted.
  • In the ydb workload kv and ydb workload stock commands, the default value of the --executer option has been changed to generic, which makes them no longer rely on the legacy query execution infrastructure.
  • Replaced the CSV format with Parquet for filling tables in the ydb workload benchmarks.
  • (Requires server v25.1+) (Experimental) Added new ydb admin storage command with fetch and replace subcommands to manage server storage configuration.

Backward incompatible changes

  • Replaced the --query-settings option with --query-prefix in the ydb workload * run command.

Bug fixes

  • Fixed a bug where the ydb workload * run command could crash in --dry-run mode.
  • Fixed a bug in the ydb import file csv where multiple columns with escaped quotes in the same row were parsed incorrectly.

Version 2.17.0

Released on December 4, 2024. To update to version 2.17.0, select the Downloads section.

Features

  • (Requires server v25.1+) (Experimental) Added the ydb debug ping command for performance and connectivity debugging.

Performance

Bug fixes

  • Fixed a bug in the table schema created by the ydb workload tpch command where the partsupp table contained an incorrect list of key columns.
  • Resolved an issue where the ydb tools restore command failed with the error "Too much data" if the maximum value of the --upload-batchbytes option was set to 16 MB.

Version 2.16.0

Released on November 26, 2024. To update to version 2.16.0, select the Downloads section.

Features

  • Improved throughput of the ydb import file csv command by up to 3 times.
  • Added support for running the stock benchmark with column-oriented tables.
  • Added support for ISO 8601–formatted timestamps in the ydb topic commands.
  • Added the --explain-ast option to the ydb sql command, which prints the query AST.
  • Added ANSI SQL syntax highlighting in interactive mode.
  • Added support for PostgreSQL syntax in the ydb workload tpch and ydb workload tpcds benchmarks.
  • Introduced the -c option for the ydb workload tpcds run command to compare results with expected values and display differences.
  • Added log events for the ydb tools dump and ydb tools restore commands.
  • Enhanced the ydb tools restore command to display error locations.

Backward incompatible changes

  • Changed the default value of the ydb topic write command's --codec option to RAW.

Bug fixes

  • Fixed the progress bar in the ydb workload import command.
  • Resolved an issue where restoring from a backup using the --import-data option could fail if the table's partitioning had changed.

Version 2.10.0

Released on June 24, 2024. To update to version 2.10.0, select the Downloads section.

Features

  • Added the ydb sql command that runs over QueryService and can execute any DML/DDL command.

  • Added notx support for the --tx-mode option in the ydb table query execute command.

  • Added start and end times for long-running operation descriptions (export, import).

  • Added replication description support in the ydb scheme describe and ydb scheme ls commands.

  • Added big datetime types support: Date32, Datetime64, Timestamp64, Interval64.

  • ydb workload commands rework:

    • Added the --clear option to the init subcommand, allowing tables from previous runs to be removed before workload initialization.
    • Added the ydb workload * import command to prepopulate tables with initial content before executing benchmarks.

Backward incompatible changes

  • ydb workload commands rework:

    • The --path option was moved to a specific workload level. For example: ydb workload tpch --path some/tables/path init ....
    • The --store=s3 option was changed to --store=external-s3 in the init subcommand.

Bug fixes

  • Fixed colors in the PrettyTable format

Version 2.9.0

Released on April 25, 2024. To update to version 2.9.0, select the Downloads section.

Features

  • Improved query logical plan tables: added colors, more information, fixed some bugs.
  • The verbose option -v is supported for the ydb workload commands to provide debug information.
  • Added an option to run the ydb workload tpch command with an S3 source to measure federated queries performance.
  • Added the --rate option for ydb workload commands to control the transactions (or requests) per second limit.
  • Added the --use-virtual-addressing option for S3 import/export, allowing the switch to virtual hosting of buckets for the S3 path layout.
  • Improved the ydb scheme ls command performance due to listing directories in parallel.

Bug fixes

  • Resolved an issue where extra characters were truncated during line transfers in CLI tables.
  • Fixed invalid memory access in tools restore.
  • Fixed the issue of the --timeout option being ignored in generic and scan queries, as well as in the import command.
  • Added a 60-second timeout to version checks and CLI binary downloads to prevent infinite waiting.
  • Minor bug fixes.

Version 2.8.0

Released on January 12, 2024. To update to version 2.8.0, select the Downloads section.

Features

  • Added new ydb admin config and ydb admin volatile-config commands for cluster configuration management.
  • Added support for loading PostgreSQL-compatible data types by ydb import file csv|tsv|json command. Only for row-oriented tables.
  • Added support for directory load from an S3-compatible storage in the ydb import s3 command. Currently only available on Linux and Mac OS.
  • Added support for outputting the results of ydb table query execute, ydb yql and ydb scripting yql commands in the Apache Parquet format.
  • In the ydb workload commands, the --executer option has been added, which allows to specify which type of queries to use.
  • Added a column with median benchmark execution time in the statistics table of the ydb workload clickbench command.
  • (Experimental) Added the generic request type to the ydb table query execute command, allowing to perform DDL and DML operations, return with arbitrarily-sized results and support for MVCC. The command uses an experimental API, compatibility is not guaranteed.
  • (Experimental) In the ydb table query explain command, the --collect-diagnostics option has been added to collect query diagnostics and save it to a file. The command uses an experimental API, compatibility is not guaranteed.

Bug fixes

  • Fixed an error displaying tables in pretty format with Unicode characters.

  • Fixed an error substituting the wrong primary key in the command ydb tools pg-convert.

Version 2.7.0

Released on October 23, 2023. To update to version 2.7.0, select the Downloads section.

Features

Bug fixes

Version 2.6.0

Released on September 7, 2023. To update to version 2.6.0, select the Downloads section.

Features

Bug fixes

Version 2.5.0

Released on June 20, 2023. To update to version 2.5.0, select the Downloads section.

Features

  • For the ydb import file command, a parameter --timeout has been added that specifies the time within which the operation should be performed on the server.
  • Added a progress bar in commands ydb scheme rmdir --recursive and ydb import file.
  • Added the command ydb workload kv run read-rows, which loads the database with requests to read rows using a new experimental API call ReadRows (implemented only in the main branch), which performs faster key reading than select.
  • New parameters --warmup-time, --percentile, --topic have been added to the ydb workload topic, setting the test warm-up time, the percentile in the statistics output and the topic name, respectively.
  • Added the ydb workload tpch command to run the TPC-H benchmark.
  • Added the --ordered flag in the command ydb tools dump, which preserves the order by primary key in tables.

Performance

  • The data loading speed in the ydb import file command has been increased by adding parallel loading. The number of threads is set by the new parameter --threads.
  • A performance of the ydb import file json command has been increased by reducing the number of data copies.

Version 2.4.0

Released on May 24, 2023. To update to version 2.4.0, select the Downloads section.

Features

Version 2.3.0

Release date: May 1, 2023. To update to version 2.3.0, select the Downloads section.

Features

  • Added the interactive mode of query execution. To switch to the interactive mode, run ydb yql without arguments. This mode is experimental: backward compatibility is not guaranteed yet.
  • Added the ydb index rename command for atomic replacement or renaming of a secondary index.
  • Added the ydb workload topic command for generating the load that reads messages from topics and writes messages to topics.
  • Added the --recursive option for the ydb scheme rmdir command. Use it to delete a directory recursively, with all its content.
  • Added support for the topic and coordination node types in the ydb scheme describe command.
  • Added the --commit option for the ydb topic consumer command. Use it to commit messages you have read.
  • Added the --columns option for the ydb import file csv|tsv command. Use it as an alternative to the file header when specifying a column list.
  • Added the --newline-delimited option for the ydb import file csv|tsv command. Use it to make sure that your data is newline-free. This option streamlines import by reading data from several file sections in parallel.

Bug fixes

  • Fixed the bug that resulted in excessive memory and CPU utilization when executing the ydb import file command.

Version 2.2.0

Release date: March 3, 2023. To update to version 2.2.0, select the Downloads section.

Features

  • Fixed the error that didn't allow specifying supported compression algorithms when adding a topic consumer.
  • Added support for streaming YQL scripts and queries based on options transferred via stdin.
  • You can now use a file to provide YQL query options
  • Password input requests are now output to stderr instead of stdout.
  • You can now save the root CA certificate path in a profile.
  • Added a global option named --profile-file to use the specified file as storage for profile settings.
  • Added a new type of load testing: ydb workload clickbench.

Version 2.1.1

Release date: December 30, 2022. To update to version 2.1.1, select the Downloads section.

Improvements

  • Added support for the --stats option of the ydb scheme describe command for column-oriented tables.
  • Added support for Parquet files to enable their import with the ydb import command.
  • Added support for additional logging and retries for the ydb import command.

Version 2.1.0

Release date: November 18, 2022. To update to version 2.1.0, select the Downloads section.

Features

  • You can now create a profile non-interactively.
  • Added the ydb config profile update and ydb config profile replace commands to update and replace profiles, respectively.
  • Added the -1 option for the ydb scheme ls command to enable output of a single object per row.
  • You can now save the IAM service URL in a profile.
  • Added support for username and password-based authentication without specifying the password.
  • Added support for AWS profiles in the ydb export s3 command.
  • You can now create profiles using stdin. For example, you can pass the YC CLI yc ydb database get information command output to the ydb config profile create command input.

Bug fixes

  • Fixed the error when request results were output in JSON-array format incorrectly if they included multiple server responses.
  • Fixed the error that disabled profile updates so that an incorrect profile was used.

Version 2.0.0

Release date: September 20, 2022. To update to version 2.0.0, select the Downloads section.

Features

  • Added the ability to work with topics:

    • ydb topic create: Create a topic.
    • ydb topic alter: Update a topic.
    • ydb topic write: Write data to a topic.
    • ydb topic read: Read data from a topic.
    • ydb topic drop: Delete a topic.

  • Added a new type of load testing:

    • ydb workload kv init: Create a table for kv load testing.
    • ydb workload kv run: Apply one of three types of load: run multiple UPSERT sessions, run multiple INSERT sessions, or run multiple sessions of GET requests by primary key.
    • ydb workload kv clean: Delete a test table.

  • Added the ability to disable current active profile (see the ydb config profile deactivate command).

  • Added the ability to delete a profile non-interactively with no commit (see the --force option under the ydb config profile remove command).

  • Added CDC support for the ydb scheme describe command.

  • Added the ability to view the current DB status (see the ydb monitoring healthcheck command).

  • Added the ability to view authentication information (token) to be sent with DB queries under the current authentication settings (see the ydb auth get-token command).

  • Added the ability for the ydb import command to read data from stdin.

  • Added the ability to import data in JSON format from a file or stdin (see the ydb import file json command).

Improvements

  • Improved command processing. Improved the accuracy of user input parsing and validation.

Version 1.9.1

Release date: June 25, 2022. To update to version 1.9.1, select the Downloads section.

Features

  • Added the ability to compress data when exporting it to S3-compatible storage (see the --compression option of the ydb export s3 command).
  • Added the ability to manage new YDB CLI version availability auto checks (see the --disable-checks and --enable-checks options of the ydb version command).
Previous
Yandex Enterprise Database
Next
Security changelog