sftp-mcp-server-by-cdata
Provides a read-only MCP (Model Context Protocol) server that exposes SFTP data via CData JDBC Driver (JDBC models) to MCP-capable clients (e.g., Claude Desktop). It supports listing tables/columns and running SQL SELECT queries through MCP tool calls (stdio-based, same-machine clients).
Score Breakdown
⚙ Agent Friendliness
🔒 Security
Security posture depends largely on the underlying CData JDBC driver and how connection strings/secrets are stored in the local .prp file. The README does not describe transport security settings, secret storage practices (beyond embedding JDBC URL/credentials in config), or MCP-level authorization. Because the server runs locally over stdio, network exposure is reduced but local credential handling risk remains.
⚡ Reliability
Best When
You want an on-device MCP integration for querying SFTP data with SQL SELECT and you already have the CData JDBC SFTP driver licensed/configured.
Avoid When
You need multi-tenant or network-exposed access, strong per-user authorization, or you require CRUD beyond read-only queries.
Use Cases
- • Enable LLMs to query live SFTP data using natural language without writing SQL
- • Discovery workflows (list available tables and columns) for SFTP-backed datasets
- • Analytics/Q&A over SFTP-stored relational views created by the CData JDBC SFTP driver
Not For
- • Write/update/delete operations (the project is explicitly described as read-only)
- • Remote access over the network (uses stdio, so the client must run on the same machine)
- • Use cases requiring API keys/scopes or fine-grained authorization at the MCP layer (not described)
Interface
Authentication
Authentication is handled by the underlying CData JDBC connection string (the README notes OAuth may require browser authentication). The MCP server itself does not describe MCP-level auth, user identity, or scope enforcement.
Pricing
The README indicates you must license the CData JDBC Driver for SFTP; pricing for the driver is not included here.
Agent Metadata
Known Gotchas
- ⚠ Uses stdio; only works with clients running on the same machine.
- ⚠ README mentions you may need to fully quit/restart Claude Desktop for MCP servers to appear.
- ⚠ Tools return CSV for table/column discovery; agents must parse CSV safely.
- ⚠ Read-only limitation: the MCP server is intended for read (SELECT / schema discovery), not CRUD.
Alternatives
Full Evaluation Report
Comprehensive deep-dive: security analysis, reliability audit, agent experience review, cost modeling, competitive positioning, and improvement roadmap for sftp-mcp-server-by-cdata.
AI-powered analysis · PDF + markdown · Delivered within 30 minutes
Package Brief
Quick verdict, integration guide, cost projections, gotchas with workarounds, and alternatives comparison.
Delivered within 10 minutes
Score Monitoring
Get alerted when this package's AF, security, or reliability scores change significantly. Stay ahead of regressions.
Continuous monitoring
Scores are editorial opinions as of 2026-04-04.