# dinedal/textql

Execute SQL against structured text like CSV or TSV

Repository: https://github.com/dinedal/textql
Canonical: https://ross.abutalabs.com/products/textql
Language: Go
License: MIT
License Family: permissive
Last push: 2023-10-22T22:51:40+00:00

## Health v2 (maintenance only)
Score: 32/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 0, release rhythm 35, longevity 100
- inputs: {"age_days": 4594, "days_push": 1046, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 9106, forks 297 (observed 2026-08-28T04:10:28.419666+00:00)

## What it is
TextQL is a command-line tool written in Go that lets you execute SQL queries against structured text files like CSV and TSV using an in-memory SQLite database. It supports joins across multiple files, stdin pipes, automatic type detection, and short SQL syntax.

## Use cases
- run sql queries on csv files from the command line
- query tsv data without importing into a database
- join multiple csv files with sql
- pipe data into sql queries via stdin
- quickly analyze csv data with sqlite
- convert csv query results to a different delimiter

## When to choose
- you want ad-hoc SQL analysis of CSV/TSV files without setting up a database
- you need unix pipe-friendly querying that sqlite's import command can't do
- you want quote-escaped delimiter support and automatic type detection
- you need to join several text files in a single SQL query

## When to avoid
- you need a persistent database or concurrent write access
- your data is too large to fit in memory
- you need a full SQL engine with advanced features beyond sqlite
- you need actively maintained software with recent development

## Facets
- artifact type: cli-tool
- maturity: maintenance
- function: database, cli, csv
- domain: developer-tools, data-science, files
- platform: cli, windows, go
- tags: csv, tsv, sqlite, sql-queries, unix-pipes, data-analysis, sql, command-line, macos, linux, docker

## Member repositories
- dinedal/textql (main) score 32

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:10:28.419666+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-29T17:23:58.364348+00:00, confidence not recorded.
  - readme: https://github.com/dinedal/textql (fetched 2026-08-28T04:10:28.419666+00:00, sha ef2106e17380)
- Data as of 2026-08-30T08:39:29.467469+00:00.