Odoo MCP Server by CData
@CDataSoftware
About Odoo MCP Server by CData
This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free [CData MCP Server for Odoo (beta)](https://www.cdata.com/download/download.aspx?sku=OEZK-V&type=beta).
Basic information
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"{classname_dash}": {
"command": "PATH\\TO\\java.exe",
"args": [
"-jar",
"PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
"PATH\\TO\\odoo.prp"
]
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is Odoo MCP Server by CData?
Odoo MCP Server by CData is a read-only Model Context Protocol (MCP) server that wraps the CData JDBC Driver for Odoo, exposing Odoo data as relational SQL models so LLMs like Claude Desktop can query live data through natural language.
How to use Odoo MCP Server by CData?
Clone the repository, build with Maven, install and license the CData JDBC Driver for Odoo, configure a .prp file with your JDBC connection string, then add the server to your client’s mcpServers config (e.g., Claude Desktop) and restart the client.
Key features of Odoo MCP Server by CData
- Read-only access to Odoo data through MCP interface
- Natural language querying — no SQL required from users
- Exposes Odoo tables and columns as discovery tools
- Backed by CData JDBC Driver for Odoo
- Uses stdio transport for local client-server communication
Use cases of Odoo MCP Server by CData
- Ask an LLM about correlations between opportunities and account industries
- Retrieve the count of open tickets in a specific Odoo project
- Query calendar events scheduled for today without writing SQL
FAQ from Odoo MCP Server by CData
Is this server read-only or read-write?
This server is read-only. For full read, write, update, delete, and action capabilities, CData offers a free beta MCP Server for Odoo.
What are the runtime and dependency requirements?
Java and Maven are required to build and run the server, and the CData JDBC Driver for Odoo must be installed and licensed separately.
What transport does the server use?
The server uses stdio transport, so it can only be used with clients running on the same machine.
How do I configure the connection to Odoo?
Create a .prp file with properties such as Prefix, ServerName, DriverPath, DriverClass (cdata.jdbc.odoo.OdooDriver), JdbcUrl, and Tables, then point the MCP server to that file.
What tools does the server expose?
Three tools are available: {servername}_get_tables, {servername}_get_columns, and {servername}_run_query for executing SQL SELECT queries.

Comments