Azure Table MCP Server by CData

What is Azure Table MCP Server by CData?

Azure Table MCP Server by CData is a read-only Model Context Protocol (MCP) server that uses the CData JDBC Driver for Azure Table to expose Azure Table data as relational SQL models. It allows large language models (like Claude Desktop) to query live Azure Table data through natural language questions without writing SQL.

How to use Azure Table MCP Server by CData?

Clone the repository, build the JAR with mvn clean install, download and install the CData JDBC Driver for Azure Table, license it via java -jar cdata.jdbc.azuretables.jar --license, configure the connection string using the driver’s Connection String utility, create a .prp file with JDBC properties, and add the server to your client’s configuration (e.g., claude_desktop_config.json). The server runs on stdio and must be on the same machine as the client.

Key features of Azure Table MCP Server by CData

• Read-only access to Azure Table data via natural language queries
• Uses the CData JDBC Driver for Azure Table as the underlying engine
• Exposes tables and columns as MCP tools (get_tables, get_columns, run_query)
• CSV-formatted output for easy consumption by LLMs
• Configurable table subset via the .prp file’s Tables property

Use cases of Azure Table MCP Server by CData

• Let AI assistants answer questions about Azure Table data without writing SQL
• Enable natural-language analytics on Azure Table storage
• Integrate live Azure Table queries into agentic workflows

FAQ from Azure Table MCP Server by CData

Is this server read-only or read-write?

The README explicitly states this is a read-only MCP server. For full read, write, update, delete, and action capabilities, the author recommends the free CData MCP Server for Azure Table (beta).

What are the runtime requirements?

You need Java, Maven, and the CData JDBC Driver for Azure Table installed and licensed. The server runs as a Java JAR file.

How does the server communicate with clients?

The server uses the stdio transport, so it can only be used with clients running on the same machine.

Where does my data live?

Data resides in Azure Table and is accessed live through the CData JDBC Driver. The server does not store or cache data locally beyond the query results sent to the client.

How do I troubleshoot connection issues?

Ensure you have configured the connection string properly using the driver’s Connection String utility, and that the .prp file contains the correct JDBC URL. For further help, contact CData Support or join the CData Community.