TL;DR
Databow is a new open-source command-line tool built in Rust that enables querying any database with an ADBC driver. It offers a unified, fast interface for diverse data sources, simplifying data engineers’ workflows.
Databow, an open-source command-line tool built in Rust, has been launched to connect to any database supporting an ADBC driver, offering a single, modern interface for querying diverse data systems. This development simplifies data access for engineers and analysts by replacing multiple CLI tools with one unified solution.
Databow enables users to connect to over 30 different databases, including transactional systems like PostgreSQL, MySQL, and Oracle, as well as analytical databases such as Snowflake and BigQuery, and time-series databases like InfluxDB. It leverages the ADBC standard, a vendor-neutral API from the Apache Arrow project, designed for efficient data transfer in columnar format.
The CLI features an interactive SQL shell with syntax highlighting, multiline query support, and dynamic output formatting. Users can export results directly to CSV, JSON, or Arrow IPC formats, and automate queries within scripts or pipelines. Connection profiles simplify managing long connection strings, enhancing usability.
Databow’s development was driven by the need for a lightweight, terminal-based tool that consolidates database access across heterogeneous systems, reducing the complexity of switching between different CLIs like psql, mysql, or snowsql. It is available as a single binary, installable via uv or Cargo, with plans for future features such as dot commands, additional export formats, and large result set management.
Why It Matters
This development matters because it addresses a common pain point for data professionals: managing multiple database clients with different interfaces and quirks. By providing a single, fast, and consistent CLI built on a vendor-neutral standard, databow can streamline workflows, reduce learning curves, and improve productivity. As the ADBC ecosystem grows, support for new databases will expand automatically, making databow a scalable tool for diverse data environments.
SQL Query Funny SQL Database Admin Programmer T-Shirt Small
Funny design. This select all users where clue > 0 apparel is a great SQL query joke for…
As an affiliate, we earn on qualifying purchases.
As an affiliate, we earn on qualifying purchases.
Background
Prior to databow, data engineers and analysts relied on specialized CLI tools for each database system, often facing inconsistent syntax, formats, and connection procedures. The ADBC standard, introduced by the Apache Arrow project, aims to unify database connectivity using a common API that transfers data efficiently in Arrow format. Databow leverages this standard to provide a universal interface, aligning with ongoing efforts to modernize data tooling and improve interoperability across data platforms.
“Databow simplifies database querying by providing a single CLI that works across all ADBC-compatible databases, reducing the need to learn multiple tools.”
— an anonymous researcher on Hacker News
Database Systems: Introduction to Databases and Data Warehouses, Edition 2.0
As an affiliate, we earn on qualifying purchases.
As an affiliate, we earn on qualifying purchases.
What Remains Unclear
It is not yet clear how widely adopted the ADBC standard will become or how many databases will support ADBC drivers in the near term. Additionally, the stability and performance of databow in large-scale or complex query scenarios remain to be tested as user adoption grows.
Going Text: Mastering the Power of the Command Line
As an affiliate, we earn on qualifying purchases.
As an affiliate, we earn on qualifying purchases.
What’s Next
Developers plan to enhance databow with new features such as dot commands for quick configuration, support for additional export formats like Parquet, and mechanisms to handle large result sets efficiently. Further integration with more databases as ADBC drivers are released is also anticipated.
Rust-based database query tools
As an affiliate, we earn on qualifying purchases.
As an affiliate, we earn on qualifying purchases.
Key Questions
What databases can databow connect to?
Databow connects to any database with an ADBC driver, including transactional, analytical, lakehouse, and time-series databases such as PostgreSQL, MySQL, Snowflake, BigQuery, InfluxDB, and more.
How do I install databow?
You can install databow using the uv tool with uv tool install databow or via Cargo with cargo install databow.
Can databow be used in scripts?
Yes, databow is designed to be scriptable, supporting direct query execution, file input, and piping for automation and pipelines.
What are the future plans for databow?
Future enhancements include support for more export formats, improved large result set handling, additional command features, and broader database support as ADBC drivers become available.
Source: Hacker News
