{"id":"cdatasoftware-sage-300-mcp-server-by-cdata","name":"sage-300-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/sage-300-mcp-server-by-cdata","category":"data-access","subcategories":[],"tags":["mcp","sage300","jdbc","read-only","data-access","ai-integration","stdio"],"what_it_does":"Provides a read-only Model Context Protocol (MCP) server that exposes Sage 300 data as SQL-like tables/columns via CData JDBC. Intended for LLM clients (e.g., Claude Desktop) to query live Sage 300 data through MCP tools (get_tables, get_columns, run_query).","use_cases":["Ask natural-language questions about Sage 300 data (e.g., counts, correlations, status metrics).","Retrieve schemas (tables/columns) to discover available Sage 300 datasets for analysis.","Run controlled read-only SQL SELECT queries against Sage 300 through an MCP tool interface."],"not_for":["Writing/creating/updating/deleting Sage 300 data (explicitly read-only in this repo).","Use as a remote network API (it uses stdio and is intended for co-located clients).","High-security or multi-tenant deployments without additional controls (secrets and access control are not described at the MCP layer)."],"best_when":"You have local access to a Sage 300 environment, want an MCP-compatible local bridge to query live data with an LLM desktop client, and only need read operations.","avoid_when":"You need robust, documented error/retry/rate-limit behavior for production automation, you need fine-grained row/column authorization enforced at the MCP layer, or you require a network-accessible API with standard security controls.","alternatives":["CData’s (full CRUD) MCP Server for Sage 300 (as referenced in the README).","Direct access to Sage 300 via CData JDBC from your own application (avoid MCP tooling).","A generic SQL gateway/ORM approach where an LLM queries a read-only reporting replica with strict query allowlists."],"af_score":51.2,"security_score":27.8,"reliability_score":23.8,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:58:40.285528+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":["MCP server runs locally using a local .prp configuration that includes a JDBC connection string to the CData JDBC Driver."],"oauth":false,"scopes":false,"notes":"The README indicates authentication is handled by the underlying CData JDBC driver/connection string (it mentions OAuth in the generic JDBC connection string setup note). The MCP layer itself does not document authentication/authorization controls."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"CData JDBC driver licensing is required (README instructs to license the JDBC driver). MCP server itself is MIT-licensed, but runtime depends on the commercial JDBC driver license."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":51.2,"security_score":27.8,"reliability_score":23.8,"mcp_server_quality":78.0,"documentation_accuracy":72.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":55.0,"rate_limit_clarity":10.0,"tls_enforcement":20.0,"auth_strength":35.0,"scope_granularity":10.0,"dependency_hygiene":40.0,"secret_handling":35.0,"security_notes":"Uses local stdio MCP transport (no network exposure implied), but the README does not document MCP-level authentication/authorization, scope enforcement, query allowlisting, or secret handling/logging behavior. Connection credentials are supplied via a local .prp/JdbcUrl string and JDBC driver licensing/auth; the README does not describe how those secrets are protected from logs or process inspection. TLS enforcement is not described for the MCP layer or JDBC connection (depends on JDBC URL/driver configuration).","uptime_documented":0.0,"version_stability":35.0,"breaking_changes_history":40.0,"error_recovery":20.0,"idempotency_support":"false","idempotency_notes":"The MCP tools include schema discovery and SELECT queries; idempotency for reads is generally expected, but the README does not state idempotency/retry semantics or whether the server/driver retries safely.","pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["The server uses stdio, so it can only be used by clients running on the same machine as the MCP server process.","Tools operate by passing SQL to run_query; agents may generate expensive queries unless constrained.","The repo is read-only; attempts to perform write/update/delete actions are not supported by this server.","Claude Desktop may need a full restart/quit to detect new MCP servers."]}}