Odoo MCP Server

MCP Server for Odoo

A Model Context Protocol (MCP) server that enables AI assistants to interact with Odoo ERP systems. This server provides tools for searching, creating, updating, and managing Odoo records through a standardized interface.

Custom MCP Server Development

We develop MCP Servers for customers, if you need MCP server for your own system similar to Odoo MCP server, please contact us (https://www.flowhunt.io/contact/). Here is the description how we develop MCP Servers for our customers: https://www.flowhunt.io/services/mcp-server-development/

Demo

📺 Watch the demo on YouTube

Features

• 🔍 Search Records: Query any Odoo model with complex domain filters
• ➕ Create Records: Add new records to any Odoo model
• ✏️ Update Records: Modify existing records
• 🗑️ Delete Records: Remove records from the system
• 📊 Read Records: Fetch detailed information about specific records
• 🔗 Execute Methods: Call custom methods on Odoo models
• 📋 List Models: Discover available models in your Odoo instance
• 🔧 Model Introspection: Get field definitions for any model

Installation

Via pip (recommended)

From source

Configuration

Environment Variables

Create a .env file in your project directory or set these environment variables:

Getting Odoo Credentials

1. API Key:
   • Log into your Odoo instance
   • Go to Settings → Users & Companies → Users
   • Select your user
   • Under "API Keys" or "Security" tab, create a new API key
   • Copy the key immediately (it won't be shown again)
2. Database Name:
   • Usually visible in the URL when logged in
   • Or check Settings → Activate Developer Mode → Database Info
3. Username:
   • Your login email address

Usage with Claude Desktop

Add this configuration to your Claude Desktop config file:

macOS: ~/Library/Application Support/Claude/claude_desktop_config.json Windows: %APPDATA%/Claude/claude_desktop_config.json

Available Tools

search_records

Search for records in any Odoo model.

Parameters:

• model (required): The Odoo model name (e.g., 'res.partner', 'sale.order')
• domain: Odoo domain filter (default: [])
• fields: List of fields to return
• limit: Maximum number of records
• offset: Number of records to skip
• order: Sort order (e.g., 'name asc, id desc')

Example prompts:

• "Find all customers in California"
• "Show me sales orders from last month"
• "List products with stock quantity below 10"

get_record

Get detailed information about specific records.

Parameters:

• model (required): The Odoo model name
• ids (required): List of record IDs
• fields: List of fields to return (optional)

Example prompts:

• "Show me details of customer with ID 42"
• "Get information about sales order SO0123"

create_record

Create new records in Odoo.

Parameters:

• model (required): The Odoo model name
• values (required): Dictionary of field values

Example prompts:

• "Create a new customer named 'Acme Corp' with email contact@acme.com"
• "Add a new product called 'Widget Pro' with price $99.99"

update_record

Update existing records.

Parameters:

• model (required): The Odoo model name
• ids (required): List of record IDs to update
• values (required): Dictionary of field values to update

Example prompts:

• "Update customer 42's phone number to +1-555-0123"
• "Change the status of sales order SO0123 to confirmed"

delete_record

Delete records from Odoo (use with caution).

Parameters:

• model (required): The Odoo model name
• ids (required): List of record IDs to delete

Example prompts:

• "Delete the test customer record with ID 999"
• "Remove cancelled sales orders older than 2 years"

execute_method

Execute custom methods on Odoo models.

Parameters:

• model (required): The Odoo model name
• method (required): Method name to execute
• ids: List of record IDs (if method requires)
• args: Additional positional arguments
• kwargs: Additional keyword arguments

Example prompts:

• "Confirm sales order SO0123"
• "Send invoice INV/2024/0001 by email"

list_models

Discover available models in your Odoo instance.

Parameters:

• transient: Include transient (wizard) models (default: false)

Example prompts:

• "What models are available in Odoo?"
• "Show me all installed models"

get_model_fields

Get field definitions for a model.

Parameters:

• model (required): The Odoo model name
• fields: Specific fields to get info for (optional)

Example prompts:

• "What fields are available on the customer model?"
• "Show me the structure of sales orders"

Common Use Cases

Customer Management

Sales Operations

Inventory Management

Financial Operations

Model Reference

Common Odoo models you can interact with:

• res.partner - Customers, suppliers, and contacts
• sale.order - Sales orders and quotations
• account.move - Invoices and bills
• product.product - Product variants
• product.template - Product templates
• stock.move - Stock movements
• purchase.order - Purchase orders
• project.project - Projects
• project.task - Project tasks
• hr.employee - Employees
• res.users - System users
• res.company - Companies

Security Considerations

• Store credentials securely using environment variables
• Use API keys instead of passwords when possible
• Grant minimum necessary permissions to the API user
• Regularly rotate API keys
• Monitor API usage through Odoo's logs

Troubleshooting

Authentication Failed

• Verify your API key is active in Odoo
• Check if the username is correct (usually your email)
• Ensure the database name matches exactly

Connection Refused

• Verify the Odoo URL (should not include /web)
• Check if your IP is whitelisted (if applicable)
• Ensure XML-RPC is enabled on your Odoo instance

Model Not Found

• The model might require additional modules to be installed
• Use list_models to see available models
• Check if you have permissions for that model

Development

Running Tests

Type Checking

Linting

Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

License

This project is licensed under the MIT License - see the LICENSE file for details.

Support

For issues and feature requests, please use the GitHub issue tracker.