# q
> Run SQL queries directly on CSV/TSV files

## 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

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

## When NOT to Use
- You need a full database management system

## Related Tools
- [csvkit](/tools/csvkit) (complementary)
- [visidata](/tools/visidata) (complementary)

---
Source: https://littlescripts.sh/tools/q
