Install DuckDB
Search Shortcut cmd + k | ctrl + k
tarfs

glob, open and read files within `.tar` archives

Extension repository on GitHub 6 Extension descriptor (YAML) Weekly downloads 📈 139

Installing and Loading 

INSTALL tarfs FROM community;
LOAD tarfs;

Example 

SELECT filename FROM read_blob('tar://data/csv/tar/ab.tar/*');

About tarfs

This extension provides a duckdb file-system abstraction to read and glob files within uncompressed tar archives. For more information and information regarding usage, limitations and performance, see the tarfs README.