{"_id":"@asdsadw12312dwd2112xz/csv-query-cli","name":"@asdsadw12312dwd2112xz/csv-query-cli","dist-tags":{"latest":"1.0.0"},"versions":{"1.0.0":{"name":"@asdsadw12312dwd2112xz/csv-query-cli","version":"1.0.0","description":"Query CSV files with SQL-like syntax from the terminal","type":"module","bin":{"csv-query-cli":"dist/index.js"},"scripts":{"build":"tsup","dev":"tsup --watch"},"dependencies":{"chalk":"^5.3.0","commander":"^12.0.0"},"devDependencies":{"tsup":"^8.0.0","typescript":"^5.4.0"},"gitHead":"7b4ca04cd918b4dc1f4f70e8d1817ac41f9ac3a9","_id":"@asdsadw12312dwd2112xz/csv-query-cli@1.0.0","_nodeVersion":"25.9.0","_npmVersion":"11.12.1","dist":{"integrity":"sha512-07f1vGEm4flQB5IVtuu5YuCjyyNhAgffpESRgZ908fcA3t/IUlzbwA4zEbcaMFPDU04mQRjFmfM0OKtGzgeOfQ==","shasum":"e177dddb5bcc758140f43921ff533860bdd34d0f","tarball":"https://registry.npmjs.org/@asdsadw12312dwd2112xz/csv-query-cli/-/csv-query-cli-1.0.0.tgz","fileCount":6,"unpackedSize":19917,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIF7hO5A3aqgfTUm1/NawxCIJQpj5XsC8IrqmoLSAQTyKAiEAyZLk8+TQwlc06ckNQODwTQFoGvvHO8T9zWF7zhzJwJo="}]},"_npmUser":{"name":"asdsadw12312dwd2112xz","email":"okirmio@gmail.com"},"directories":{},"maintainers":[{"name":"asdsadw12312dwd2112xz","email":"okirmio@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/csv-query-cli_1.0.0_1775436198630_0.9213354652844563"},"_hasShrinkwrap":false}},"time":{"created":"2026-04-06T00:43:18.525Z","1.0.0":"2026-04-06T00:43:18.766Z","modified":"2026-04-06T00:43:18.982Z"},"maintainers":[{"name":"asdsadw12312dwd2112xz","email":"okirmio@gmail.com"}],"description":"Query CSV files with SQL-like syntax from the terminal","readme":"# csv-query-cli\n\nQuery CSV files with SQL-like syntax right from your terminal.\n\n## Install\n\n```bash\nnpm install -g csv-query-cli\n# or run locally after build:\nnode dist/index.js <file> [options]\n```\n\n## Build\n\n```bash\nnpm install\nnpm run build\n```\n\n## Usage\n\n```\ncsv-query-cli <file> [options]\n```\n\n### Options\n\n| Flag | Description |\n|------|-------------|\n| `-w, --where <expr>` | Filter rows: `col=value`, `col>10`, `col!=foo` |\n| `-s, --select <cols>` | Comma-separated columns to show |\n| `--sort <col>` | Sort by column (prefix `-` for descending, e.g. `-age`) |\n| `-l, --limit <n>` | Limit output to N rows |\n| `-c, --count` | Print matching row count only |\n| `--stats` | Show column statistics (min, max, avg, median, unique) |\n| `-d, --delimiter <char>` | Field delimiter (default: `,`) |\n\n### Operators for `--where`\n\n`=` `!=` `>` `<` `>=` `<=`\n\nNumeric comparisons are used when both sides are valid numbers; otherwise falls back to string comparison.\n\n## Examples\n\n```bash\n# Show entire file as table\ncsv-query-cli data.csv\n\n# Filter rows\ncsv-query-cli data.csv --where \"age>25\"\ncsv-query-cli data.csv --where \"city=London\"\n\n# Select specific columns\ncsv-query-cli data.csv --select \"name,age,city\"\n\n# Combine filter + select + sort + limit\ncsv-query-cli data.csv --where \"age>=18\" --select \"name,age\" --sort \"-age\" --limit 10\n\n# Count matching rows\ncsv-query-cli data.csv --where \"status=active\" --count\n\n# Column statistics\ncsv-query-cli data.csv --stats\ncsv-query-cli data.csv --select \"salary,age\" --stats\n\n# Custom delimiter (TSV)\ncsv-query-cli data.tsv --delimiter $'\\t'\n\n# Semicolon-separated\ncsv-query-cli data.csv --delimiter \";\"\n```\n\n## Sample CSV\n\n```csv\nname,age,city,salary\nAlice,30,London,75000\nBob,24,Paris,55000\nCarol,35,London,90000\nDave,28,Berlin,62000\n```\n\n```bash\ncsv-query-cli sample.csv --where \"city=London\" --sort \"-salary\"\n# ┌──────┬─────┬────────┬────────┐\n# │ name │ age │ city   │ salary │\n# ├──────┼─────┼────────┼────────┤\n# │ Carol│ 35  │ London │ 90000  │\n# │ Alice│ 30  │ London │ 75000  │\n# └──────┴─────┴────────┴────────┘\n# 2 row(s)\n```\n","readmeFilename":"README.md","_rev":"1-123975f99b9f88d76333c65036b9e8e5"}