+ AI Agents · Flagship
MCP Data Analyst Server
Read-only, sandboxed MCP server that gives Claude, Cursor and custom agents SQL, profiling and charting tools over local CSV, Excel, Parquet and SQLite files.
6 toolsread-only, two security layers
Overview
A Model Context Protocol server built on the official Python SDK that turns a folder of data files into safe analysis tools for any MCP client. Models can list datasets, run DuckDB SQL, profile data quality and receive matplotlib charts as image content. Security has two independent layers: sqlglot only allows a single read-only SELECT on registered tables, and DuckDB itself runs read-only with external file access disabled. A Groq tool-calling agent demonstrates the client side of the protocol end to end.
Highlights
- 6 MCP tools, 2 resources and 2 prompts over stdio and Streamable HTTP
- Two independent security layers (sqlglot validation + read-only DuckDB with file access off), tested separately
- Joins CSV, Parquet, Excel and SQLite files in a single SQL query
- Profiling detects duplicates, outliers and missing values in the demo data
- 101 offline tests using the SDK's in-memory client, plus a live Groq agent test