Excel Power Pivot MCP Server

@back1ply

代码仓库

基本信息

分类

其他

传输方式

stdio

作者

back1ply

提交者

Back1Ply

关于 Excel Power Pivot MCP Server

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#dax

Excel Power Pivot MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "excel-powerpivot": {
      "command": "C:/path/to/ExcelPowerPivotMcp.exe"
    }
  }
}

Excel Power Pivot MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Excel Power Pivot MCP Server?

A Model Context Protocol server that enables AI assistants to interact with Excel Power Pivot data models. It allows creating and managing DAX measures, relationships, and more through natural language, targeting users who work with Excel Power Pivot.

How to use Excel Power Pivot MCP Server?

Download the latest ExcelPowerPivotMcp.exe from the Releases page and configure your MCP client (Claude Desktop, Cursor, or Antigravity) with the path to the executable. Open an Excel workbook with a Power Pivot data model, then the AI assistant can discover and connect to it automatically using tools like discover_workbooks and connect_workbook.

Key features of Excel Power Pivot MCP Server

Discover and connect to open Excel Power Pivot workbooks
Execute DAX queries and preview table data
Create, update, and delete DAX measures with auto-formatting
Create, delete, and activate/deactivate table relationships
List tables, columns, measures, relationships, hierarchies, KPIs, and dependencies
Add Excel tables to data model and refresh tables

Use cases of Excel Power Pivot MCP Server

Create and manage DAX measures via natural language conversation
Explore and document the data model structure (tables, relationships, measures)
Run ad-hoc DAX queries to preview data and test calculations
Add Excel tables to the data model and refresh model data
Establish or modify table relationships programmatically

常见问题

What are the system requirements?

Windows 10/11 and Microsoft Excel 2013+ with Power Pivot enabled are required.

How do I connect to a workbook?

First open the workbook in Excel, then use the `connect_workbook` tool after discovering open workbooks with `discover_workbooks`.

What features are not available in Excel Power Pivot through this server?

Calculation Groups, Perspectives, Row-Level Security, and DEFINE COLUMN in DAX queries are not supported in Excel Power Pivot.

Can I create calculated columns via this server?

No, creating, updating, or deleting calculated columns is not possible via the MCP server due to COM API restrictions; use the Power Pivot window instead.

Is there a risk of data loss?

Yes, the tool modifies Excel Power Pivot data models directly. Maintain backups of your Excel files before using the tool. The author is not responsible for any data loss or damage.

其他分类下的更多 MCP 服务器

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K

MaxKB

1Panel-dev

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

22.0K

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

EverArt