melihbirim

Csvql — Data skill for Claude Code

Data community

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

csvql

[![CI](https://github.com/melihbirim/csvql/actions/workflows/ci.yml/badge.svg)](https://github.com/melihbirim/csvql/actions/workflows/ci.yml) [![License: MIT](https://img.shields.io/badge/License-MIT-blue.svg)](LICENSE.md) [![Release](https://img.shields.io/github/v/release/melihbirim/csvql)](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