← Back to tools

q

Run SQL queries directly on CSV/TSV files

Data & JSON linuxmacoswindows Python GPL-3.0

Description

q allows you to execute SQL-like queries on CSV/TSV tabular data files. Each tabular file is treated as a database table, and it supports all SQL constructs including WHERE, GROUP BY, and JOIN operations.

AI Summary

Execute SQL queries directly on CSV and TSV files without a database

Capabilities

  • + Run SQL queries on CSV/TSV files
  • + Support WHERE, GROUP BY, JOIN and other SQL constructs
  • + Treat each file as a database table
  • + Handle multiple file formats

Use When

  • You need to query tabular data files without importing into a database
  • You want SQL-like filtering and aggregation on CSV files

Avoid When

  • x You need a full database management system

Related Tools

View AGENTS.md for q