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

よくある質問

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.

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.

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.