MCP CSV Analyst Server

Queries and analyzes CSV data by describing, filtering, aggregating, grouping, sampling, and counting unique values via MCP.

javascript

0

GitHub Stars

javascript

Language

4 months ago

First Indexed

2 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "seraphinerenard-mcp-csv-analyst": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-csv-analyst"
      ]
    }
  }
}

You can run mcp-csv-analyst as an MCP server to load, query, filter, aggregate, and analyze CSV data from your Claude or other MCP clients. It exposes a set of simple tools that let you describe a CSV, filter rows, compute aggregates, group data, sample rows, and count unique values, all through MCP requests.

How to use

To use this MCP server with your MCP client, start the server as described in the installation section, then invoke the available tools by passing the required parameters. You can describe a CSV to learn its structure, then progressively apply filtering, grouping, and aggregation to extract meaningful insights from your data.

Key workflows you can perform include describing a CSV to learn its schema and statistics, filtering rows by column conditions, aggregating numeric columns, grouping by one column and aggregating another, sampling rows, and retrieving unique values with counts.

How to install

Prerequisites you need before installing: Node.js and npm (or a compatible environment that can run npm packages). Ensure you have network access to install packages from the npm registry.

Install the MCP server package globally so you can run it from any directory.

Run the following commands in order to install and prepare the server for use.

npm install -g mcp-csv-analyst

npx -y mcp-csv-analyst

Examples and tips

There is a ready-to-use MCP configuration you can add to your Claude setup to connect to this server via npx. You can also add the server to Claude Code using the provided command.

{
  "mcpServers": {
    "csv-analyst": {
      "command": "npx",
      "args": ["-y", "mcp-csv-analyst"]
    }
  }
}

Available tools

csv_describe

Load a CSV file and obtain an overview, including schema, row count, column types, and statistics.

csv_filter

Filter rows by a column condition using operators like eq, neq, gt, gte, lt, lte, contains, and starts_with.

csv_aggregate

Compute aggregates on a numeric column, including sum, avg, min, max, count, and median.

csv_group_by

Group rows by a column and compute an aggregate on another column.

csv_sample

Retrieve a sample of rows from a CSV with optional offset and limit.

csv_unique

List unique values of a column along with their counts.