Data analysis MCP servers for charts and reports
MCP servers for data analysis: query warehouses, load spreadsheets, run pandas, and pull product analytics so AI assistants can build reports.
What to know about Data analysis MCP servers
Data analysis servers give an assistant the tools an analyst would use: a way to load data, a way to compute over it, and sometimes a way to draw the result. In practice that means spreadsheet readers, pandas or Jupyter execution servers, connectors for product analytics such as Mixpanel, Amplitude, or PostHog, and BI tools such as Metabase or Looker.
The strongest setups pair a data source with a compute tool. The model pulls rows from a warehouse or CSV, then runs Python to aggregate and chart them, rather than doing arithmetic in its head. That pattern produces numbers you can check, and plots you can drop straight into a report.
Pay attention to how much data a server returns per call. Dumping a large table into the context window is slow and expensive. Servers that push aggregation down to the source, or that page through results, scale far better.
Data analysis MCP servers
The 12 strongest of 1312 matching servers. Servers that name the topic directly come first, then by trust score.
- 77Trust score 77 of 100, Good
Excel MCP Server
by haris-musa · Python
Create and edit Excel files with AI: charts, PivotTables, formulas. No Excel needed.
RegistryLicenseQualityMaintenanceLicense: A. MIT is a permissive open source license.Quality: Not graded. No README or tool list has been captured yet.Maintenance: A. Last commit or release 17 days ago. - 74Trust score 74 of 100, Good
MCP Server for Excel
by sbroenne · C#
Excel automation for AI - Sheets, Power Query, DAX, VBA, Tables, Ranges and more. Windows only.
RegistryLicenseQualityMaintenanceLicense: A. MIT is a permissive open source license.Quality: Not graded. No README or tool list has been captured yet.Maintenance: A. Last commit or release 11 days ago. - 68Trust score 68 of 100, Good
Mixpanel
by pipeworx-io · JavaScript
Mixpanel MCP — wraps Mixpanel Data Export API (mixpanel.com/api)
RegistryRemoteLicenseQualityMaintenanceLicense: A. MIT is a permissive open source license.Quality: Not graded. No README or tool list has been captured yet.Maintenance: A. Last commit or release 9 days ago. - 67Trust score 67 of 100, Good
Posthog
by pipeworx-io · JavaScript
PostHog MCP — wraps PostHog Analytics API (app.posthog.com/api)
RegistryRemoteLicenseQualityMaintenanceLicense: A. MIT is a permissive open source license.Quality: Not graded. No README or tool list has been captured yet.Maintenance: A. Last commit or release 9 days ago. - 65Trust score 65 of 100, Good
biztory-tableau-knowledge-mcp
by biztory · Python
Search, explore and enrich the Tableau Knowledge graph, and port it to Apache Ossie (OSI).
RegistryLicenseQualityMaintenanceLicense: A. MIT is a permissive open source license.Quality: Not graded. No README or tool list has been captured yet.Maintenance: A. Last commit or release 5 days ago. 
63Trust score 63 of 100, GoodThe Power BI Authoring MCP server lets an AI agent create and change Power BI semantic models.
OfficialRegistryLicenseQualityMaintenanceLicense: Not graded. No license is recorded for this server.Quality: Not graded. No README or tool list has been captured yet.Maintenance: Not graded. No commit or release date has been recorded.- 55Trust score 55 of 100, Fair
Read and edit Excel workbooks on SharePoint/OneDrive via Microsoft Graph, with verified writes.
RegistryLicenseQualityMaintenanceLicense: Not graded. No license is recorded for this server.Quality: Not graded. No README or tool list has been captured yet.Maintenance: Not graded. No commit or release date has been recorded. - 55Trust score 55 of 100, Fair
Read spreadsheets; build immutable reports with bulk preparation, calculation, charts and pivots.
RegistryLicenseQualityMaintenanceLicense: Not graded. No license is recorded for this server.Quality: Not graded. No README or tool list has been captured yet.Maintenance: Not graded. No commit or release date has been recorded. - 55Trust score 55 of 100, Fair
Read and filter Excel, ODS, CSV, SQLite, Parquet and MTSV files — or a directory — as plain text
RegistryLicenseQualityMaintenanceLicense: Not graded. No license is recorded for this server.Quality: Not graded. No README or tool list has been captured yet.Maintenance: Not graded. No commit or release date has been recorded. - 55Trust score 55 of 100, Fair
Create and edit Excel workbooks locally with rows and sheets. No network and no key.
RegistryLicenseQualityMaintenanceLicense: Not graded. No license is recorded for this server.Quality: Not graded. No README or tool list has been captured yet.Maintenance: Not graded. No commit or release date has been recorded. - 55Trust score 55 of 100, Fair
Read, filter, group and write XLSX, CSV, TSV and JSON data, and convert between the formats.
RegistryRemoteLicenseQualityMaintenanceLicense: Not graded. No license is recorded for this server.Quality: Not graded. No README or tool list has been captured yet.Maintenance: Not graded. No commit or release date has been recorded. - 55Trust score 55 of 100, Fair
Query Mixpanel events, funnels, retention, cohorts, and user profiles.
RegistryLicenseQualityMaintenanceLicense: Not graded. No license is recorded for this server.Quality: Not graded. No README or tool list has been captured yet.Maintenance: Not graded. No commit or release date has been recorded.
How to install one
- Compare the shortlist. Excel MCP Server leads this topic. Open two or three listings and compare their tools, transport, and required API keys.
- Copy the config for your client. Each listing has an install guide, for example Claude Desktop, Claude Code, Cursor, or VS Code. The client guides show where each config file lives.
- Scope credentials, then restart. Use the narrowest token or folder the server needs, restart the client, and check that the new tools appear.
Data analysis MCP questions
Can MCP servers analyse Excel or Google Sheets files?
Yes. Several servers read and write Excel workbooks, and Google Sheets servers work through the Sheets API. For heavy analysis, load the sheet into pandas or DuckDB through an execution server instead of reading cells one by one.
Can an MCP server produce charts?
Code execution servers can run matplotlib or Plotly and return an image. Some BI servers also create saved charts and dashboards inside the BI tool itself.
Which product analytics tools have MCP servers?
PostHog, Mixpanel, Amplitude, and Google Analytics all have servers, some official. The analytics use case lists the strongest matches for traffic and SEO data.