Access MCP Server by CData

Name: Access MCP Server by CData
Author: CDataSoftware

@CDataSoftware

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

Basic information

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"
      ]
    }
  }
}

Tools

No tools detected

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

FAQ from Access MCP Server by CData

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.