Hosted MCP Server for Odoo

Set Up Your Odoo Environment

Create Your Odoo Database

1. Access Odoo: Visit Odoo’s website and sign in to your account (or create one if needed)

2. 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

3. 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

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

Ready to grow your business?

Start your free trial today and see results within days.

Request demo Log in

Configure the Odoo Integration

Enter Connection Details

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

Verify the Connection

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

Deploy the Odoo ERP MCP Server

Add the MCP Server

1. Navigate to MCP Servers: Go to the “MCP Servers” tab in your FlowHunt dashboard
2. Add New Server: Click “Add New MCP Server”
3. 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:

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

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

Join our newsletter

Get latest tips, trends, and deals for free.

Email address

Subscribe

Connect MCP Server to Client

Configure the MCP Client

1. Access Connect Tab: Navigate to the “Connect” tab in your MCP Server configuration

2. Choose Client: Select your preferred MCP client:

   • FlowHunt AI Agent (recommended)
   • Claude Desktop
   • Custom client applications

3. 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.

4. 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

1. Generate Flow: In your MCP Server configuration, click “Create Preconfigured Flow”
2. Select Template: Choose “AI Agent with MCP” to create a ready-to-use workflow
3. 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

4. Activate: Save and activate your flow to begin automated operations

Option B: Custom Integration

Best for: Specific automation requirements or existing workflow enhancement

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

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

4. 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

5. Deploy: Save your configuration and activate the flow

List of Prompts

Here are practical examples demonstrating how to use the Odoo MCP Server with your AI agents. These prompts showcase real-world ERP and business management scenarios:

CRM and Customer Management

Search for all customers in the res.partner model where country is 'United States' and customer status is 'active'

Create a new customer record with name 'Acme Industries', email 'contact@acme.com', and phone '+1-555-0123'

Update customer record ID 456 to change the sales representative to John Smith and add a note about the recent meeting

Get complete information for customer ID 789 including contact details, purchase history, and outstanding invoices

Sales Order Management

Search for all sales orders from the last 30 days with status 'draft' that need approval

Create a new sales order for customer 'Tech Solutions Inc' with 3 product items and delivery date next Friday

Update sales order SO-2026-001 to add rush delivery and increase the priority level

List all overdue sales orders grouped by sales representative

Inventory and Product Management

Search for all products in the product.product model where stock quantity is below 50 units

Get detailed information about product SKU 'LAPTOP-XPS-15' including current stock levels across all warehouses

Create a new product record for 'Wireless Keyboard Pro' with category 'Electronics' and cost price $45

Update the stock quantity for product ID 234 to reflect the new shipment received today

Accounting and Invoicing

Search for all unpaid invoices from the account.move model that are more than 30 days overdue

Create a new invoice for customer 'Global Enterprises' for consulting services rendered in January

Get all financial transactions for account 'Accounts Receivable' for Q4 2025

Model Discovery and Schema Management

List all available Odoo models in my database to understand what data I can access

Get all field definitions for the sale.order model to understand the available fields for sales orders

Show me the structure of the hr.employee model including field types and relationships

Business Intelligence and Reporting

Search for all completed projects in the last quarter and calculate the total revenue generated

Get a list of top 10 customers by total purchase value in 2025

Find all products that haven't been sold in the last 6 months for inventory optimization

Bulk Operations and Data Management

Delete all draft quotes that are older than 90 days and were never converted to orders

Update all products in category 'Seasonal Items' to apply a 20% discount for the holiday sale

These prompts demonstrate how Odoo MCP integration enables comprehensive business automation, from CRM and sales management to inventory control and financial operations.

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!