Core Functionality:
- Added command-line interface for universal database access, supporting relational, NoSQL, and cloud-native databases.
- Implemented consistent connection behavior across all environments, making dbvr suitable for scripts, servers, and automated workflows.
- Ensured cross-platform availability (Windows, macOS, Linux) with unified command syntax and configuration handling.
Database Connectivity:
- Added support for connections to most databases from the DBeaver ecosystem, with configurable drivers and authentication methods.
- Implemented datasources management: create, delete, and rename database connections directly via CLI.
- Enabled full compatibility with DBeaver Desktop projects — existing configured databases list in the workspace can be reused without conversion.
Cloud Storage Integration:
- Added the ability to read SQL scripts directly from cloud storage locations
- Enabled export output to cloud storage using standard URI schemes.
- Cloud credentials are managed externally via standard tools (AWS CLI, gcloud CLI, or environment variables)
SQL Execution & Results:
- Implemented intelligent output formatting for query results:
- SELECT queries display results as a readable text-based table presentation
-
- INSERT, UPDATE, DELETE queries show concise operation summaries (e.g., “25 Rows updated”)
- Added support for executing multi-statement script files with sequential processing and consistent error reporting.
Data Export:
- Integrated DBeaver-compatible exporters for flexible result formatting (CSV, JSON, XML, Excel, and more).
- Enabled export of query results to both local file paths and configured cloud storage locations using the -out parameter.
- Export options and format settings mirror the familiar DBeaver Desktop experience for seamless workflow transition.
Script & Project Management:
- Added commands to upload and download SQL script files for centralized version control and team collaboration.
- Implemented project management: the ability to create, delete, and rename projects to organize workspaces and connection groups.
- Supported execution of both local and remote script files with consistent parameter and environment handling.
General:
- Added comprehensive CLI help system (dbvr –help, dbvr <command> –help) with contextual examples and parameter descriptions.