dinedal/textql

Health v2 · maintenance only

Flags: no_releases

Adoption not part of the score

9106 stars · 297 forks observed · 2026-08-28

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

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

cli-tool · maturity maintenance

database cli csv developer-tools data-science files cli windows go csv tsv sqlite sql-queries unix-pipes data-analysis sql command-line macos linux docker

Member repositories

For agents

markdown · JSON · MCP: product_card(name="dinedal/textql")