Install and load
Run these commands in a Haybarn SQL session. The extension is available from the community repository.
INSTALL duck_tails FROM community;
LOAD duck_tails FROM community;
Using upstream DuckDB? Follow the maintainer’s installation instructions.
Usage example
Query git history (defaults to current directory)
-- 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 & setupAbout 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