Odoo MCP Server Integration

Set Up Your Odoo Environment

Create Your Odoo Database

Access Odoo: Visit Odoo’s website and sign in to your account (or create one if needed)
Create a new database:
- Choose a descriptive database name (e.g., my-business-db)
- Select your preferred region and language
- Install essential modules based on your needs:
  - CRM for customer relationship management
  - Sales for order processing
  - Inventory for stock management
  - Accounting for financial operations

Record your connection details:
- Instance URL: Your Odoo instance URL (e.g., https://your-company.odoo.com)
- Database name: The database you just created
- Username: Your Odoo account email
- Authentication: Your Odoo account password or generate an API key in your user settings (recommended for security)

💡 Pro Tip: Use an API key instead of your password for enhanced security and easier credential management.

Connect to FlowHunt Dashboard

Access FlowHunt: Log in to your FlowHunt.io dashboard
Navigate to Integrations: Find the “Integrations” section in the left sidebar
Select Odoo: Click on the Odoo integration option to begin the setup process

Configure the Odoo Integration

Enter Connection Details

In the Odoo integration setup page, provide the following information:

Field	Description	Example
Odoo Instance URL	Your Odoo server address	`https://your-company.odoo.com`
Database Name	Your Odoo database identifier	`my-business-db`
Username	Your Odoo account email	`admin@yourcompany.com`
Authentication	API key or password	`your-secure-api-key`

Verify the Connection

Click Save or Connect to establish the connection
Wait for the validation process to complete
Look for a success confirmation message
Test the connection with a simple query if available

Deploy the Odoo ERP MCP Server

Add the MCP Server

Navigate to MCP Servers: Go to the “MCP Servers” tab in your FlowHunt dashboard
Add New Server: Click “Add New MCP Server”
Select Odoo ERP: Choose “Odoo ERP MCP Server” from the available options

Configure Server Tools

Select the tools you want to enable for your MCP server:

MCP INTEGRATION

The following tools are available as part of the Odoo MCP integration:

search_records: Query and filter Odoo records using search criteria, field conditions, and domain filters to find specific data across any model.
create_record: Add new records to any Odoo model by providing field values and data, enabling automated data entry and record creation.
update_record: Modify existing Odoo records by updating specific fields with new values, supporting bulk updates and data synchronization.
delete_record: Remove records from Odoo models safely, with support for single or multiple record deletion based on specified criteria.
get_record: Retrieve complete record information by providing the record ID, returning all accessible fields and related data.
list_models: Discover all available Odoo models and their technical names, helping identify which data structures are accessible for integration.
get_model_fields: Retrieve detailed field definitions for any Odoo model, including field types, constraints, and relationships for proper data handling.

Finalize Setup: Click “Add MCP Server” to complete the configuration

📝 Note: You can modify or add tools later based on your evolving automation needs.

Connect MCP Server to Client

Configure the MCP Client

Access Connect Tab: Navigate to the “Connect” tab in your MCP Server configuration
Choose Client: Select your preferred MCP client:
- FlowHunt AI Agent (recommended)
- Claude Desktop
- Custom client applications
Apply Configuration: Use the provided JSON format:

{
  "mcp": {
    "transport": "streamable_http",
    "url": "https://mcp.flowhunt.io/••••••••"
  }
}

Security Considerations

🔒 Important: Treat your MCP server URL as a password. It provides direct access to your Odoo data and server tools. Never share it publicly or commit it to version control.

Test the Connection: Verify functionality by running a test query, such as searching customer records or retrieving sales orders

Create AI-Powered Workflows

You have two powerful options for implementing your Odoo automation:

Option A: Quick Start with Preconfigured Flow

Best for: Getting started quickly with proven automation patterns

Generate Flow: In your MCP Server configuration, click “Create Preconfigured Flow”
Select Template: Choose “AI Agent with MCP” to create a ready-to-use workflow
Customize Logic: Use FlowHunt’s visual flow builder to tailor the automation:
- Set up customer inquiry handling
- Configure automatic sales order creation
- Implement inventory level monitoring
- Create invoice generation workflows

Preconfigured AI Agent flow with Odoo MCP

Activate: Save and activate your flow to begin automated operations

Option B: Custom Integration

Best for: Specific automation requirements or existing workflow enhancement

Create/Edit Flow: Open FlowHunt’s flow builder and start with a new or existing flow
Add MCP Component: Drag the “MCP Server Component” onto your canvas
Configure Connection: Paste your MCP client configuration:

{
  "mcp": {
    "transport": "streamable_http",
    "url": "https://mcp.flowhunt.io/••••••••"
  }
}

Design Workflow: Create custom logic that leverages the MCP server tools:
- Query customer data for personalized responses
- Update inventory based on external triggers
- Generate reports using live Odoo data
- Automate follow-up communications

FlowHunt visual flow builder with MCP component

Deploy: Save your configuration and activate the flow

Conclusion

Integrating Odoo MCP Server with FlowHunt.io creates a powerful foundation for intelligent business automation. Whether you’re streamlining customer service, automating sales processes, or optimizing inventory management, this integration empowers your AI agents to work seamlessly with your critical business data.

Start with a simple automation and gradually expand your workflows as you become more comfortable with the platform. The combination of Odoo’s comprehensive ERP capabilities and FlowHunt’s AI-driven automation will transform how your business operates.

Ready to get started? Begin your integration today and unlock the full potential of AI-powered business automation!