Connectivity and Infrastructure:
- Added connectors to most of the relational databases from the DBeaver ecosystem.
- Enabled full compatibility with DBeaver Desktop projects. Database connection configurations created in DBeaver can be reused in dbvr.
- Implemented data sources management: creation, deletion, and renaming of database connections directly via CLI.
- Added the move command to move the datasource from project to project.
- Implemented project management: creation, deletion, and renaming of projects.
- Added the ability to set the default project in the workspace using the command.
SQL Execution:
- Added the ability to execute queries directly via CLI.
- Implemented intelligent output formatting for query results:
- SELECT queries display results in a readable, text-based table.
- INSERT, UPDATE, DELETE queries show concise operation summaries (e.g., "25 Rows updated")
- Enabled export of query results to local file systems into different formats (CSV, JSON, XML, TXT, and more).
- Added support for executing multi-statement script files with sequential processing and consistent error reporting.
- Added the --disable-output parameter for SQL query execution command to skip the output part after the command execution.
- Added the --print-queries parameter for SQL query execution command to show the query as the output parameter.
Additional commands:
- Added comprehensive CLI help system (dbvr --help, dbvr <command> --help) with parameter descriptions. Marked required parameters at the top, removed internal settings, and added usage examples.
- Added metadata exploration commands. Users can list database components and retrieve object definitions directly from the terminal. This capability allows teams to inspect database structures without opening a separate application.
- Added a -stateless flag for headless mode. Users can run the application without local state storage and disable automatic driver updates.