Csvql — Data skill for Claude Code
SQL queries for CSV files.
How to install Csvql
This entry records only its repository, not the path inside it, so there is no
exact command to give. Open melihbirim/csvql and copy the folder into
~/.claude/skills/, or the file into ~/.claude/agents/.
What Csvql does
SQL queries for CSV files. The analytical CSV query engine for AI agents cli: csvql.
Alternatives in Data
- Dummy Dataset — Generate realistic dummy datasets in CSV, JSON, or SQL 7.8k ★
- Portaljs Add Dataset — Add a dataset (CSV, TSV, JSON, or GeoJSON) to an existing PortalJS portal 2.3k ★
- SEO Rank Tracking — Track search engine rankings 397 ★
README
[](https://github.com/melihbirim/csvql/actions/workflows/ci.yml) [](LICENSE.md) [](https://github.com/melihbirim/csvql/releases)
**The analytical CSV query engine for AI agents.**
Run SQL analytics — `GROUP BY`, aggregates, joins, time-series — on CSV files **in place**: no database, no import, no ingest. csvql ships as an [MCP](https://modelcontextprotocol.io/) server, so an LLM can query a gigabyte file for a few hundred tokens instead of pasting it (impossible) into context. A single static binary written in Zig. Your data never leaves your machine.
A database is something you load your data *into*. csvql is a query you run on the data where it already lives.
**Read-only and on-prem by design.** csvql only runs `SELECT` — it has no `INSERT`/`UPDATE`/`DELETE`/`DROP` and physically cannot modify your data. It makes zero network calls, needs no cloud, and runs fully air-gapped. **Our next north star:** the safe way to give AI agents query access to corporate data — run csvql *next to the data* on your own servers (read-only, nothing leaves the box) instead of shipping files out to an LLM.
Token economics: query files instead of pasting them
Pasting a 417 MB CSV into an LLM costs **230 million tokens** — it fits no context window. Over MCP, the agent queries the file in place and gets back only the answer:
| Question an agent asks | Tokens used |
|---|---|
| "How many trips per cab type?" | 43 |
| "Which year was busiest?" | 49 |
| "Average fare by passenger count?" | 123 |
Same answers, **~1,000–500,000× fewer tokens** — flat, regardless of file size. One command wires it into Claude: [`csvql install`](#setup). Measure it you
Related Skills
Codeatlas
CodeAtlas is a high-performance, local-first intelligent codebase indexer and query engine. It provides archit
DB LLM Skills
A globally-installed engine for letting an LLM access PostgreSQL safely: read-only role provisioning, a pg_cat
Claude Sessions Duckdb
Query your Claude Code session transcripts with SQL — one DuckDB script, five views, and the format traps that
Showboard
Your coding agent answers with dashboards, not paragraphs. An MCP server for Claude Code, Codex, Cursor, Gemin
Powerbi Analyst Skill
A study-first Claude/Agent Skill that turns CSV, Excel, or other source data into production-ready Power BI ar
Read Only Postgres
by jawwadfirdousi - Read-only PostgreSQL query skill for Claude Code. Executes SELECT/SHOW/EXPLAIN/WITH querie
Related Agents
SQL Performance Reviewer
Use this agent after any change to EF Core queries, repositories, or indexes — before the change ships. Focuse
Dev BI
Data Architect & Dashboard Strategist — queries the database directly (SELECT-only), compiles analytical findi
Shine Data Engineer
Local data analysis via DuckDB/SQLite MCP — SQL on CSV/Parquet/JSON/Excel without cloud services. Produces cha