csv-explorer-mcp
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@csv-explorer-mcp sample 10 random rows from customers.csv"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
CSV Explorer MCP Server
A Model Context Protocol (MCP) server for exploring and analyzing CSV files. Provides tools for inspection, sampling, schema inference, statistics, filtering, and more.
Installation
npm install
npm run buildRelated MCP server: mcp-csv-analyst
Usage
Add to your MCP configuration:
{
"mcpServers": {
"csv-explorer": {
"command": "node",
"args": ["path/to/dist/index.js"]
}
}
}Tools
csv_inspect
Get an overview of a CSV file including size, row/column count, detected delimiter, and a preview of the data. Large field values are automatically truncated with content-type hints.
csv_inspect({ file: "/path/to/data.csv", previewRows: 5 })csv_sample
Get sample records using various sampling strategies.
csv_sample({ file: "/path/to/data.csv", mode: "random", count: 10 })
// modes: "first", "last", "random", "range"csv_schema
Infer the schema by sampling records. Returns column names, types, and nullability.
csv_schema({ file: "/path/to/data.csv", sampleSize: 1000 })
// outputFormat: "inferred", "json-schema", "formatted"csv_stats
Collect aggregate statistics for fields. Includes min/max, mean, median, stdDev for numeric fields, and top values for categorical fields.
csv_stats({ file: "/path/to/data.csv", fields: ["price", "category"] })csv_search
Search for records where a field matches a regex pattern.
csv_search({ file: "/path/to/data.csv", field: "email", pattern: "@example\\.com$" })csv_filter
Filter records using query expressions. Supports comparisons (==, !=, <, >, <=, >=), text operations (contains, startswith, endswith, matches), and compound queries (AND, OR).
csv_filter({ file: "/path/to/data.csv", query: 'status == "active" AND age > 30' })csv_validate
Validate a CSV file for syntax errors and optionally against a schema.
csv_validate({
file: "/path/to/data.csv",
schema: {
columns: [
{ name: "id", type: "integer", required: true },
{ name: "email", type: "string", pattern: "^[^@]+@[^@]+$" }
]
}
})csv_tail
Read new records appended since a cursor position. Use for monitoring actively-written files.
csv_tail({ file: "/path/to/data.csv", cursor: 1024, maxRecords: 100 })csv_get_cursor
Get the current end-of-file position for use with csv_tail.
csv_get_cursor({ file: "/path/to/data.csv" })csv_diff
Compare two CSV files and report differences.
csv_diff({ file1: "/path/to/old.csv", file2: "/path/to/new.csv", keyField: "id" })csv_extract
Extract a specific field value from a CSV record. Use for retrieving large/truncated field data. Can write to file for binary data (e.g., base64 images).
// Get field value inline
csv_extract({ file: "/path/to/data.csv", field: "description", line: 5 })
// Decode base64 and write to file
csv_extract({
file: "/path/to/data.csv",
field: "screenshot",
line: 1,
decode: "base64",
outputFile: "/tmp/screenshot.png"
})csv_large_fields
List fields containing large values (e.g., base64 images, JSON blobs). Helps identify which fields were truncated in csv_inspect.
csv_large_fields({ file: "/path/to/data.csv", threshold: 1000, sampleRows: 100 })Features
Streaming Architecture: Memory-efficient processing of large files
Auto-Detection: Automatically detects delimiters (comma, tab, semicolon, pipe) and encoding
Smart Truncation: Large field values are truncated with content-type hints (base64, JSON, HTML)
Query Engine: Filter records with SQL-like expressions supporting AND/OR logic
Schema Inference: Detect column types (string, integer, number, boolean, date, email, url)
Online Statistics: Uses Welford's algorithm for efficient single-pass statistics
Development
# Run tests
npm test
# Build
npm run build
# Watch mode
npm run devLicense
MIT
Available Tools
12 toolscsv_diffC
Compare two CSV files and report differences.
Inputs: file1 (required), file2 (required), keyField, maxDiffs, +1 more.
csv_extractA
Extract a specific field value from a CSV record. Use for retrieving large/truncated field data. Can write to file for binary data (e.g., base64 images).
Inputs: file (required), field (required), line, decode, +1 more.
csv_filterA
Filter records using query expressions. Supports comparisons (==, !=, <, >, <=, >=), text operations (contains, startswith, endswith, matches), and compound queries (AND, OR).
Inputs: file (required), query (required), limit, outputFormat.
csv_get_cursorA
Get the current cursor position (end of file) for use with csv_tail.
Inputs: file (required).
csv_inspectB
Get an overview of a CSV file including size, row/column count, detected delimiter, and a preview of the data.
Inputs: file (required), previewRows.
csv_large_fieldsA
List fields in a CSV that contain large values (e.g., base64 images, JSON blobs). Helps identify which fields were truncated in csv_inspect.
Inputs: file (required), threshold, sampleRows.
csv_sampleC
Get sample records from a CSV file using various sampling strategies.
Inputs: file (required), mode, count, rangeEnd, +1 more.
csv_schemaA
Infer the schema of a CSV file by sampling records. Returns column names, types, and nullability.
Inputs: file (required), sampleSize, outputFormat.
csv_searchC
Search for records where a field matches a regex pattern.
Inputs: file (required), field (required), pattern (required), maxResults, +2 more.
csv_statsA
Collect aggregate statistics for fields in a CSV file. Includes min/max, mean, median, stdDev for numeric fields, and top values for categorical fields.
Inputs: file (required), fields, maxRecords.
csv_tailA
Read new records appended to a CSV file since a cursor position. Use for monitoring actively-written files.
Inputs: file (required), cursor, timeout, maxRecords.
csv_validateA
Validate a CSV file for syntax errors and optionally against a schema.
Inputs: file (required), schema, maxErrors, stopOnFirstError.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 12 tools
Tools are largely distinct with clear purposes. csv_search and csv_filter both retrieve matching records but differ in query syntax (regex vs expression), which could cause some initial confusion. csv_inspect and csv_schema provide different levels of overview, but descriptions clarify the difference.
All tools share the csv_ prefix and snake_case, creating a recognizable family. However, naming style is inconsistent: some use verbs (csv_filter, csv_validate), some nouns (csv_schema, csv_stats), and some adjective_noun (csv_large_fields). This slight inconsistency prevents a perfect score.
At 12 tools, the count is well-suited to the server's purpose of comprehensive CSV exploration. Each tool addresses a distinct aspect, and the count is neither sparse nor bloated.
The tool set covers the core lifecycle of CSV analysis: inspection, sampling, schema, stats, search/filter, validation, monitoring, diffing, and handling large fields. Minor gaps include lack of sorting or column manipulation, but these are beyond the apparent scope.
Maintenance
Related MCP Connectors
Query, join, profile, clean and convert CSV/JSON/Parquet with server-side DuckDB over MCP.
Ask questions about a CSV in plain English and get answers, charts and cleaned data back.
A comprehensive Model Context Protocol (MCP) server that enables AI assistants to interact with yo…
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceAn MCP server that provides AI assistants with structured, type-safe access to tabular datasets from CSV files. It enables users to list, describe, and query data using filters and projections with support for hot reloading.9 npmMIT
- AlicenseAqualityNot gradedmaintenanceAn MCP server that enables AI assistants to load, query, and analyze local CSV files using tools for filtering, aggregation, and grouping. It provides capabilities to describe schemas, calculate statistics, and sample data directly from CSV files.6-
- FlicenseNot gradedqualityDmaintenanceAn MCP server that enables the analysis of CSV and Parquet files by providing tools for statistical summaries, data previews, and structure exploration. It allows users to query local datasets and create sample data using natural language.-
- FlicenseAqualityDmaintenanceAn MCP server for dataset exploration and analysis, enabling LLM clients to perform summary, correlation, distribution, missing value analysis, data cleaning, and statistical tests directly on CSV files.3-