odoo-mcp-server-by-cdata
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).
Score Breakdown
⚙ Agent Friendliness
🔒 Security
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).
⚡ Reliability
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).
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
Interface
Authentication
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
README describes licensing the CData JDBC Driver (trial or license key). Pricing for the MCP server/platform is not provided here.
Agent Metadata
Known 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.
Alternatives
Full Evaluation Report
Comprehensive deep-dive: security analysis, reliability audit, agent experience review, cost modeling, competitive positioning, and improvement roadmap for odoo-mcp-server-by-cdata.
AI-powered analysis · PDF + markdown · Delivered within 30 minutes
Package Brief
Quick verdict, integration guide, cost projections, gotchas with workarounds, and alternatives comparison.
Delivered within 10 minutes
Score Monitoring
Get alerted when this package's AF, security, or reliability scores change significantly. Stay ahead of regressions.
Continuous monitoring
Scores are editorial opinions as of 2026-04-04.