广告合作
MCP.so
登录
A

Access MCP Server by CData

@CDataSoftware

代码仓库

基本信息

分类

其他

传输方式

stdio

作者

CDataSoftware

提交者

Cameron Leblanc

关于 Access MCP Server by CData

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free [CData MCP Server for Access (beta)](https://www.cdata.com/download/download.aspx?sku=DCZK-V&type=beta).

#access-mcp#cdata#data-server

Access MCP Server by CData 配置

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

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\access.prp"
      ]
    }
  }
}

Access MCP Server by CData 工具

工具列表暂未提供

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

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

概览

What is Access MCP Server by CData?

Access MCP Server by CData is a read-only MCP server that enables LLMs like Claude Desktop to query live data from Microsoft Access databases. It wraps the CData JDBC Driver for Access, exposing data as relational SQL models through a natural language interface. This server is built for developers and data analysts who want to query Access data without writing SQL.

How to use Access MCP Server by CData?

Clone the repository, build the JAR with mvn clean install, download and license the CData JDBC Driver for Access, and create a .prp properties file specifying the JDBC connection string. Configure Claude Desktop by adding the server to claude_desktop_config.json with paths to Java, the JAR, and the .prp file. The server uses stdio transport and can only run on the same machine as the client.

Key features of Access MCP Server by CData

  • Read-only MCP server for live Access data queries
  • Natural language interface — no SQL required
  • Built on CData JDBC Driver for Access
  • Exposes tables, columns, and SQL query execution tools
  • Supports multiple data sources through a single framework

Use cases of Access MCP Server by CData

  • Query live Access data using natural language in Claude Desktop
  • Correlate data across Access tables without writing SQL
  • Retrieve table lists and column schemas dynamically

常见问题

1

Is Access MCP Server by CData read-only?

Yes, the project builds a read-only MCP server. For full read, write, update, delete, and action capabilities, a separate free beta version is available from CData.

2

What are the runtime requirements?

The server requires Java, the CData JDBC Driver for Access (installed and licensed), and a client like Claude Desktop on the same machine.

3

Where does the data live?

All data stays in the Access database. The server executes queries live and returns results to the client; no data is stored or cached by the MCP server.

4

What transport protocol does it use?

The server uses `stdio` transport and can only run with clients on the same machine as the server.

5

What is the license for Access MCP Server by CData?

The MCP server code is licensed under the MIT License. The underlying CData JDBC Driver for Access requires a separate license (or a trial key).

评论

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

Soar Flight Booking MCP

Soar Flight Booking MCP is a remote MCP server available at https://mcp.soar.flights.

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

Figs, Relationship Expert

Figs O'Sullivan, LMFT

Couples 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

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

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

广告合作