Frequently Asked Questions (FAQ) about UBOS MCP Server for Microsoft SQL Server

Q: What is an MCP Server? A: MCP (Model Context Protocol) is an open protocol standardizing how applications provide context to LLMs. The MCP Server acts as a bridge, enabling AI models to access and interact with external data sources and tools like Microsoft SQL Server.

Q: What is the purpose of the UBOS MCP Server for Microsoft SQL Server? A: This MCP Server allows Large Language Models (LLMs) like Claude to query live data from Microsoft SQL Server using natural language. It eliminates the need for complex SQL queries.

Q: Is this MCP Server read-only? A: Yes, this specific MCP Server is read-only. However, CData offers a free beta version of their MCP Server with full read/write capabilities.

Q: What is the CData JDBC Driver and why is it required? A: The CData JDBC Driver connects to Microsoft SQL Server and exposes the data as relational SQL models. The MCP Server wraps this driver to make the data accessible through a simple MCP interface.

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

Q: Where do I find the CData JDBC Driver for Microsoft SQL Server? A: You can download the driver from the CData website: https://www.cdata.com/drivers/sql/download/jdbc

Q: What information do I need to configure the .prp file? A: The .prp file requires the following properties: Prefix, ServerName, ServerVersion, DriverPath, DriverClass, JdbcUrl, and Tables. See the Setup Guide in the documentation for details.

Q: How do I configure Claude Desktop to use the MCP Server? A: You need to modify the claude_desktop_config.json file to add the new MCP server, specifying the command and arguments to run the MCP Server JAR file with the .prp file.

Q: My AI client cannot see the MCP Server. What should I do? A: Ensure that you have fully quit and restarted your AI client (e.g., Claude Desktop). Sometimes, a simple refresh is not enough.

Q: I am having trouble connecting to my data source. What should I do? A: Use the Connection String builder provided with the CData JDBC Driver to create the connection string and verify your credentials. If you still have issues, contact the CData Support Team.

Q: Where can I get help or provide feedback? A: You can join the CData Community forum for support and feedback: https://community.cdata.com

Q: What is UBOS? A: UBOS is a full-stack AI Agent Development Platform focused on bringing AI Agents to every business department. It helps you orchestrate AI Agents, connect them with enterprise data, build custom AI Agents with your LLM model and Multi-Agent Systems.

Q: How does UBOS relate to the MCP Server? A: The UBOS platform can leverage the data exposed by the MCP Server to build and orchestrate intelligent AI Agents. UBOS provides the tools and infrastructure for developing AI applications that can utilize the data accessed through the MCP Server.

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