{"id":"cdatasoftware-odoo-mcp-server-by-cdata","name":"odoo-mcp-server-by-cdata","homepage":null,"repo_url":"https://github.com/CDataSoftware/odoo-mcp-server-by-cdata","category":"api-gateway","subcategories":[],"tags":["mcp","odoo","cdata","jdbc","agent-tools","stdio","read-only","data-integration"],"what_it_does":"Provides a local MCP Server (stdio-based) that exposes Odoo data via CData’s JDBC Driver. It supplies MCP tools to list tables/columns and run read queries (and documentation mentions CRUD generally, but tools listed are get_tables/get_columns/run_query).","use_cases":["Ask an MCP-capable desktop agent to query live Odoo data without writing SQL","Discover available Odoo tables and fields via get_tables/get_columns","Run ad-hoc read-only SQL SELECT queries against Odoo through the CData JDBC layer"],"not_for":["Public/remote MCP exposure (server is designed for local clients via stdio)","Fine-grained, parameterized querying without SQL (run_query takes raw SQL)","Environments needing documented rate limiting, pagination, or robust tool-level error codes"],"best_when":"You have local access to the MCP client (e.g., Claude Desktop) and want an agent to browse and query Odoo data through the CData JDBC Driver.","avoid_when":"You need secure remote access, strict governance/auditing around arbitrary SQL, or you require documented operational guarantees (SLA, versioning policy).","alternatives":["CData’s managed “Connect AI” MCP platform (mentioned as remote alternative)","CData’s dedicated Odoo MCP Server for full read/write/delete/action capabilities (vendor link mentioned)","Build your own MCP server/wrapper around Odoo APIs with parameterized queries and server-side auth","Use direct Odoo integration (RPC/REST) with an agent tool layer you control"],"af_score":47.0,"security_score":36.2,"reliability_score":21.2,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T19:49:43.586180+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 configured via .prp (may include OAuth per JDBC driver documentation note)","OAuth handled by JDBC driver (browser-based) as indicated in setup notes"],"oauth":true,"scopes":false,"notes":"Authentication is delegated to the underlying CData JDBC Driver; the MCP server itself is configured to run with a local .prp file containing connection details. No MCP-level auth/scopes are described in the README."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"README describes licensing the CData JDBC Driver (trial or license key). Pricing for the MCP server/platform is not provided here."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":47.0,"security_score":36.2,"reliability_score":21.2,"mcp_server_quality":65.0,"documentation_accuracy":70.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":55.0,"rate_limit_clarity":10.0,"tls_enforcement":40.0,"auth_strength":55.0,"scope_granularity":10.0,"dependency_hygiene":50.0,"secret_handling":25.0,"security_notes":"Security controls are largely inherited from the CData JDBC Driver and the Odoo environment; the README does not describe TLS enforcement at the MCP layer, MCP authentication/authorization, scope granularity, audit logging, or secret-handling practices. The server executes raw SQL via run_query, increasing risk if an agent can submit arbitrary statements (even if the project is described as read-only).","uptime_documented":0.0,"version_stability":45.0,"breaking_changes_history":20.0,"error_recovery":20.0,"idempotency_support":"false","idempotency_notes":null,"pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["The server uses stdio; it can only be used by clients running on the same machine as the server.","The README lists tools that execute SQL; agents should avoid unsafe/over-broad SQL and must be mindful of quoting and table/field naming.","Tool outputs are described as CSV for get_tables/get_columns, which an agent may need to parse reliably."]}}