Frequently Asked Questions about CData MCP Server for xBase

Q: What is the CData MCP Server for xBase? A: The CData MCP Server for xBase is a server that allows Large Language Models (LLMs) like Claude Desktop to query live xBase data (a database file format) through the Model Context Protocol (MCP). It uses the CData JDBC Driver for xBase to expose xBase data as relational SQL models, making it accessible to AI.

Q: What is MCP? A: MCP stands for Model Context Protocol. It’s an open protocol that standardizes how applications provide context to LLMs, allowing them to understand and interact with data from various sources.

Q: What are the benefits of using the CData MCP Server for xBase? A: Key benefits include democratizing data access (making it accessible to non-SQL users), accelerating AI adoption by simplifying connections to legacy data, enhancing decision-making with faster insights, and automating data-driven tasks.

Q: Can I write data back to my xBase database using this server? A: The version described in the documentation is a read-only server. However, CData offers a free (beta) read/write server with full capabilities. Check the CData website for the beta version.

Q: What is the CData JDBC Driver for xBase? A: The CData JDBC Driver for xBase is a driver that connects to xBase databases and exposes them as relational SQL models. It allows standard SQL queries to be used to retrieve and manipulate xBase data.

Q: How do I set up the CData MCP Server for xBase? A: The setup involves cloning the repository, building the server with Maven, downloading and licensing the CData JDBC Driver, configuring the connection string, creating a .prp file with connection properties, and configuring your AI client (e.g., Claude Desktop) to use the server.

Q: What is a .prp file? A: A .prp file is a properties file that contains the configuration details for your JDBC connection, including the driver path, class name, JDBC URL, server name, prefix, and tables to expose.

Q: How do I configure Claude Desktop to use the CData MCP Server for xBase? A: You need to add an entry to the mcpServers section in the claude_desktop_config.json file, specifying the command to run the server and the path to the .prp file. You might need to copy the config file to the appropriate directory for Claude Desktop.

Q: What if I can’t see the CData MCP Server in Claude Desktop? A: Make sure you have fully quit Claude Desktop (using Task Manager on Windows or Activity Monitor on Mac) and restarted it.

Q: What do I do if Claude Desktop is unable to retrieve data? A: Double-check that your connection is configured properly, using the Connection String builder to create the connection string and copying it into the .prp file.

Q: Where can I get help if I’m having trouble connecting to my data source? A: Contact the CData Support Team.

Q: Where can I get help with using the MCP server? A: Join the CData Community.

Q: What tools are available in the MCP Server? A: The MCP Server provides tools like {servername}_get_tables (to list available tables), {servername}_get_columns (to list columns for a specific table), and {servername}_run_query (to execute SQL SELECT queries). Replace {servername} with the name you gave the server in your configuration file.

Q: What license is the MCP server released under? A: The MCP server is licensed under the MIT License.

Q: How does the CData MCP Server integrate with UBOS? A: Integrating with UBOS allows you to orchestrate multiple AI Agents, build custom AI Agents with access to xBase data, integrate your own LLM models, create Multi-Agent Systems that share xBase data, and leverage UBOS’s robust data security and governance features.