{"id":"cdatasoftware-dynamics-365-business-central-mcp-server-by-cdata","name":"dynamics-365-business-central-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/dynamics-365-business-central-mcp-server-by-cdata","category":"infrastructure","subcategories":[],"tags":["mcp","data-access","dynamics-365-business-central","jdbc","stdio","read-only","cdata"],"what_it_does":"Provides a local, read-only MCP server (stdio-based) that exposes Dynamics 365 Business Central data through tools that wrap the CData JDBC Driver as relational SQL models. It supports discovering tables/columns and executing SELECT queries via MCP JSON-RPC tools.","use_cases":["Ask an AI client to retrieve live Business Central data without writing SQL","Build conversational analytics over Business Central entities (e.g., accounts, tickets, calendar events)","Quick local integration of Business Central read access into Claude Desktop via MCP"],"not_for":["Untrusted remote use (server is local/stdio and not described for remote hosting)","High-safety/least-privilege environments where write/delete/update are required","Applications needing a REST/HTTP API, webhooks, or server-side auth policies"],"best_when":"You need local, tool-based read access to Business Central for an MCP-capable desktop client on the same machine, and you can authenticate the underlying CData JDBC driver connection.","avoid_when":"You need robust operational controls (rate limits, audit logs, fine-grained authorization) beyond what the JDBC driver/Data source provides, or you require safe idempotent writes with clear retry semantics.","alternatives":["CData Connect AI (managed MCP platform)","CData MCP Server for Dynamics 365 Business Central (full read/write/update/delete/action)","Direct use of the CData JDBC driver from your own code (bypassing MCP)"],"af_score":50.0,"security_score":47.5,"reliability_score":22.5,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:49:07.322524+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":["Underlying CData JDBC Driver authentication (may be OAuth per README note)"],"oauth":true,"scopes":false,"notes":"README indicates that if the data source uses OAuth, authentication happens in a browser during connection-string setup. No explicit MCP-level auth or scope model is described."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"README discusses licensing the CData JDBC driver (trial or license key). No MCP pricing details are provided in the supplied content."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":50.0,"security_score":47.5,"reliability_score":22.5,"mcp_server_quality":58.0,"documentation_accuracy":70.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":70.0,"rate_limit_clarity":10.0,"tls_enforcement":90.0,"auth_strength":55.0,"scope_granularity":10.0,"dependency_hygiene":45.0,"secret_handling":35.0,"security_notes":"Uses HTTPS/TLS is implied for the JDBC driver connection, but MCP-level transport details are not specified beyond stdio. Authentication is delegated to the underlying CData JDBC driver; no MCP-layer auth, scopes, or per-tool authorization controls are described. The provided configuration requires storing/using JDBC connection information (including OAuth/credentials) in a local .prp file, with no guidance on secret redaction or secure storage. Read-only limitation reduces risk of data modification, but run_query still enables arbitrary SELECT access that can expose sensitive fields if the underlying account has broad permissions.","uptime_documented":0.0,"version_stability":30.0,"breaking_changes_history":40.0,"error_recovery":20.0,"idempotency_support":"false","idempotency_notes":"Server appears to be read-only MCP tools (get_tables/get_columns/run_query with SELECT). Idempotency for writes is not applicable; no retry/idempotency guidance is provided.","pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["Server uses stdio, so it must run on the same machine as the MCP client (e.g., Claude Desktop).","For OAuth-backed connections, an interactive browser auth step may be required when building the JDBC connection string.","Tool outputs are returned in CSV format for get_columns/get_tables, which agents may need to parse carefully.","Because the server runs a SQL SELECT via run_query, the client may generate expensive or broad queries; no cost/limit controls are documented."]}}