dbase-sql is a command-line tool that allows you to query dBase (.dbf) files using SQL. Powered by the dbase-rs library for dBase file parsing and datafusion as the query engine, dbase-sql provides a fast and easy way to query dBase files.

• Query dBase files with SQL
• Choose between CSV, TSV, DSV, o r table output formats
• Supports multiple SQL statements in a single query

Ensure you have Rust installed on your system. If not, follow the instructions here to install Rust.

Then, clone the repository:

git clone https://github.com/casperhart/dbase-sql.git
cd dbase-sql

Build and install the binary:

cargo build --release
cargo install --path .

Run a SQL query on a dBase file:

dbase-sql -e "CREATE EXTERNAL TABLE orders STORED AS dbase LOCATION '/path/to/ORDERS.DBF'; SELECT order_id, customer_name, order_date FROM orders LIMIT 1;" --output-format tsv > output.tsv

Or, run a SQL query from a file:

dbase-sql -f sample_query.sql --output-format tsv > output.tsv

Where sample_query.sql contains:

CREATE EXTERNAL TABLE orders STORED AS dbase LOCATION '/path/to/ORDERS.DBF';

SELECT order_id, customer_name, order_date
FROM orders
LIMIT 1;

• CSV (--output-format csv)
• TSV (--output-format tsv)
• DSV (--output-format dsv --delimiter-for-dsv '|')
• Table (default) (--output-format table)

Contributions, issues, and feature requests are welcome! Feel free to check the issues page.

If you find this project useful, give it a ⭐️!