Skip to content
DuckDB community extension

duck_tails

Smart Development Intelligence for DuckDB - Git-aware data analysis capabilities that allow querying git history, accessing files at any revision, and performing version-aware data analysis with SQL.

01 / SETUP

Install and load

Run these commands in a Haybarn SQL session. The extension is available from the community repository.

Haybarn 2.0.0 · SQL
INSTALL duck_tails FROM community;
LOAD duck_tails FROM community;

Using upstream DuckDB? Follow the maintainer’s installation instructions.

02 / QUERY

Usage example

Query git history (defaults to current directory)

SQL
-- Load the extension

-- Query git history (defaults to current directory)
SELECT commit_hash, author_name, message, author_date
FROM git_log() LIMIT 5;

-- Access files from git repository at specific revisions.
-- Both forms are valid and read the same file; ?ref= is the canonical form.
SELECT * FROM read_csv('git://data/sales.csv?ref=HEAD');
SELECT * FROM read_csv('git://data/sales.csv@HEAD');

-- Compare data between commits
SELECT (SELECT count(*) FROM read_csv('git://data/sales.csv?ref=HEAD')) AS current_count,
       (SELECT count(*) FROM read_csv('git://data/sales.csv?ref=HEAD~1')) AS previous_count;

-- Analyze text differences
SELECT * FROM read_git_diff('git://README.md@HEAD', 'git://README.md@HEAD~1');

Provided by teaguesterling. Not yet verified on Haybarn 2.0.0.

Sample data & setup

About this extension

Duck Tails brings git-aware data analysis capabilities to DuckDB, enabling sophisticated version-controlled data workflows. The extension provides three core capabilities:

Git Filesystem Access: Use the git:// protocol to access any file in your git repository at any commit, branch, or tag. This allows you to query historical data states, compare versions, and perform temporal analysis directly in SQL.

Project overview from the community descriptor.

Documentation and resources

Project and build details
Repository
teaguesterling/duck_tails
License
MIT
Maintainers
teaguesterling
Written in
C++
Build source
2b20b7d21c86
Build definition
Community descriptor