広告掲載
MCP.so
ログイン
E

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

よくある質問

1

What are the system requirements?

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

2

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`.

3

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.

4

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.

5

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.

コメント

「その他」の他のコンテンツ

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K

The Living Bread

The Living Bread

A free remote MCP server for The Living Bread. Bible passages read word for word from a stored public domain text with an evidence label, keyword search and cross references, real churches, gatherings and prayer groups w

Hindsight

vectorize-io

Hindsight: Agent Memory That Learns

50.4K

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

Lemon.io

lemon-io

Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3

広告掲載