Question 1

What is an MCP Server?

Accepted Answer

MCP (Model Context Protocol) is an open protocol that standardizes how applications provide context to LLMs. An MCP Server acts as a bridge, allowing AI models to access and interact with external data sources and tools.

Question 2

What does the CData SFTP MCP Server do?

Accepted Answer

This server allows Large Language Models (LLMs) like Claude Desktop to query live data from SFTP servers. It uses the CData JDBC Driver for SFTP to expose SFTP data as relational SQL models, enabling natural language queries.

Question 3

Is this server read-only?

Accepted Answer

Yes, this particular version of the server is read-only, ensuring data integrity. A free (beta) read/write version is available at https://www.cdata.com/solutions/mcp.

Question 4

What is the CData JDBC Driver for SFTP?

Accepted Answer

The CData JDBC Driver for SFTP is a software component that enables connectivity to SFTP data sources using standard JDBC (Java Database Connectivity) protocol. It translates SQL queries into SFTP commands.

Question 5

Do I need a license for the CData JDBC Driver?

Accepted Answer

Yes, you need to license the driver. You can use a trial license or purchase a full license from CData.

Question 6

How do I configure the connection to my SFTP server?

Accepted Answer

You use the Connection String utility provided with the CData JDBC Driver to create a connection string. This string contains the necessary information to connect to your SFTP server, such as server address, port, username, and password.

Question 7

What is a `.prp` file?

Accepted Answer

A `.prp` file is a properties file that contains configuration information for the MCP Server, including the JDBC driver path, driver class, JDBC connection string, server name, and other settings.

Question 8

How do I integrate the MCP Server with Claude Desktop?

Accepted Answer

You need to add an entry for the MCP Server in the `claude_desktop_config.json` file, specifying the path to the Java executable, the JAR file, and the `.prp` file.

Question 9

What tools are available through the MCP Server?

Accepted Answer

The server exposes the following tools:n* `{servername}_get_tables`: Retrieves a list of tables.n* `{servername}_get_columns`: Retrieves a list of columns for a table.n* `{servername}_run_query`: Executes a SQL SELECT query.

Question 10

How do I troubleshoot connection problems?

Accepted Answer

Verify that you have fully quit and restarted Claude Desktop. Double-check the `claude_desktop_config.json` file for any typos or incorrect paths. Ensure that your JDBC connection string in the `.prp` file is correct. Use the Connection String builder to test the connection. Also, confirm your SFTP server is accessible.

Question 11

Where can I get help if I have problems?

Accepted Answer

For problems connecting to your data source, contact the CData Support Team (https://www.cdata.com/support/submit.aspx). For MCP server issues or feedback, join the CData Community (https://community.cdata.com).

Question 12

Can I use this server with other AI clients besides Claude Desktop?

Accepted Answer

While designed for Claude Desktop, the server, using the MCP protocol, could potentially be used with other AI clients that support the MCP protocol and can run on the same machine as the server.

Question 13

What kind of queries can I run?

Accepted Answer

You can run any `SELECT` SQL query that is supported by the CData JDBC Driver for SFTP. The AI client will translate natural language questions into SQL.

Question 14

Where does UBOS fit into this?

Accepted Answer

UBOS is a full-stack AI Agent Development Platform that makes it easier to orchestrate AI Agents, connect them with enterprise data (like SFTP through this MCP Server), build custom AI Agents with your LLM model and build Multi-Agent Systems.

SFTP MCP Server by CData

Resources

Project Details

Recomended MCP Servers

Featured Templates

AI Chat Bot: Text, Voice, and Video Magic

Multi-language AI Translator

AI Video Generator

AI-Powered Essay Outline Generator

Talk with Claude 3

Speech to Text

Start your free trial