# noborus/trdsql

CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN. Can output to various formats.

Repository: https://github.com/noborus/trdsql
Canonical: https://ross.abutalabs.com/products/trdsql
Homepage: https://noborus.github.io/trdsql/
Language: Go
License: MIT
License Family: permissive
Topics: sql, csv, ltsv, json, cli, go, tbln, postgresql, mysql, sqlite3, jsonl, golang, yaml, trdsql
Last push: 2026-08-22T02:05:52+00:00

## Health v2 (maintenance only)
Score: 94/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 98, release rhythm 86, longevity 100
- inputs: {"age_days": 3348, "days_push": 12, "days_rel": 96, "gap_med": 8.0, "n_releases_24m": 5}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2173, forks 80 (observed 2026-08-28T04:06:21.914560+00:00)

## What it is
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
- artifact type: cli-tool
- maturity: active
- function: cli, database, parser, serialization, developer-tools
- domain: developer-tools, files, databases
- platform: cli, cross-platform, windows, go
- tags: sql-on-files, csv, yaml, ltsv, tbln, format-conversion, sqlite3, postgresql-syntax, mysql-syntax, data-transformation, command-line, data-engineering, linux, macos

## Member repositories
- noborus/trdsql (main) score 94

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:06:21.914560+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T02:49:02.811584+00:00, confidence not recorded.
  - readme: https://github.com/noborus/trdsql (fetched 2026-08-28T04:06:21.914560+00:00, sha 1c711d989c4f)
  - homepage: https://noborus.github.io/trdsql/ (fetched 2026-08-29T10:29:10.918364+00:00, sha 34b272d855e4)
- Data as of 2026-08-30T08:39:29.467469+00:00.