{"id":"cdatasoftware-exact-online-mcp-server-by-cdata","name":"exact-online-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/exact-online-mcp-server-by-cdata","category":"ai-ml","subcategories":[],"tags":["mcp","exact-online","cdata","jdbc","stdio","read-only","data-access","llm-integration"],"what_it_does":"Provides a locally hosted, read-only MCP server that exposes Exact Online data (via CData’s JDBC Driver for Exact Online) as MCP tools for listing tables/columns and executing SQL SELECT queries.","use_cases":["Query Exact Online live data from an MCP-capable client (e.g., Claude Desktop)","Natural-language retrieval over relational-style views exposed by the CData JDBC driver","Exploratory discovery of available tables and columns for Exact Online data"],"not_for":["Directly exposing a public/remote API endpoint (server is stdio/local)","Providing secure multi-tenant access over a network without additional infrastructure","Performing full CRUD actions (server is described as read-only)"],"best_when":"You can run the MCP server on the same machine as the MCP client and you already have the required CData JDBC driver + credentials configured.","avoid_when":"You need a network-accessible MCP/HTTP endpoint, strong documented operational guarantees (SLA, rate limits), or you require write/CRUD operations from this specific package.","alternatives":["CData’s managed/remote MCP platform (CData Connect AI)","CData’s full local MCP server for Exact Online with read/write/update/delete capabilities (as referenced in the README)","Using the Exact Online APIs directly or via a different integration (non-MCP) that better matches your security/hosting model"],"af_score":43.0,"security_score":35.2,"reliability_score":27.5,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:58:37.772875+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/connection string (including possible OAuth in the JDBC layer)","CData JDBC Driver license activation (run java -jar ... --license)","OAuth flows are triggered via the JDBC driver’s connection string (browser-based, per README note)"],"oauth":true,"scopes":false,"notes":"Authentication details are handled by the underlying CData JDBC driver; the MCP wrapper itself relies on a local .prp configuration that includes the JDBC URL/connection string."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":["Requires a licensed CData JDBC Driver for Exact Online (and likely Exact Online credentials via the JDBC layer)"],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"No free tier or pricing numbers are provided in the README content shown; cost depends on CData JDBC driver licensing and your Exact Online account/quotas."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":43.0,"security_score":35.2,"reliability_score":27.5,"mcp_server_quality":55.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":40.0,"auth_strength":45.0,"scope_granularity":20.0,"dependency_hygiene":40.0,"secret_handling":30.0,"security_notes":"The MCP server runs locally over stdio (reducing network exposure), but the README instructs embedding/placing a JDBC connection string and requires a JDBC driver license/auth setup. No guidance is provided on secret storage, log redaction, least-privilege, or how OAuth tokens are stored/handled by the JDBC driver. Rate limiting and operational safety controls are not documented at the MCP layer.","uptime_documented":0.0,"version_stability":50.0,"breaking_changes_history":30.0,"error_recovery":30.0,"idempotency_support":"false","idempotency_notes":"The exposed tools include run_query (SELECT) and metadata fetches; while SELECTs are inherently non-mutating, the server is described as read-only overall. No explicit idempotency guidance is provided.","pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["Server uses stdio; only works with clients running on the same machine.","Read-only tools only: despite generic phrasing elsewhere, this specific project is stated as read-only; agents expecting writes/CRUD may fail.","Large/slow queries may be problematic because the interface encourages natural-language-to-SQL without explicit safeguards, limits, or result pagination (not documented)."]}}