A Model Context Protocol (MCP) server that enables AI assistants to interact with Excel Power Pivot data models. Create and manage DAX measures, relationships, and more through natural language.
Excel Power Pivot Mcp is an MCP project maintained in the back1ply/excel-power-pivot-mcp repository. The maintainer describes its purpose as “A Model Context Protocol (MCP) server that enables AI assistants to interact with Excel Power Pivot data models. Create and manage DAX measures, relationships, and…”. Read the project documentation for the complete scope.
The project provides a local client configuration using C:/path/to/ExcelPowerPivotMcp.exe. Follow the repository’s build and installation steps before copying it, and replace example paths with the paths on your own computer.
Project documentation · Repository · Discovery listing. This profile records the public documentation checked on 2026-10-08.
Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.
| Tool | What it does |
|---|---|
| discover_workbooks | Find open Excel workbooks with Power Pivot models |
| connect_workbook | Connect to a specific workbook |
| get_connection_status | Check current connection status |
| save_workbook | Save the connected workbook |
| refresh_model | Refresh the entire data model |
| get_model_summary | Comprehensive model overview |
| list_tables | List all tables with row counts |
| list_columns | List columns in a table |
| list_measures | List measures with expressions |
| list_relationships | Show table relationships |
| list_hierarchies | List user-defined hierarchies |
| list_kpis | List Key Performance Indicators |
| get_dependencies | Show calculation dependencies |
| list_power_queries | List Power Queries (M code) |
| list_excel_tables | List Excel tables (ListObjects) |
| run_dax | Execute DAX queries or preview table data |
| analyze_column | Get column statistics and sample values |
| create_measure | Create a new DAX measure (supports autoFormat=false for speed) |
| update_measure | Update expression/name/description |
| delete_measure | Delete a measure |
| create_relationship | Create a table relationship |
| delete_relationship | Delete a relationship |
| set_relationship_active | Activate/deactivate a relationship |
| add_table_to_model | [DESTRUCTIVE] Add Excel table to data model |
| delete_table | [DESTRUCTIVE] Delete a table from the model |
| refresh_table | Refresh a single table |
| Prompt | Description |
| describe_model | Describe the data model in plain English |
| workflow_create_measure | Guided workflow to create a measure |
| workflow_analyze_model | Analyze model structure and suggest improvements |
| workflow_test_dax | Test DAX before creating permanent measures |
| workflow_fix_measure | Debug and fix a broken measure |
| workflow_add_relationship | Guided workflow to add a relationship |
| recover_connection | Recover from a lost Excel connection |
| URI | Description |
{
"mcpServers": {
"excel-powerpivot": {
"command": "C:/path/to/ExcelPowerPivotMcp.exe"
}
}
}From the project documentation. Replace placeholders and example paths before connecting.
Search and read your Drive — Docs, Sheets and files become context your assistant can actually use.
Spreadsheet-database hybrid meets AI — inspect schemas, query records and update bases conversationally.
Find and run governed Excel model capabilities that your organisation has published for AI agents.
A simple MCP server to let AI interact with Microsoft Access and SQLite 3 databases. Supports import/export with CSV and Excel files, and store
Agent-safe Excel workbook analysis, editing, recalc, and verification tools.
Deterministic DOCX/PPTX/XLSX/PDF parser: track changes, comments, headers, footers, merged cells.