Avro MCP Server by CData

What is Avro MCP Server by CData?

Avro MCP Server by CData is a read-only Model Context Protocol (MCP) server that enables large language models (LLMs) such as Claude Desktop to query live Avro data using natural language. It wraps the CData JDBC Driver for Avro, which exposes Avro files as relational SQL models, so no SQL knowledge is required from the user.

How to use Avro MCP Server by CData?

Clone the repository, build with Maven (mvn clean install), then install and license the CData JDBC Driver for Avro. Create a .prp property file with your connection settings (including DriverPath, DriverClass, and JdbcUrl). Configure Claude Desktop by adding the server to claude_desktop_config.json or run the server standalone with java -jar PATH/TO/CDataMCP-jar-with-dependencies.jar PATH/TO/avro.prp. The server exposes tools for listing tables, columns, and executing SQL SELECT queries.

Key features of Avro MCP Server by CData

• Read-only MCP server for Avro data
• Uses the CData JDBC Driver for Avro
• Exposes Avro files as relational SQL tables
• Natural language querying via LLM clients
• Tools: get_tables, get_columns, run_query
• Uses stdio transport for local clients

Use cases of Avro MCP Server by CData

• Query Avro data with natural language from Claude Desktop
• Retrieve live information from Avro files without writing SQL
• Integrate Avro data into AI-powered analytics workflows
• Explore Avro schemas and data interactively via MCP tools

FAQ from Avro MCP Server by CData

What transport does the server use?

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

Is the server read-only?

Yes, this project builds a read‑only MCP server. For full read, write, update, delete, and action capabilities, CData offers a separate beta MCP Server for Avro.

What dependencies are required?

Java, Maven, and the CData JDBC Driver for Avro (which must be downloaded, installed, and licensed separately).

How do I configure the connection?

Create a .prp file with properties such as Prefix, ServerName, DriverPath, DriverClass, and JdbcUrl. Use the JDBC connection string utility to test and obtain the correct JdbcUrl.

Where can I get support?

Contact the CData Support Team for connection issues. For MCP server feedback, join the CData Community.