Introducing databow

By Emil Sadek

June 2, 2026

TL;DR

databow is a new open source command-line tool for querying any database that has an ADBC driver. Built in Rust, databow gives you one fast, modern interface to the SQL systems across your entire data stack. Install it with uv tool install databow.

In a typical day, a data engineer might query a local embedded database, a distributed cloud data warehouse, and an enterprise relational database server—each with its own CLI. psql, mysql, snowsql, bq, sqlite3: different flags, different output formats, different quirks. Switching between them means relearning syntax and reformatting results. GUI tools exist, but they’re heavyweight and pull you out of the terminal.

What if one fast, modern CLI could connect to any database?

Meet databow

Today, we’re excited to introduce databow—an open source command-line tool for querying databases with ADBC (Arrow Database Connectivity).

databow is built in Rust for fast queries and a small footprint. It connects to any database that has an ADBC driver, giving you one unified interface for the SQL systems across your entire data stack.

What databow can do

Connect to 25+ databases

databow works with any database that has an ADBC driver. That includes:

The list keeps growing as the ADBC ecosystem expands.

Run queries in an interactive SQL shell

databow provides a modern REPL with the features you’d expect:

$ databow --driver duckdb
> SELECT * FROM 'sales.parquet' LIMIT 5;
┌────────────┬─────────┬──────────┐
│ date       │ product │ revenue  │
├────────────┼─────────┼──────────┤
│ 2026-01-15 │ Widget  │ 1250.00  │
│ 2026-01-15 │ Gadget  │ 890.50   │
│ 2026-01-16 │ Widget  │ 1100.00  │
│ 2026-01-16 │ Gizmo   │ 2340.00  │
│ 2026-01-17 │ Gadget  │ 756.25   │
└────────────┴─────────┴──────────┘

Export your results

Need to share your query results? Export directly to the format you need:

# Export to CSV
databow --driver postgresql --uri "postgres://localhost/analytics" \
  --query "SELECT * FROM monthly_report" \
  --output report.csv

# Export to JSON
databow --profile warehouse --query "SELECT * FROM users" \
  --output users.json

# Export to Arrow IPC
databow --profile prod-db --query "SELECT * FROM events" \
  --output events.arrow

Power your automations

databow isn’t just for interactive use. It’s designed to fit into scripts and pipelines:

# Execute a query directly
databow --driver duckdb --uri warehouse.db --query "SELECT count(*) FROM logs WHERE level = 'ERROR'"

# Read from a SQL file
databow --driver postgresql --uri "postgres://localhost/analytics" \
  --file daily_metrics.sql --output metrics.csv

# Pipe queries from stdin
echo "SELECT version()" | databow --driver postgresql --uri "$DATABASE_URL"

Load connection details from profiles

Tired of typing long database connection strings? Save your configurations in ADBC connection profiles and refer to them by name:

# Use a saved profile
databow --profile production-warehouse --query "SELECT * FROM orders"

Why ADBC

databow is built on ADBC—the Arrow Database Connectivity standard from the Apache Arrow project. ADBC provides a vendor-neutral API for database access, similar to what JDBC and ODBC do for legacy connectivity. But ADBC is designed from the ground up to transfer data in the Apache Arrow format. That means:

By building on ADBC, databow benefits from the work of the entire Arrow community. When a new database releases an ADBC driver, databow users get access immediately.

Get started

databow ships as a single binary. Install it with uv or Cargo:

# Recommended: install with uv
uv tool install databow

# Alternative: install with Cargo
cargo install databow

Then install the ADBC driver for your database using dbc, the command-line tool for installing and managing ADBC drivers. For example, to install the ADBC driver for DuckDB:

dbc install duckdb

Then start querying:

databow --driver duckdb

Roadmap

We’re actively working on new features to make databow even more powerful: