Integrate Cursor with Live Odoo Data via CData Connect AI

Yazhini G
Technical Marketing Engineer

Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Odoo data from within the editor.

Cursor is an AI-powered code editor that embeds conversational and agent-style assistance alongside your development workflow. By extending Cursor with MCP (Model Context Protocol) tools, you can give its AI agents secure access to external systems such as APIs and databases.

Integrating Cursor with CData Connect AI via the built-in CData MCP Server allows the editor's AI to query, analyze, and act on live Odoo data without copying data into the IDE. The result is a development experience where you can chat with your governed enterprise data directly from Cursor.

This article outlines how to configure Odoo connectivity in Connect AI, generate the required access token, register the CData MCP Server in Cursor, and then use the AI chat pane to explore live Odoo data.

About Odoo Data Integration

Accessing and integrating live data from Odoo has never been easier with CData. Customers rely on CData connectivity to:

Access live data from both Odoo API 8.0+ and Odoo.sh Cloud ERP.
Extend the native Odoo features with intelligent handling of many-to-one, one-to-many, and many-to-many data properties. CData's connectivity solutions also intelligently handle complex data properties within Odoo. In addition to columns with simple values like text and dates, there are also columns that contain multiple values on each row. The driver decodes these kinds of values differently, depending upon the type of column the value comes from:
- Many-to-one columns are references to a single row within another model. Within CData solutions, many-to-one columns are represented as integers, whose value is the ID to which they refer in the other model.
- Many-to-many columns are references to many rows within another model. Within CData solutions, many-to-many columns are represented as text containing a comma-separated list of integers. Each value in that list is the ID of a row that is being referenced.
- One-to-many columns are references to many rows within another model - they are similar to many-to-many columns (comma-separated lists of integers), except that each row in the referenced model must belong to only one in the main model.
Use SQL stored procedures to call server-side RFCs within Odoo.

Users frequently integrate Odoo with analytics tools such as Power BI and Qlik Sense, and leverage our tools to replicate Odoo data to databases or data warehouses.

Getting Started

Step 1: Configure Odoo connectivity for Cursor

Connectivity to Odoo from Cursor is made possible through CData Connect AI's Remote MCP Server. To interact with Odoo data from Cursor, start by creating and configuring a Odoo connection in CData Connect AI.

Log into Connect AI, click Sources, and then click Add Connection

Select Odoo from the Add Connection panel

Enter the necessary authentication properties to connect to Odoo.
To connect, set the Url to a valid Odoo site, User and Password to the connection details of the user you are connecting with, and Database to the Odoo database.
Click Save & Test
Navigate to the Permissions tab and update user-based permissions

Add a Personal Access Token

A Personal Access Token (PAT) is used to authenticate the connection to Connect AI from Cursor. It is best practice to create a separate PAT for each integration to maintain granular access control.

Click the gear icon () at the top right of the Connect AI app to open Settings
On the Settings page, go to the Access Tokens section and click Create PAT
Give the PAT a descriptive name and click Create

The personal access token is only visible at creation, so be sure to copy it and store it securely for future use

With the Odoo connection configured and a PAT generated, Cursor can now connect to Odoo data through the CData MCP Server.

Step 2: Configure the CData MCP Server in Cursor

Next, configure Cursor to use the CData MCP Server. Cursor reads MCP configuration from an mcp.json file in the user configuration directory and exposes the registered servers under the Tools & MCP settings. Once configured, Cursor's AI chat can call the tools exposed by CData Connect AI.

Download the Cursor desktop application and complete the sign-up flow for your account
From the top menu, click Settings to open the settings panel
In the left navigation, open the Tools & MCP tab and click Add Custom MCP
Cursor opens an mcp.json file in the editor

Add the following configuration. Make sure to base64-encode your email:PAT before inserting into the header:

{
  "mcpServers": {
    "cdata-mcp": {
      "url": "https://mcp.cloud.cdata.com/mcp",
      "headers": {
        "Authorization": "Basic your_base64_encoded_email_PAT"
      }
    }
  }
}

Configuring mcp.json with CData MCP Server

Save the file
Return to Settings and then select Tools & MCP. You can now see cdata-mcp enabled with an active indicator

Step 3: Chat with CData Connect AI from Cursor

From the top bar, click Toggle AI Pane to open the chat window
Test the connection by entering "List connections"
You can also run queries like "Query Odoo data and list the high priority accounts"