Access by CData FAQs

Question 1

What are the benefits of using this tool?

Accepted Answer

The main benefits are enabling natural language querying of Access data, eliminating the need to write SQL queries, and providing a simple interface for integrating Access data with LLMs.

Question 2

What is Access by CData?

Accepted Answer

Access by CData allows you to query live Microsoft Access data using natural language within Large Language Models (LLMs) like Claude Desktop. It leverages the CData JDBC Driver to expose Access data as a relational SQL model.

Question 3

What is the CData JDBC Driver for Access?

Accepted Answer

The CData JDBC Driver provides connectivity to live Microsoft Access data through standard JDBC. It maps Access tables into a relational model, allowing you to query Access data just as you would query a SQL database.

Question 4

How does it work?

Accepted Answer

It creates a read-only MCP (Model Context Protocol) server that wraps the CData JDBC Driver for Access. This allows LLMs to retrieve live information from Access databases by asking natural language questions.

Question 5

Is this a read-only solution?

Accepted Answer

Yes, the provided server is read-only. For full read, write, update, delete, and action capabilities, CData offers a separate MCP Server for Access (beta) available on their website.

Access by CData

概要

主な機能

ユースケース