Tools
q
harelba/q
q brings SQL to the command line, letting you query CSV/TSV text files and multi-file SQLite databases directly, with automatic caching to speed up repeated queries.
Topics
Related projects
visidata9.5kVisiData is a terminal multitool for exploring and arranging tabular data, opening CSV, SQLite, JSON, Excel and many other formats for interactive analysis.
trdsql2.2ktrdsql is a command-line tool that runs SQL queries directly against CSV, LTSV, JSON, YAML and TBLN files. It supports multiple input and output formats plus PostgreSQL and MySQL syntax.
yt-dlp205.7kA feature-rich command-line downloader for grabbing audio and video from thousands of websites.
sqlc18.4kA SQL compiler that generates type-safe data-access code from queries for Go, Python, Kotlin, and TypeScript.
TikTokDownloader17.4kA Douyin/TikTok downloader and data collection tool that fetches videos, image galleries, live streams and comments, exports to CSV/XLSX/SQLite, and runs via terminal, web API or Docker.
beets15.9kBeets is a media library manager for music collectors that catalogs your collection, automatically fixes metadata via MusicBrainz, and adds transcoding, deduplication and browsing through plugins.