Metadata-Version: 2.4
Name: csvq-cli
Version: 0.1.0
Summary: CSV/TSV query, filter, transform, and convert from the command line
Author-email: Marcus <marcus.builds.things@gmail.com>
License: MIT
Project-URL: Homepage, https://github.com/marcusbuildsthings-droid/csvq
Keywords: csv,tsv,query,filter,cli,data,tabular
Classifier: Development Status :: 4 - Beta
Classifier: Environment :: Console
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python :: 3
Classifier: Topic :: Utilities
Requires-Python: >=3.9
Description-Content-Type: text/markdown
License-File: LICENSE
Requires-Dist: click>=8.0
Dynamic: license-file

# csvq-cli

CSV/TSV query, filter, transform, and convert from the command line.

## Install

```bash
pip install csvq-cli
```

## Commands

| Command | Description |
|---------|-------------|
| `csvq head` | Show headers and preview rows |
| `csvq count` | Count rows |
| `csvq select` | Select specific columns |
| `csvq filter` | Filter rows (==, !=, >, <, contains, matches, etc.) |
| `csvq sort` | Sort by column |
| `csvq unique` | Unique values with counts |
| `csvq stats` | Numeric stats (min, max, mean, median, sum) |
| `csvq grep` | Search rows matching regex |
| `csvq sample` | Random sample of rows |
| `csvq merge` | Merge multiple CSV files |
| `csvq to-json` | Convert to JSON |
| `csvq to-tsv` | Convert to TSV |
| `csvq to-md` | Convert to Markdown table |

## Examples

```bash
# Preview a file
csvq head data.csv

# Filter and convert
csvq filter data.csv status == active --json

# Stats on a column
csvq stats sales.csv revenue

# Grep across all columns
csvq grep data.csv "error|warning"

# Select columns and sort
csvq select data.csv name email | csvq sort - name

# Pipe from stdin
cat data.csv | csvq count
```

All commands support `--json` output. Auto-detects delimiter (CSV, TSV, semicolon, pipe).

## For AI Agents

See [SKILL.md](SKILL.md) for agent-optimized documentation.

## License

MIT
