otty / apps
All apps/DuckDB

DuckDB

duckdb

DuckDB is an in-process SQL OLAP database management system.

Runs as duckdb|macOS, Linux, Windows|duckdb.org
Open form in Otty otty.toml

Command form

ai-draft · 3 tasks · 15 fields

Open a database file in the DuckDB shell, or run one SQL command or script and exit with a chosen output format. Server, UI and extension options are not covered.

Opens the form; the finished command lands at your prompt, unrun
Run in Otty
otty gui duckdb
Run DuckDBExample values, fixed in this page — nothing here reaches a terminal
Basic
Database file
file
Open read-only
-readonly
TasksEach one presets the form for one job
Open a database
databasereadonly
Run a query to CSV
databasecommandcsvheaderreadonly
Run a script
databasescriptjsoncsvreadonly
ParametersOnly these flags are editable in the form
Database file
Leave empty for a transient in-memory database.
path · positional 0
SQL command
Run this SQL and exit.
string
-c
SQL script file
Run this script and exit.
path
-f
Open read-only
boolean
-readonly
CSV output
boolean
-csv
JSON output
boolean
-json
Markdown output
boolean
-markdown
Box output
boolean
-box
Table output
boolean
-table
Print headers
boolean
-header
Omit headers
boolean
-noheader
Column separator
string
-separator
NULL text
string
-nullvalue
Startup script
Used instead of ~/.duckdbrc.
path
-init
Safe mode
boolean
-safe
SourcesEvery flag above is checked against these
docs
-c COMMAND Run COMMAND and exit -f FILENAME Run the script in FILENAME and exit. Note that the ~/.duckdbrc is read and executed first (if it exists) -init FILENAME Run the script in FILENAME upon startup (instead of ~/.duckdbrc) -box Set output mode to box -csv Set output mode to csv -json Set output mode to json -markdown Set output mode to markdown…
manual2026-10-27

duckdb.org

Before it fills your prompt, Otty checks the installed duckdb against its version. A form that does not match your version is not offered.