access-mcp-server-by-cdata

access-mcp-server-by-cdata

0
databases

This project provides a read-only MCP Server that facilitates querying live Access data through the CData JDBC Driver, allowing LLMs like Claude Desktop to access this data seamlessly using natural language. The server supports running on the same machine as the client and includes detailed setup and usage instructions for integration.

access-mcp-server-by-cdata

CData's Model Context Protocol (MCP) Server for Access

Purpose

This project is a read-only MCP Server enabling Large Language Models (LLMs) like Claude Desktop to query live Access data via the CData JDBC Driver. This server bridges the driver, allowing LLMs to retrieve information using natural language.

Setup Guide

  1. Clone the repository and build the server.
  2. Download and install the CData JDBC Driver.
  3. License the CData JDBC Driver and configure your connection.
  4. Create a .prp file for your JDBC connection.

Using the Server with Claude Desktop

  • Configure Claude Desktop to add the MCP server.

Running the Server

  • Run the MCP Server using a specified command.

Usage Details

AI clients can use built-in tools to interact with data using natural language.

Tools & Descriptions

  • {servername}_get_tables: List available tables.
  • {servername}_get_columns: List columns for a table.
  • {servername}_run_query: Execute a query.

Troubleshooting

  • Check configurations and connections.
  • Contact CData Support or Community for assistance.

License

Licensed under the MIT License.