{"id":"cdatasoftware-sage-cloud-accounting-mcp-server-by-cdata","name":"sage-cloud-accounting-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/sage-cloud-accounting-mcp-server-by-cdata","category":"api-gateway","subcategories":[],"tags":["mcp","sage-cloud-accounting","cdata","jdbc","data-integration","read-only","stdio","claude-desktop"],"what_it_does":"Provides a local MCP (Model Context Protocol) server that wraps the CData JDBC Driver for Sage Cloud Accounting, exposing the underlying data as MCP tools (get tables, get columns, run SQL SELECT) so an LLM client can query live accounting data without writing SQL manually.","use_cases":["Ask natural-language questions about Sage Cloud Accounting data (e.g., counts, summaries, relationships)","Discover available tables and columns in the Sage Cloud Accounting data model","Run ad-hoc read-only SQL SELECT queries via MCP to retrieve specific records and metrics"],"not_for":["Direct public/remote exposure to untrusted clients (the server is stdio/local-machine oriented)","Write/update/delete or action-based workflows (this MCP server is explicitly read-only)","High-assurance environments that require explicit documented security controls around auth, logging, and data minimization beyond the README"],"best_when":"Used on the same machine as an MCP-capable desktop client (e.g., Claude Desktop) to query Sage Cloud Accounting data in a local, read-oriented workflow via the CData JDBC connection.","avoid_when":"When you need a network-accessible service for many users/teams, strict auditability requirements, or when you cannot safely handle JDBC driver credentials and connection strings on the host machine.","alternatives":["Use a managed MCP platform/product from CData (as referenced in the README)","Use CData Connect AI (managed MCP)","Connect directly to Sage Cloud Accounting via CData JDBC from your own application (no MCP)"],"af_score":48.0,"security_score":43.2,"reliability_score":21.2,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:58:18.285759+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 authentication via the JDBC connection string (.prp config)","OAuth browser flow may be required depending on the underlying Sage Cloud Accounting data source configuration"],"oauth":true,"scopes":false,"notes":"Authentication is delegated to the underlying CData JDBC Driver. The MCP server itself is local and relies on the connection string provided in the .prp file."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"README indicates licensing is required for the CData JDBC Driver; MCP server itself is distributed under MIT, but driver licensing costs are likely separate."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":48.0,"security_score":43.2,"reliability_score":21.2,"mcp_server_quality":70.0,"documentation_accuracy":65.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":55.0,"rate_limit_clarity":5.0,"tls_enforcement":60.0,"auth_strength":55.0,"scope_granularity":20.0,"dependency_hygiene":50.0,"secret_handling":30.0,"security_notes":"Authentication is handled via JDBC driver connection strings provided to the server in a local .prp file; the README does not document how secrets are stored or whether they are redacted from logs. The integration is local (stdio) which can reduce exposure, but the server may still process sensitive connection data and query results. No explicit mention of TLS settings, least-privilege scopes, or data access constraints beyond driver capabilities.","uptime_documented":0.0,"version_stability":40.0,"breaking_changes_history":10.0,"error_recovery":35.0,"idempotency_support":"false","idempotency_notes":"The MCP tools include a SQL SELECT query tool; reads are naturally idempotent. However, the server also states read-only capability and does not document idempotency semantics or safeguards for repeated calls.","pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["Server uses stdio, so it can only be used with clients running on the same machine.","Tables/columns discovery and query execution rely on the underlying JDBC driver mappings; large result sets may be slow or truncated depending on driver/MCP/client behavior.","The README does not describe MCP-side rate limits, timeouts, or error code conventions; agent behavior should be conservative when queries fail or time out."]}}