Skip to main content
Glama

@mcpx-digital/csv-tools

MCP server for local CSV validation and conversion.

Validate CSV structure, check simple schemas, convert CSV↔JSON, sample rows, and find duplicate keys — all on local files.

Privacy: Never uploads user data anywhere. All processing is local.

Install

npx -y @mcpx-digital/csv-tools

Related MCP server: csv-mcp-server

Cursor mcp.json example

{
  "mcpServers": {
    "csv-tools": {
      "command": "npx",
      "args": ["-y", "@mcpx-digital/csv-tools"]
    }
  }
}

Local clone:

{
  "mcpServers": {
    "csv-tools": {
      "command": "node",
      "args": ["/absolute/path/to/csv-tools-mcp/index.js"]
    }
  }
}

Tools

Tool

What it does

validate_csv

Headers, column counts, duplicate headers

schema_check

Required columns + basic types

csv_to_json

CSV → JSON records

json_to_csv

JSON → CSV (optional write to disk)

sample_rows

First N rows

find_duplicate_keys

Duplicate groups by key columns

Example prompts

  • “Validate ./data/users.csv”

  • “Require columns id,email and check email types”

  • “Convert export.csv to JSON and show 5 sample rows”

  • “Find duplicate email values in users.csv”

Development

git clone https://github.com/TheoryofShadows/csv-tools-mcp.git
cd csv-tools-mcp
npm install
npm test

License

MIT

Available Tools

6 tools
csv_to_jsonB

Convert a local CSV file to JSON records (returned in tool result). Local files only — never uploads user data anywhere.

Inputs: filePath (required), delimiter.

find_duplicate_keysB

Find duplicate rows by one or more key columns. Local files only — never uploads user data anywhere.

Inputs: filePath (required), keyColumns (required), delimiter.

json_to_csvB

Convert JSON records (or a local JSON array file) to CSV; optionally write to outputPath. Local files only — never uploads user data anywhere.

Inputs: headers, records, jsonPath, outputPath.

sample_rowsB

Return the first N data rows from a CSV (default 5, max 100). Local files only — never uploads user data anywhere.

Inputs: filePath (required), n, delimiter.

schema_checkB

Check required columns and simple column types (string|number|integer|boolean|email|url). Local files only — never uploads user data anywhere.

Inputs: filePath (required), delimiter, columnTypes, requiredColumns.

validate_csvB

Validate CSV structure (headers, consistent column counts, duplicate headers). Local files only — never uploads user data anywhere.

Inputs: filePath (required), delimiter.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    A3.5/5.0

    Scored across 6 tools

    Disambiguation4/5

    Most tools target distinct operations (convert, sample, find duplicates, validate, schema check). However, validate_csv and schema_check overlap somewhat since both assess CSV structure/quality, though they focus on different aspects (structure vs. column requirements/types). The descriptions help distinguish them.

    Naming Consistency4/5

    Five tools follow snake_case with clear verb_noun or noun patterns (json_to_csv, csv_to_json, validate_csv, sample_rows, find_duplicate_keys), but schema_check lacks a verb and uses a different construction, introducing minor inconsistency.

    Tool Count5/5

    Six tools is well-scoped for a CSV utility server. Each tool covers a distinct common CSV task (conversion, sampling, duplication detection, validation, schema checking), earning its place without redundancy.

    Completeness4/5

    The surface covers key CSV operations: conversion both ways, sampling, duplicate detection, validation, and schema checking. Minor gaps include a dedicated CSV writing/transformation tool (e.g., filter columns, sort) or a dedicated row/column manipulation tool, but core workflows are well supported.

    Maintenance

    ActivitySlowing
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • F
      license
      A
      quality
      D
      maintenance
      Enables comprehensive CSV file management including creating, editing, analyzing, and transforming CSV data anywhere in the filesystem. Provides statistical analysis, data validation, filtering, and grouping capabilities through MCP protocol over stdio transport.
      15
      -
    • F
      license
      B
      quality
      D
      maintenance
      Enables Claude to directly access, query, and analyze local CSV files using natural language, keeping data private and local.
      4
      1
      -
    • A
      license
      Not graded
      quality
      B
      maintenance
      Enables AI assistants to analyze large CSV files locally by importing them into SQLite, profiling columns, and running read-only SQL queries without data leaving the machine.
      MIT