CSV Analytics MCP Server

By MEOK AI Labs — Spreadsheet and CSV analysis toolkit with queries, statistics, pivot tables, and chart export

Installation

pip install csv-analytics-mcp pandas

Usage

python server.py

Tools

load_csv

Load a CSV file into memory for analysis. Returns schema, preview, and memory usage.

Parameters:

• file_path (str): Absolute path to the CSV file
• name (str): Dataset name (default: filename)
• delimiter (str): Column delimiter (default: comma)
• encoding (str): File encoding (default: utf-8)

query_data

Query a loaded dataset with pandas query syntax, column selection, and sorting.

Parameters:

• name (str): Dataset name
• filter_expr (str): Pandas query expression (e.g., 'age > 30 and city == "London"')
• columns (list[str]): Columns to return
• sort_by (str): Sort column
• ascending (bool): Sort order
• limit (int): Max rows (default 100)

describe_columns

Get detailed statistics for every column (mean, std, quartiles for numeric; top values for categorical).

Parameters:

• name (str): Dataset name

aggregate

Aggregate data with GROUP BY and compute metrics (sum, mean, min, max, count, median, std, nunique).

Parameters:

• name (str): Dataset name
• group_by (list[str]): Columns to group by
• metrics (dict[str, str]): Column to aggregation function mapping

export_chart_data

Export data in a chart-ready format compatible with Chart.js, Plotly, or any charting library.

Parameters:

• name (str): Dataset name
• x_column (str): X axis column
• y_columns (list[str]): Y axis columns
• chart_type (str): Chart type (bar, line, scatter, pie)
• limit (int): Max data points (default 50)

pivot_table

Create a pivot table similar to Excel pivot tables.

Parameters:

• name (str): Dataset name
• index (str): Row labels column
• columns (str): Column values column
• values (str): Values column
• aggfunc (str): Aggregation function (mean, sum, count, min, max)

Authentication

Free tier: 30 calls/day. Upgrade at meok.ai/pricing for unlimited access.

License

MIT — MEOK AI Labs