skills.rest
dathere
dathereOFFICIAL
Explore all skills by this author →
Website𝕏@dathereincGitHub

csv-query

Query CSV, TSV, and Excel files with SQL via the Polars-powered sqlp command.

3.7k|104|Updated Dec 11, 2020
Search Tags:#sql#excel#query#data-analysis#csv#polars#tsv
One-click install
npx skills add https://github.com/dathere/qsv --skill csv-query
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: csv-query
Source: https://github.com/dathere/qsv/tree/main/.claude/skills/skills/csv-query
Command: npx skills add https://github.com/dathere/qsv --skill csv-query

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Query tabular data files using a familiar SQL interface powered by Polars, enabling fast, scalable analysis directly on CSV, TSV, and Excel files.

Core Features & Use Cases

  • SQL over flat files: Run complex SELECTs, JOINs, and aggregations directly against CSV/TSV/Excel data without loading into a database.
  • Fast exploration: Leverage Polars' speed to quickly filter, sort, and summarize data on disk.
  • Use Case: A data analyst can compare quarterly sales by region across multiple CSV files with a single SQL query.

Quick Start

Run a SQL query against your CSV/TSV/Excel file using the sqlp command to obtain results.

Frequently Asked Questions about csv-query

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query a CSV file using SQL without loading it into a database?▼

You can query a CSV file using SQL directly on disk by running the sqlp command, which uses the Polars SQL engine to execute SELECT statements, filters, and aggregations without needing a database.

Can I run SQL JOINs and aggregations directly on TSV or Excel files?▼

Yes, SQL JOINs and aggregations work directly on TSV and Excel files. The Polars SQL engine processes these tabular formats on disk, allowing complex queries across multiple flat files for fast data exploration.

What is the best way to filter and summarize large CSV data for analysis?▼

The best way to filter and summarize large CSV data is using Polars SQL via the sqlp command, which leverages file indices and statistics to optimize query performance for fast exploration and aggregation.

Do I need to install a database to use SQL for data analysis on flat files?▼

No, you do not need a database. The sqlp command relies on the Polars SQL engine and qsv tooling to query CSV, TSV, and Excel files directly, enabling fast data exploration without database setup.

Does Polars SQL support querying multiple CSV files in a single query?▼

Polars SQL supports querying multiple CSV files in a single query. You can run complex SELECTs and JOINs across multiple flat files to compare and aggregate data directly from disk.

Related Skills

Explore More Data & Analytics Skills→
XCmiaowXCmiaow

xlsx

Clean, edit, analyze, and generate Excel, CSV, and TSV spreadsheets with formula validation.

Community
Advanced
Thiago-Cruz-engThiago-Cruz-eng

data-analysis

Analyze datasets to extract insights and produce structured reports.

Community
Intermediate
jonmastjonmast

using-qsv

Process tabular data with the qsv CLI for filtering and cleaning.

Community
Intermediate
tondevreltondevrel
19

duckdb

Run in-process analytical SQL queries on Python DataFrames and files.

Community
Intermediate