TL;DR
Databow is a new open source CLI tool enabling users to query any database with an ADBC driver, built in Rust for speed and efficiency. It simplifies data access across multiple systems from a single interface.
Databow, an open source command-line tool built in Rust, has been launched to enable querying any database that supports an ADBC driver, providing a unified, fast interface for data professionals.
Databow is designed to connect seamlessly with over 30 databases, including transactional, analytical, lakehouse, and time-series systems, through the ADBC (Arrow Database Connectivity) standard. It offers an interactive SQL shell with features like syntax highlighting, multiline queries, and result export options in formats such as CSV, JSON, and Arrow IPC. The tool supports scripting and automation, allowing direct query execution and integration into pipelines. Installation is straightforward via the uv tool or Cargo, with ADBC drivers installed using dbc. The project emphasizes a small footprint and speed, leveraging Rust’s performance.
The developers highlighted that databow benefits from ADBC’s vendor-neutral API, which facilitates efficient data transfer using Apache Arrow’s columnar format. As more databases adopt ADBC drivers, support for new systems will be automatic. The tool also plans to introduce features like dot commands, additional export formats, result set limits, and data type display in future updates.
Why It Matters
This development matters because it simplifies the data engineering workflow by providing a single, modern CLI interface to access multiple database systems. It reduces the need to learn different tools and syntax, streamlining data analysis, automation, and troubleshooting. For organizations managing diverse data sources, databow could cut costs and improve efficiency by consolidating database interactions into one tool.
SQL Query – SQL Database Admin – Programmer SQL Programming Case for iPhone 14 Pro Max
- Suitable for SQL database engineers: Designed for SQL database professionals
- Explore other designs: View additional designs from our brand
- Dual-layer protection: Polycarbonate shell with shock-absorbent TPU liner
As an affiliate, we earn on qualifying purchases.
As an affiliate, we earn on qualifying purchases.
Background
Traditionally, data professionals rely on separate CLI tools like psql, mysql, or snowsql for different databases, each with unique syntax and output formats. GUI tools exist but are often heavyweight and less suitable for scripting. The introduction of ADBC as a vendor-neutral API aims to unify database connectivity, similar to JDBC and ODBC, but optimized for Apache Arrow’s format. Databow builds on this standard, offering a modern, fast alternative tailored for the evolving data landscape.
“Databow aims to be the universal CLI for database querying, leveraging ADBC to support a growing ecosystem of databases with a single, efficient interface.”
— an anonymous researcher from Hacker News
In-Memory Analytics with Apache Arrow: Perform fast and efficient data analytics on both flat and hierarchical structured data
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 across different database vendors or how quickly databow will integrate with emerging systems. The roadmap indicates planned features, but their release timelines remain unspecified. Additionally, user feedback and real-world performance in large-scale environments are still to be seen.
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’s Next
Next steps include the release of planned features such as dot commands, additional export formats, and improved handling of large result sets. The development team is likely to monitor adoption rates of ADBC drivers and gather user feedback to refine databow’s capabilities. Expect updates that expand its functionality and compatibility.
Rust-based command line database client
As an affiliate, we earn on qualifying purchases.
As an affiliate, we earn on qualifying purchases.
Key Questions
What databases does databow support?
Databow supports over 30 databases that have an ADBC driver, including PostgreSQL, MySQL, SQLite, Snowflake, BigQuery, ClickHouse, and more.
How do I install databow?
Databow can be installed using the uv tool with the command ‘uv tool install databow’ or via Cargo with ‘cargo install databow’.
What is ADBC and why is it important?
ADBC (Arrow Database Connectivity) is a vendor-neutral API for database access that uses Apache Arrow for data transfer, enabling efficient, standardized connectivity across multiple systems.
Can databow be used in scripts and automation?
Yes, databow supports scripting features, including executing queries directly, reading from SQL files, and piping commands, making it suitable for automation pipelines.
Source: Hacker News
