Question 1

What is an MCP Server?

Accepted Answer

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.

Question 2

What is the purpose of the UBOS MCP Server for Microsoft SQL Server?

Accepted Answer

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.

Question 3

Is this MCP Server read-only?

Accepted Answer

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

Question 4

What is the CData JDBC Driver and why is it required?

Accepted Answer

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.

Question 5

How do I set up the UBOS MCP Server for Microsoft SQL Server?

Accepted Answer

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.

Question 6

Where do I find the CData JDBC Driver for Microsoft SQL Server?

Accepted Answer

You can download the driver from the CData website: [https://www.cdata.com/drivers/sql/download/jdbc](https://www.cdata.com/drivers/sql/download/jdbc)

Question 7

What information do I need to configure the `.prp` file?

Accepted Answer

The `.prp` file requires the following properties: `Prefix`, `ServerName`, `ServerVersion`, `DriverPath`, `DriverClass`, `JdbcUrl`, and `Tables`. See the Setup Guide in the documentation for details.

Question 8

How do I configure Claude Desktop to use the MCP Server?

Accepted Answer

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.

Question 9

My AI client cannot see the MCP Server. What should I do?

Accepted Answer

Ensure that you have fully quit and restarted your AI client (e.g., Claude Desktop). Sometimes, a simple refresh is not enough.

Question 10

I am having trouble connecting to my data source. What should I do?

Accepted Answer

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.

Question 11

Where can I get help or provide feedback?

Accepted Answer

You can join the CData Community forum for support and feedback: [https://community.cdata.com](https://community.cdata.com)

Question 12

What is UBOS?

Accepted Answer

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.

Question 13

How does UBOS relate to the MCP Server?

Accepted Answer

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.

Question 14

What license is the MCP Server released under?

Accepted Answer

The MCP server is licensed under the MIT License.

Microsoft SQL Server MCP Server by CData

Resources

Project Details

Recomended MCP Servers

Featured Templates

Pharmacy Admin Panel

AI-Powered Product List Manager

Calculate Time Complexity with ChatGPT API

Image to text with Claude 3

Unified Authorization Template

AI Chatbot Starter Kit

Start your free trial