odoo -by-cdata

This MCP server exposes Odoo data through a read-only MCP interface by wrapping the CData JDBC Driver for Odoo. It lets large language models query live Odoo data without needing to write SQL themselves, returning results in a structured format suitable for downstream reasoning. The server presents a small set of tools that allow you to discover available tables and columns, and to run read-only queries against the connected data source. Use it to ask natural language questions and have the agent translate them into the appropriate tool calls.

Available tools follow a naming convention based on the server name (odoo). The primary tools are: odoo_get_tables, which lists the tables accessible from the Odoo data source; odoo_get_columns, which lists the columns for a specified table; and odoo_run_query, which executes a SQL SELECT query against the data source. In practice you typically let the AI client invoke these tools implicitly by asking questions, but you can script exact JSON-RPC calls if you need to test or automate queries.

Prerequisites:

• Java runtime environment (JRE/JDK) installed on the host machine where the MCP server will run.
• Maven (for building the MCP server from source).
• Access to download and install the CData JDBC Driver for Odoo.

Install and run steps:

1. Clone the repository: git clone https://github.com/cdatasoftware/odoo-mcp-server-by-cdata.git cd odoo-mcp-server-by-cdata

2. Build the MCP server from source: mvn clean install This will produce CDataMCP-jar-with-dependencies.jar (the MCP server binary).

3. Install the CData JDBC Driver for Odoo (per CData instructions):

   • Download the JDBC driver from the CData site: https://www.cdata.com/drivers/odoo/download/jdbc
   • Install the driver on your system following the vendor guidance.

4. Create a .prp configuration file for your JDBC connection (example odool_prp)

   • Ensure it contains the correct DriverPath, DriverClass, and JdbcUrl as shown in the README (odoo.prp example).

5. Run the MCP server: java -jar /path/to/CDataMCP-jar-with-dependencies.jar /path/to/odoo.prp

6. Configure Claude Desktop (or any MCP client) to connect to the running server using the generated config, e.g. by adding an entry under mcpServers with the appropriate command and arguments (see mcp_config example).

Tips and considerations:

• The MCP server operates over stdio; it is intended for clients running on the same machine. Ensure firewall and path access permit local communication.
• If you update the JDBC connection or prp file, restart the MCP server to pick up changes.
• If you have OAuth-enabled data sources, you may need to complete browser-based authentication during connection string setup.
• Use the provided JSON-RPC examples as a reference when scripting requests to the server (odoo_get_tables, odoo_get_columns, odoo_run_query).
• For troubleshooting, verify that the odoo.prp file paths and JdbcUrl are correct, and that the CData driver is licensed and accessible by the Java process.