{"id":"cdatasoftware-sftp-mcp-server-by-cdata","name":"sftp-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/sftp-mcp-server-by-cdata","category":"storage","subcategories":[],"tags":["mcp","sftp","jdbc","llm","stdio","read-only","data-access"],"what_it_does":"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).","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)"],"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.","alternatives":["Use CData’s other MCP Server offering for SFTP with full CRUD (linked in README)","Build a custom MCP server wrapping a JDBC/ODBC layer for your environment","Use a direct database-like connector/viewing layer and query via a standard SQL API rather than MCP"],"af_score":51.8,"security_score":29.5,"reliability_score":28.8,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:49:40.694884+00:00","interface":{"has_rest_api":false,"has_graphql":false,"has_grpc":false,"has_mcp_server":true,"mcp_server_url":null,"has_sdk":false,"sdk_languages":[],"openapi_spec_url":null,"webhooks":false},"auth":{"methods":["CData JDBC Driver licensing (java -jar cdata.jdbc.sftp.jar --license)","Connection-string-based authentication supported by the underlying CData JDBC SFTP driver (may include OAuth per README note)","MCP client runs locally via stdio; no separate MCP auth described"],"oauth":true,"scopes":false,"notes":"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":{"model":"Commercial (CData JDBC Driver licensing mentioned;","free_tier_exists":false,"free_tier_limits":null,"paid_tiers":["CData JDBC Driver for SFTP (license required)"],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"The README indicates you must license the CData JDBC Driver for SFTP; pricing for the driver is not included here."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":51.8,"security_score":29.5,"reliability_score":28.8,"mcp_server_quality":80.0,"documentation_accuracy":75.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":55.0,"rate_limit_clarity":10.0,"tls_enforcement":30.0,"auth_strength":35.0,"scope_granularity":20.0,"dependency_hygiene":45.0,"secret_handling":20.0,"security_notes":"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.","uptime_documented":0.0,"version_stability":45.0,"breaking_changes_history":40.0,"error_recovery":30.0,"idempotency_support":"false","idempotency_notes":null,"pagination_style":"none","retry_guidance_documented":false,"known_agent_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."]}}