MCP server for querying Odoo ERP with smart aggregation for AI assistants
Project description
mcp-netnam-odoo
MCP server for querying Odoo ERP with smart aggregation — designed for AI assistants to generate charts and reports.
Features
- query_data — Aggregate data with domain filters, groupby, and sorting (uses
read_group) - search_records — Search individual records with filters
- list_models — List available models
- get_model_fields — Inspect model field definitions
Requirements
- Odoo 16+ with the
mcp_servermodule installed - API key generated in Odoo (Settings > Users > API Keys)
Installation
pip install mcp-netnam-odoo
Configuration
Claude Desktop
Add to claude_desktop_config.json:
{
"mcpServers": {
"netnam": {
"command": "mcp-netnam-odoo",
"env": {
"ODOO_URL": "http://your-odoo-server:8069",
"ODOO_DB": "your_database",
"ODOO_API_KEY": "your_api_key",
"ODOO_USER": "your_login"
}
}
}
}
Claude Code
Add to .mcp.json in your project:
{
"mcpServers": {
"netnam": {
"command": "mcp-netnam-odoo",
"env": {
"ODOO_URL": "http://your-odoo-server:8069",
"ODOO_DB": "your_database",
"ODOO_API_KEY": "your_api_key",
"ODOO_USER": "your_login"
}
}
}
}
Example queries
- "Top 5 salespeople by revenue this fiscal year"
- "Monthly ticket count as a bar chart"
- "Revenue breakdown by department and quarter"
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
mcp_netnam_odoo-0.3.1.tar.gz
(9.0 kB
view details)
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file mcp_netnam_odoo-0.3.1.tar.gz.
File metadata
- Download URL: mcp_netnam_odoo-0.3.1.tar.gz
- Upload date:
- Size: 9.0 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.2.0 CPython/3.9.13
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
30b65d1544ce4e96967020d0cfdd7efb95d197ebee85406924d6b61259c5534c
|
|
| MD5 |
db65100b85da723c70ea949227a0dfc4
|
|
| BLAKE2b-256 |
6e7240477ba6d4c3a4c973baf8c47f5626c1c89e179ceaf1dad878f12daf5f43
|
File details
Details for the file mcp_netnam_odoo-0.3.1-py3-none-any.whl.
File metadata
- Download URL: mcp_netnam_odoo-0.3.1-py3-none-any.whl
- Upload date:
- Size: 8.8 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.2.0 CPython/3.9.13
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
5a3e1828f7fe9080c2d78f069bd507a7c1a605453782b133ca4b81eb6282e486
|
|
| MD5 |
41a30bdeb823f8d353063d431c746827
|
|
| BLAKE2b-256 |
e3b2141d0758e3ab53928ff0e56ce5658c0b0aa1f67b1238830503338b9ac34b
|