Frequently Asked Questions about CData’s MCP Server for Phoenix and UBOS

Q: What is the CData MCP Server for Phoenix? A: The CData MCP Server for Phoenix is a tool that allows Large Language Models (LLMs) like Claude to query live data from Phoenix databases. It exposes Phoenix data as relational SQL models, enabling LLMs to retrieve information using natural language questions.

Q: What is UBOS? A: UBOS is a full-stack AI Agent development platform that helps you orchestrate AI Agents, connect them with your enterprise data, build custom AI Agents with your LLM model, and create Multi-Agent Systems.

Q: How does the MCP Server work? A: The MCP Server acts as a bridge between LLMs and Phoenix data. It uses the CData JDBC Driver for Phoenix to connect to the database and exposes the data through a standardized Model Context Protocol (MCP) interface. LLMs can then use this interface to query the data using natural language.

Q: What are the benefits of using the MCP Server? A: The benefits include:

• Enabling LLMs to access and query live Phoenix data.
• Allowing users to retrieve data using natural language questions.
• Eliminating the need for complex SQL queries.
• Providing a standardized interface for LLM integration.

Q: What is the difference between the free and beta versions of the MCP Server? A: The free version provides read-only access to Phoenix data, while the beta version offers read/write capabilities.

Q: How do I set up the MCP Server? A: The setup process involves:

1. Cloning the repository.
2. Building the server using Maven.
3. Downloading and licensing the CData JDBC Driver for Phoenix.
4. Configuring the connection to your Phoenix data source.
5. Creating a .prp file with the connection properties.

Q: How do I use the MCP Server with Claude Desktop? A: You need to create a config file (claude_desktop_config.json) for Claude Desktop and add the MCP Server entry to the mcpServers section. Then, run or refresh your Claude Desktop client.

Q: What is the Model Context Protocol (MCP)? A: MCP is an open protocol that standardizes how applications provide context to LLMs. It allows LLMs to access and interact with external data sources and tools in a consistent manner.

Q: What kind of data sources are supported besides Phoenix? A: The server supports a wide array of data sources; including Access, Excel, SalesForce, MySQL, PostgreSQL, REST APIs, and many more. See the ‘All Supported Sources’ table for a more comprehensive list.

Q: What if I have trouble connecting to my data source? A: Contact the CData Support Team for assistance.

Q: What if I have trouble using the MCP Server? A: Join the CData Community for support and feedback.

Q: How does UBOS enhance the capabilities of the MCP Server? A: UBOS provides a comprehensive platform for developing, orchestrating, and deploying AI Agents that can leverage the data exposed by the MCP Server. It offers features such as visual workflow design, data integration connectors, LLM integration, and custom AI Agent development.

Q: Can I use the MCP server on a different machine from the AI client? A: No, the server uses stdio so can only be used with clients that run on the same machine as the server.