Tools
trdsql
noborus/trdsql
trdsql 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.
Topics
Related projects
sq2.6ksq is a command-line data wrangler that gives jq-style query access to SQL databases, CSV, Excel, and JSON. It can join across sources and export results in many formats.
sqlc18.4kA SQL compiler that generates type-safe data-access code from queries for Go, Python, Kotlin, and TypeScript.
q10.4kq 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.
visidata9.5kVisiData is a terminal multitool for exploring and arranging tabular data, opening CSV, SQLite, JSON, Excel and many other formats for interactive analysis.
jid7.2kAn interactive JSON drill-down tool with tab completion, dot-path navigation, and JMESPath expressions that highlights matching keys in real time.
mergestat-lite3.5kmergestat-lite is a command-line tool that lets you run SQL queries against Git repositories and related data sources, making it easy to generate reports, run status checks, and analyze codebases.