Frequently Asked Questions about CData MCP Server for CockroachDB

What is the CData MCP Server for CockroachDB?

It’s a read-only server that allows LLMs, such as Claude Desktop, to query live data in CockroachDB via CData JDBC Drivers, enabling natural language data retrieval.

What is CockroachDB?

CockroachDB is a distributed SQL database designed for resilience, scalability, and data consistency. It is well-suited for cloud-native applications and provides ACID transactions.

What are the main benefits of using this MCP Server?

It allows seamless integration between LLMs and CockroachDB, enabling real-time data access via natural language queries, simplifying data interaction for AI applications.

Is this MCP server read-only?

Yes, this specific MCP Server is read-only. However, CData offers beta read/write servers available on their website.

What is a .prp file and how is it used?

A .prp file is a properties file containing connection details for the JDBC driver, including the driver path, class, JDBC URL, and other configuration parameters.

Can I use this server with other AI clients besides Claude Desktop?

While the setup guide focuses on Claude Desktop, the MCP server can potentially be used with other AI clients that support the MCP protocol, although configuration steps might vary.

What kind of queries can I run using this MCP server?

You can execute SQL SELECT queries to retrieve data from your CockroachDB database, allowing AI models to get specific information based on your natural language prompts.

What do I do if I cannot see the CData MCP Server in Claude Desktop?

Ensure you have fully quit Claude Desktop (using Task Manager on Windows or Activity Monitor on Mac) and then restart it.

What if Claude Desktop is unable to retrieve data?

Double-check your connection configuration. Use the Connection String builder to create the connection string and ensure it’s correctly entered in the .prp file.

How can I get help if I have trouble connecting to my data source?

Contact the CData Support Team through their website for assistance with data source connectivity issues.

Where can I provide feedback or get further assistance using the MCP server?

Join the CData Community to share feedback, ask questions, and get assistance from other users and experts.

What license is this MCP server distributed under?

This MCP server is licensed under the MIT License. This allows free use, modification, and distribution of the software, subject to the terms and conditions of the MIT License.