{"id":"cdatasoftware-sage-200-mcp-server-by-cdata","name":"sage-200-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/sage-200-mcp-server-by-cdata","category":"devtools","subcategories":[],"tags":["mcp","sage-200","jdbc","data-integration","read-only","stdio","claude-desktop"],"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).","use_cases":["Ask natural-language questions to retrieve live Sage 200 data through an MCP client","Explore available Sage 200 tables and columns via MCP tools","Run read-only SQL SELECT queries against Sage 200 using CData JDBC under the hood"],"not_for":["Write/update/delete operations (described as read-only locally)","Use from remote machines (stdio-based local-only connectivity)","Production-grade automation requiring explicit pagination/rate-limit handling via an HTTP API"],"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).","alternatives":["CData’s managed MCP platform (CData Connect AI) for remote/full capabilities","Use CData JDBC directly with your own application (no MCP layer)","Build a custom MCP server around a Sage 200 connector or SQL views for narrower, safer access"],"af_score":52.2,"security_score":35.2,"reliability_score":25.0,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:59:06.141485+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 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)"],"oauth":true,"scopes":false,"notes":"Authentication is handled by the underlying CData JDBC Driver via the provided JDBC connection string; OAuth may be used depending on the data source configuration. The MCP server itself is local and relies on the client running on the same machine via stdio."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"README does not describe pricing for the MCP server itself. It references licensing the CData JDBC Driver."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":52.2,"security_score":35.2,"reliability_score":25.0,"mcp_server_quality":78.0,"documentation_accuracy":70.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":55.0,"rate_limit_clarity":0.0,"tls_enforcement":20.0,"auth_strength":55.0,"scope_granularity":20.0,"dependency_hygiene":50.0,"secret_handling":30.0,"security_notes":"Local stdio reduces network exposure, but security is still driven by the JDBC connection string and the environment (.prp file). The README includes an example .prp that contains DriverPath and JdbcUrl (which may embed credentials or OAuth parameters), but provides no guidance on secret storage, redaction, or least-privilege scoping. No explicit TLS, scope granularity, or rate-limit/audit controls are documented. SQL execution tool could lead to data over-exfiltration if used injudiciously, and the repo documentation does not describe query/result limits or defensive filtering.","uptime_documented":0.0,"version_stability":40.0,"breaking_changes_history":30.0,"error_recovery":30.0,"idempotency_support":"false","idempotency_notes":"Server tools are read-oriented (get_tables/get_columns/run_query with SELECT). No stated idempotency guarantees; also no explicit guidance for retries.","pagination_style":"none","retry_guidance_documented":false,"known_agent_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."]}}