noborus/trdsql

Health v2 · maintenance only

Adoption not part of the score

2173 stars · 80 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

trdsql is a Go-based CLI tool that executes SQL queries directly against CSV, LTSV, JSON, JSONL, YAML, and TBLN files, supporting PostgreSQL, MySQL, and SQLite3 syntax. It can also output query results in various formats, making it useful for tabular data format conversion.

Use cases

• run sql queries on csv files from the command line
• join two csv files with sql
• convert to csv or csv to
• query l logs with sql aggregation
• filter and transform yaml data with sql
• use postgresql or mysql syntax on local flat files
• aggregate log files with group by queries

When to choose

• you need SQL (joins, aggregation, window functions) over flat files without loading them into a database
• you want PostgreSQL or MySQL syntax rather than SQLite-only dialects like textql or q
• you need to convert between tabular text formats (CSV, JSON, YAML, LTSV) quickly
• you want a single static binary for scripting and pipelines

When to avoid

• you need a persistent database with indexes and concurrent writes
• your data lives in an actual database server already (just query it directly)
• you need a GUI or interactive spreadsheet-like exploration of the data

Facets

cli-tool · maturity active

cli database parser serialization developer-tools developer-tools files databases cli cross-platform windows go sql-on-files csv yaml ltsv tbln format-conversion sqlite3 postgresql-syntax mysql-syntax data-transformation command-line data-engineering linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="noborus/trdsql")