Access MCP Server by CData
@CDataSoftware
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).
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.
What transport protocol does it use?
The server uses stdio transport and can only run with clients on the same machine as the server.
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).
