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.
Funny Programmer SQL Database Query Programmer T-Shirt
Humorous SQL query T-shirt perfect for programmers, developers, and database enthusiasts.
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
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.
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.
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
