Access MCP Server by CData

Created By

CDataSoftware7 months ago

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

Overview Content Tools Comments

Overview

What is Access MCP Server by CData?

Access MCP Server by CData is a read-only server that allows LLMs (like Claude Desktop) to query live data from Access databases using the CData JDBC Driver for Access. It simplifies data access by enabling natural language queries without requiring SQL.

How to use Access MCP Server?

To use the Access MCP Server, clone the repository, build the server, install the CData JDBC Driver, configure your connection, and create a configuration file for your AI client. Finally, run the server and interact with it using natural language queries.

Key features of Access MCP Server?

Read-only access to Access databases via a simple MCP interface.
Natural language querying capabilities for LLMs.
Integration with CData JDBC Driver for seamless data access.

Use cases of Access MCP Server?

Querying live data from Access databases using natural language.
Integrating with AI clients like Claude Desktop for enhanced data interaction.
Simplifying data access for non-technical users.

FAQ from Access MCP Server?

Can I write data using this server?

No, this server is read-only. For write capabilities, consider the full CData MCP Server for Access.

Is there a trial version available?

Yes, you can download a trial version of the CData JDBC Driver for Access.

What types of queries can I run?

You can run natural language queries to retrieve data, such as asking for correlations or counts based on your data.

Server Config

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

Recommend Servers

TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.

MiniMax MCPOfficial MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.

Playwright McpPlaywright MCP server

Context7Context7 MCP Server -- Up-to-date code documentation for LLMs and AI code editors

Tavily Mcp

Zhipu Web SearchZhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.

WindsurfThe new purpose-built IDE to harness magic

Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code

BlenderBlenderMCP connects Blender to Claude AI through the Model Context Protocol (MCP), allowing Claude to directly interact with and control Blender. This integration enables prompt assisted 3D modeling, scene creation, and manipulation.

Baidu Map百度地图核心API现已全面兼容MCP协议，是国内首家兼容MCP协议的地图服务商。

Jina AI MCP ToolsA Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.