dbvr

name	dbvr
description	Query databases and export results to CSV using the dbvr CLI (DBeaver command-line interface). Use when you need to run SQL queries, inspect database data, list tables, get table DDL, or export query results to CSV. Activate when the user mentions dbvr, DBeaver CLI, database export, or needs to query a database from the command line.

DBVR — DBeaver CLI

Binary

/Applications/dbvr.app/Contents/MacOS/dbvr

Add to PATH (optional):

source /Applications/dbvr.app/Contents/MacOS/add-dbvr-ce-to-path.sh

List Available Datasources

dbvr datasource list

View Datasource Details

dbvr datasource view <name>

Run a SQL Query

dbvr sql -ds=<datasource> "SELECT * FROM schema.TableName"

Export Query to CSV File

dbvr sql -ds=<datasource> --disable-status -format=csv -out=output.csv "SELECT * FROM schema.TableName"

Export to CSV via stdout

dbvr sql -ds=<datasource> --disable-status -format=csv "SELECT * FROM schema.TableName" 2>/dev/null > output.csv

Run SQL from a File

dbvr sql -ds=<datasource> --disable-status -format=csv -in=query.sql

Metadata Commands

List tables in a schema

dbvr meta table list -ds=<datasource> -db=<database> -sn=<schema>

Get table DDL

dbvr meta table ddl -ds=<datasource> -db=<database> -sn=<schema> =<TableName>

Key Flags

Flag	Description
-ds=<name>	Datasource name (from datasource list)
-format=csv	Output as CSV (default is table)
-out=<file>	Write output to file
-in=<file>	Read SQL from file
--disable-status	Suppress "Rows read" footer
-l=<limit>	Limit rows (default 1000). Use -l=0 for all rows
-op=<params>	Output format params: delimiter=|,quoteall=true
-u=<user>	Database user
-p=<password>	Database password
2>/dev/null	Suppress Java/TLS warnings from stderr