Is this server read-only?
Yes, this project builds a read-only MCP server. For full read, write, update, delete, and action capabilities, CData offers a free beta MCP server for Excel Online.
Excel Online MCP Server By Cdata
@CDataSoftware
基本信息
关于 Excel Online MCP Server By Cdata
This read-only MCP Server allows you to connect to Excel Online data from Claude Desktop through CData JDBC Drivers. Free (beta) read/write servers available at
Excel Online MCP Server By Cdata 配置
Excel Online MCP Server By Cdata 工具
工具列表暂未提供
当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。
工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。
概览
What is excel-online-mcp-server-by-cdata?
This is a read-only Model Context Protocol (MCP) server built by CData that allows large language models (like Claude Desktop) to query live data from Excel Online. It wraps the CData JDBC Driver for Excel Online, exposing Excel Online data as SQL relational models that LLMs can access via natural language questions — no SQL required.
How to use excel-online-mcp-server-by-cdata?
Clone the repository, build the JAR with Maven, download and install the CData JDBC Driver for Excel Online, license the driver, configure a connection string using the driver’s utility, and create a .prp file with JDBC properties. Then add the server to your Claude Desktop configuration file (claude_desktop_config.json) and restart Claude Desktop. The server runs via stdio and must be on the same machine as the client.
Key features of excel-online-mcp-server-by-cdata
- Read-only querying of Excel Online data via natural language
- Built on the CData JDBC Driver for Excel Online
- Exposes tables and columns as MCP tools
- Supports SQL SELECT queries through the
{servername}_run_querytool - Requires Maven build and driver licensing
- Uses
stdiotransport for local client-server communication
Use cases of excel-online-mcp-server-by-cdata
- Ask Claude Desktop to summarize data stored in Excel Online workbooks
- Run natural language analytics on Excel Online tables without writing SQL
- Integrate Excel Online data into AI workflows for reporting or dashboards
常见问题
What transport does the server use?
The server uses `stdio` transport, so it can only be used with clients that run on the same machine as the server.
What tools are provided by the server?
The server provides three tools: `{servername}_get_tables` (list available tables), `{servername}_get_columns` (list columns for a table), and `{servername}_run_query` (execute a SQL SELECT query). Tool names are prefixed with the server name defined in the `.prp` file.
How do I configure the connection to Excel Online?
Use the CData JDBC Driver’s Connection String utility to test and copy a JDBC connection string, then create a `.prp` file with properties like `DriverPath`, `DriverClass`, and `JdbcUrl`. OAuth authentication may require browser-based sign-in.
Where can I get help if I have trouble?
For connection issues, contact the CData Support Team. For MCP server usage or feedback, join the CData Community.
其他 分类下的更多 MCP 服务器
Figs, Relationship Expert
Figs O'Sullivan, LMFTCouples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep
Codelf
unbugA search tool helps dev to solve the naming things problem.
14.2K
Senso MCP for Joomla
sensomediaSenso MCP turns a Joomla 5 or 6 site into a remote MCP server. It runs inside Joomla itself (no extra server, no Node.js bridge) and is secured with OAuth 2.1 and Joomla's own ACL. The free pack lets an AI assistant crea
Reactive Resume
amruthpillaiA one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!
39.5K
Yuppsy
Yuppsy MCP: build and publish real estate websites from your AI assistant. Yuppsy lets your AI assistant create live websites for real estate agents and individual property listings. You don't need a designer or any code
评论