Reference¶

--driver¶

Driver name

databow --driver duckdb

Database uniform resource identifier

databow --driver mysql --uri root@tcp(localhost:33577)/test

Database user username

databow --driver flightsql --uri grpc://localhost:9408 --username root

Database user password

databow --driver flightsql --uri grpc://localhost:9408 --username root --password my_pwd

Driver-specific database option

databow --driver duckdb --option path=file.db

Table display style

Mode	Description
`ascii-full`	ASCII table with all borders
`ascii-full-condensed`	ASCII table without row dividers
`ascii-borders-only`	ASCII table with outer borders only
`ascii-borders-only-condensed`	ASCII outer borders without row spacing
`ascii-horizontal-only`	ASCII with horizontal lines only
`ascii-markdown`	Markdown-compatible table format
`ascii-no-borders`	ASCII table without any borders
`utf8-compact`	Compact UTF-8 table style (default)
`utf8-full`	UTF-8 box drawing with all borders
`utf8-full-condensed`	UTF-8 box drawing without row dividers
`utf8-borders-only`	UTF-8 with outer borders only
`utf8-horizontal-only`	UTF-8 with horizontal lines only
`utf8-no-borders`	UTF-8 table without any borders
`nothing`	No borders or lines

databow --driver duckdb --mode ascii-markdown

Execute query and exit

databow --driver duckdb --query "SELECT 42 AS the_answer"

Read and execute file and exit

databow --driver duckdb --file select_example.sql

Write result to file

databow --driver duckdb --query "SELECT 42 AS the_answer" --output result.json

The output format is inferred from the file extension:

Print the help message

databow --help

Print the version

databow --version