{"id":"cdatasoftware-sage-200-mcp-server-by-cdata","name":"sage-200-mcp-server-by-cdata","af_score":52.2,"security_score":35.2,"reliability_score":25.0,"what_it_does":"Provides a local, read-only MCP server that exposes Sage 200 data via CData’s JDBC Driver. It wraps the JDBC driver and exposes MCP tools to list tables/columns and run SQL SELECT queries (JSON-RPC tool calls) for use by local MCP-capable clients (e.g., Claude Desktop).","best_when":"You have Sage 200 access via the CData JDBC Driver and want a local MCP integration to query current operational data without crafting SQL manually.","avoid_when":"You need secure remote exposure over the network, strong API-level governance (rate limits, audit trails), or robust operational guarantees (SLA, retries, structured error codes).","last_evaluated":"2026-04-04T19:59:06.141485+00:00","has_mcp":true,"has_api":false,"auth_methods":["CData JDBC Driver licensing step (java -jar ... --license)","JDBC connection string authentication (may include OAuth in the connection string, per README note)","Local MCP server config via .prp file (includes DriverPath, DriverClass, JdbcUrl)"],"has_free_tier":false,"known_gotchas":["Uses stdio, so it can only be used by clients running on the same machine as the server.","Local-only setup requires restarting/refreshing the client to discover MCP servers.","Only read-only behavior is described locally; agents should avoid assuming write capabilities.","run_query accepts arbitrary SQL SELECT; agents may generate expensive queries or unintentionally query too much data without guidance/limits."],"error_quality":0.0}