databow: a Rust CLI to query any database with an ADBC driver

3 days ago

databow is an open-source CLI tool for querying databases with ADBC drivers.
Built in Rust, it provides a fast, unified interface for various SQL databases.
It supports over 30 databases, including transactional, analytical, lakehouse, and time-series types.
Features include an interactive SQL shell with syntax highlighting, multiline input, and clean table output.
It allows exporting query results to formats like CSV, JSON, and Arrow IPC.
databow is designed for automation, fitting into scripts and pipelines.
Connection profiles can be saved to avoid repetitive typing of connection strings.
Based on ADBC, it ensures efficient data transfer in Apache Arrow format and consistent behavior across databases.
Install via uv or Cargo, and manage ADBC drivers with dbc.
Future roadmap includes dot commands, more export formats, result truncation, and data type display.

Hasty Briefsbeta