Agent♥︎Age
Catalog

csvql

Official

by melihbirim · Zig

Read-only SQL on CSV files for AI agents. No writes, no network; --root confines file access.

io.github.melihbirim/csvql MCP Server

This MCP server provides an analytical CSV query engine that runs SQL against CSV files. It is described as fast, local, zero-config, read-only, and sandboxable using a --root option. The included documentation excerpt emphasizes running SQL analytics (e.g., GROUP BY, aggregates, joins, and time-series) directly on CSV files in place.

🛠️ Key Features

  • Query CSV files with SQL via MCP
  • Runs in place (no database import or ingest)
  • Read-only operation
  • Sandboxable with --root
  • Supports SQL analytics including GROUP BY, aggregates, joins, and time-series

🚀 Use Cases

  • Performing SQL-like analysis over CSV data for AI agents
  • Joining and aggregating data stored in CSV files
  • Time-series analysis on CSV content without provisioning a database

⚡ Developer Benefits

  • Local, zero-config workflow for querying CSV
  • SQL interface for data processing in MCP-based agent environments
  • Suitable for sandboxed execution using --root

⚠️ Limitations

  • Read-only (no writes to the CSV inputs)
  • Tooling scope is limited to querying CSV files with SQL via MCP

Topics

csvcsv-parserduckdbsqlclicommand-linedata-processingfastquery-enginezigai-agentsllmmcpcsv-querycsv-sqldata-analysisduckdb-alternativemcp-servermodel-context-protocolsql-on-csv