Blog
Tutorials and guides to help you get the most out of csv-api.
MCP Server: Let ChatGPT and Claude Query Your Data Directly
Enable MCP on any dataset and AI assistants can query, filter, aggregate, and run SQL against your data through a secure OAuth connection. No copy-pasting into prompts.
SQL Queries: Run Real SQL Against Your CSV Data
A new endpoint that accepts raw SQL SELECT queries against your dataset. Full PostgreSQL syntax with defense-in-depth security. Requires a private API key.
csv-api Goes Read/Write: Writes, Bulk Upserts, and Aggregation
A major release: create, update, and delete records over the API, bulk upsert up to 1,000 rows at a time, and run server-side aggregations.
Auto-Generated OpenAPI Docs for Every Dataset
Every dataset gets interactive Swagger documentation with your exact schema, ready to test and share with your team.
Excel Multi-Sheet Support: Upload Workbooks, Pick Your Sheet
Upload .xlsx and .xls files directly and choose which sheet to import — no CSV conversion needed.
Shared Data Views: Give Anyone a Live Window Into Your Data
Create public, read-only pages for your datasets with custom branding, filters, and no authentication required for viewers.
Natural Language Queries: Ask Your Data Questions in Plain English
Skip complex filter syntax — use the prompt parameter to query your CSV data with everyday language, powered by AI.
Powering a Static Site with csv-api
Use csv-api as a lightweight CMS backend for Jekyll, Hugo, or any static site generator.
Managing Your Data: Edit Rows, Rename Columns, and Export
Learn how to update records, rename columns after upload, and export your modified data as CSV.
Optimizing API Responses with Field Selection
Reduce payload sizes and speed up your app by requesting only the columns you need.
Build a Live Dashboard with JavaScript and csv-api
Fetch data from your csv-api endpoint and render it in a dynamic frontend using vanilla JavaScript.
Securing Your API: Authentication and API Key Management
Understand how API key authentication works and best practices for managing your keys.
Sorting and Pagination: Navigating Large Datasets
Combine sorting and pagination to efficiently browse thousands of records from your API.
Mastering Filters: Query Your Data Like a Pro
Learn how to use exact match, comparison, and pattern filters to retrieve exactly the data you need.
Getting Started: Upload Your First CSV and Get an API in 60 Seconds
A step-by-step walkthrough of uploading a CSV file and making your first API request.