excel-online-mcp-server-by-cdata

excel-online-mcp-server-by-cdata

0
databases

CData's MCP Server for Excel Online is designed to allow large language models to query live Excel Online data without SQL knowledge. The server leverages the CData JDBC Driver to provide a simple interface for accessing SQL models in Excel Online, enabling natural language data queries.

excel-online-mcp-server-by-cdata

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

Purpose

  • Provides a read-only MCP Server for querying live data in Excel Online using LLMs.
  • Integrates with CData JDBC Driver for Excel Online to expose data as relational SQL models.
  • Allows retrieval of live Excel Online data through a natural language MCP interface.

Usage Details

  • Once configured, the AI client can perform read, write, update, and delete operations on the data.
  • Simply ask questions about the data system, e.g., correlation between opportunities and account industry or the number of open tickets.

Tools & Descriptions

  • {servername}_get_tables: Retrieves list of tables.
  • {servername}_get_columns: Retrieves list of columns for a table.
  • {servername}_run_query: Executes SQL SELECT queries.

Setup Guide

  • Clone the repository, build the server, and license the JDBC Driver.
  • Configure the connection and create a JDBC .prp file.
  • Add the server to Claude Desktop and run it.

Running the Server

  • Use the command to run the MCP Server independently.

Troubleshooting

  • Ensure proper configuration and full closure of Claude Desktop if issues arise.