Frequently Asked Questions (FAQ) About CData MCP Server for SingleStore

Q: What is the CData MCP Server for SingleStore? A: It’s a Model Context Protocol (MCP) server that allows you to connect to SingleStore data from Claude Desktop through CData JDBC Drivers, enabling natural language queries of your data.

Q: What is MCP? A: MCP (Model Context Protocol) is an open protocol that standardizes how applications provide context to LLMs, allowing AI models to interact with external data sources and tools.

Q: Is this a read-only server? A: Yes, this particular version is a read-only MCP server. For full read/write capabilities, check out the free CData MCP Server for SingleStore (beta) at https://www.cdata.com/download/download.aspx?sku=JMZK-V&type=beta.

Q: What is a JDBC Driver? A: A JDBC (Java Database Connectivity) driver allows Java applications, like the MCP Server, to connect to and interact with databases.

Q: Do I need a license for the CData JDBC Driver? A: Yes, you need to license the CData JDBC Driver. You can use a trial license by entering “TRIAL” during the licensing process.

Q: How do I configure the connection to my SingleStore database? A: Use the Connection String utility provided with the CData JDBC Driver to create a connection string and then configure a .prp file with the connection details.

Q: How do I integrate the MCP Server with Claude Desktop? A: Add a new entry for the MCP Server to the mcpServers section of the claude_desktop_config.json file.

Q: What if I can’t see the CData MCP Server in Claude Desktop? A: Make sure you have fully quit and restarted Claude Desktop. You may need to use Task Manager (Windows) or Activity Monitor (Mac) to ensure the application is completely closed.

Q: What if Claude Desktop is unable to retrieve data? A: Double-check your connection string in the .prp file and ensure the JDBC driver is correctly licensed.

Q: Where can I get help if I have trouble connecting to my data source? A: Contact the CData Support Team at https://www.cdata.com/support/submit.aspx.

Q: Where can I get help if I have trouble using the MCP server, or have any other feedback? A: Join the CData Community at https://community.cdata.com.

Q: What kind of queries can I perform? A: You can use natural language to ask questions about your SingleStore data, such as “What is the correlation between my closed won opportunities and the account industry?” or “How many open tickets do I have in the SUPPORT project?”

Q: What tools are available through the MCP Server? A: The MCP Server provides tools for retrieving tables ({servername}_get_tables), retrieving columns ({servername}_get_columns), and running SQL queries ({servername}_run_query).