Advertise
MCP.so
Sign In
A

Access MCP Server by CData

@CDataSoftware

Repository

Basic information

Category

Other

Transports

stdio

Author

CDataSoftware

Submitted by

Cameron Leblanc

About 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 config

Add this server to your MCP-compatible client using the configuration below.

{
  "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 tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

Frequently asked questions

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).

Comments

More Other MCP servers

MaxKB

1Panel-dev

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

22.0K

Glasswarp

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

YOUB

Connect your AI assistant to your own YOUB endurance training account. Read recorded activities with full analysis, planned sessions, race goals, wellness (HRV, sleep, resting HR) and your athletic profile. Create or mov

Volley.sh

Volley

A good sequence diagram can solve almost any communication problem in engineering. Volley lets your agent write them as plain text, with the real request and response payloads on every arrow. It checks its own syntax wi

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

Advertise