microsoft-excel-mcp-server-by-cdata

microsoft-excel-mcp-server-by-cdata

0
databases

The MCP Server by CData for Microsoft Excel provides a read-only interface that allows LLMs to query live data from Microsoft Excel using natural language questions, without the need for SQL. It wraps the CData JDBC Driver to facilitate interactions with Excel data, making it accessible for AI clients like Claude Desktop.

microsoft-excel-mcp-server-by-cdata

CData's Model Context Protocol (MCP) Server for Microsoft Excel

Purpose

The server allows LLMs (like Claude Desktop) to query live Microsoft Excel data supported by the CData JDBC Driver for Microsoft Excel. This read-only MCP server exposes Microsoft Excel data through a simple MCP interface, enabling LLMs to retrieve live information using natural language without the need for SQL.

Setup Guide

  • Clone the repository.
  • Build the server to create the JAR file.
  • Install the CData JDBC Driver for Microsoft Excel.
  • License the JDBC Driver and configure your data source.
  • Create a .prp file with connection details.

Usage Details

The AI client can use built-in tools to read and manage data using natural language questions.

Tools & Descriptions

  • {servername}_get_tables: Get available tables.
  • {servername}_get_columns: Get columns for a table.
  • {servername}_run_query: Execute a SQL SELECT query.

License

This server is licensed under the MIT License.