Contributors

Hi Janik

OCA has something about ai bridge

https://github.com/OCA/ai/tree/16.0

It might be interesting to have a common approach

Best regards

--------------------------------
Cyril VINH-TUNG
INVITU
Computer & Network Engineering
BP 32 - 98713 Papeete - French Polynesia
Tél: +689 40 46 11 99
contact@invitu.com

Le mer. 23 juil. 2025, 19:47, Janik von Rotz <notifications@odoo-community.org> a écrit :

Dear Odoo Community,

I was experimenting with FastMCP to build an Odoo mcp server: https://github.com/Mint-System/Odoo-Build/blob/main/bin/odoo-mcp

Here is an interaction with codestral in Zed:

If somebody else working on this, I would be glad to hear from you. My next steps are:

• Define write tools
• Experiment with mcp resources
• Create a Docker image and publish on Docker mcp hub
• Test with self-hosted LLM

Kind regards,

Janik

-- 
Suggest a meeting: https://apmt.day/janikvonrotz/999120f2/
We are hiring: https://www.mint-system.ch/jobs

CTO Mint System GmbH 
Tel: +41 44 244 7222

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

Dear Odoo Community,

I was experimenting with FastMCP to build an Odoo mcp server: https://github.com/Mint-System/Odoo-Build/blob/main/bin/odoo-mcp

Here is an interaction with codestral in Zed:

If somebody else working on this, I would be glad to hear from you. My next steps are:

• Define write tools
• Experiment with mcp resources
• Create a Docker image and publish on Docker mcp hub
• Test with self-hosted LLM

Kind regards,

Janik

-- 
Suggest a meeting: https://apmt.day/janikvonrotz/999120f2/
We are hiring: https://www.mint-system.ch/jobs

CTO Mint System GmbH 
Tel: +41 44 244 7222

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

Hi,

 

last week I’ve tested https://github.com/hachecito/odoo-mcp-improved which was quite impressive. I am not sure if the improvements are necessary or if the source (https://github.com/tuanle96/mcp-odoo) version could do the same.

 

 

I had some trouble to connect the container with my odoo instance which was also running in docker, but after adding the container do my compose file and configured in claude to attach to the running container, everything was working.

 

{

  "isUsingBuiltInNodeForMcp": true, 

  "mcpServers": {

    "odoo": {

      "command": "podman",

      "args": [

        "attach",

        "odoo_mcp"

      ]

    }

  }

}

 

All tests I did was only with the small demo Database, but the following action worked in the free claude plan:

 

 

I was also able to print a list of all female employees, which were identified by “typical female first names”, which is a valid approach.

I also asked to give me the highest sale order, which also returned the correct result.

 

Also writing to the Odoo database was working. When asking to answer the ticket with the id 22 (“What's the best kitchen cabinet varnish for your home?”) resulted in a reply on this ticket. But because my prompt was not very clear, I’ve got a perfect general answer on kitchen cabinet varnish. After asking Claude to take the available Products into account, there answer referenced the available products including prices, which would be a more likely expected answer to this question.

 

Tests with complex generic questions, like to create a financial report on the odoo data, failed because it did not fit into the Claude free plan.

 

Another downside of this solution is for sure the security. I’ve connected the MCP Server as admin/admin. Therefore the answer of the Ticket was also posted by the admin. When you integrate the MCP server into your company portal chatbot, it would be much better, when it would act as the current user and not with a service account to make sure that no information is leaked which the user does not have access to.

 

Best regards,

Christopher

 

 

From: Janik von Rotz <notifications@odoo-community.org>
Sent: Mittwoch, 23. Juli 2025 14:48
To: Contributors <contributors@odoo-community.org>
Subject: Odoo MCP Server

 

Dear Odoo Community,

I was experimenting with FastMCP to build an Odoo mcp server: https://github.com/Mint-System/Odoo-Build/blob/main/bin/odoo-mcp

Here is an interaction with codestral in Zed:

If somebody else working on this, I would be glad to hear from you. My next steps are:

• Define write tools

• Experiment with mcp resources

• Create a Docker image and publish on Docker mcp hub

• Test with self-hosted LLM

Kind regards,

Janik

 

-- 

Suggest a meeting: https://apmt.day/janikvonrotz/999120f2/

We are hiring: https://www.mint-system.ch/jobs

CTO Mint System GmbH 

Tel: +41 44 244 7222

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

Hi,

last week I’ve tested https://github.com/hachecito/odoo-mcp-improved which was quite impressive. I am not sure if the improvements are necessary or if the source (https://github.com/tuanle96/mcp-odoo) version could do the same.

I had some trouble to connect the container with my odoo instance which was also running in docker, but after adding the container do my compose file and configured in claude to attach to the running container, everything was working.

{

  "isUsingBuiltInNodeForMcp": true, 

  "mcpServers": {

    "odoo": {

      "command": "podman",

      "args": [

        "attach",

        "odoo_mcp"

      ]

    }

  }

}

All tests I did was only with the small demo Database, but the following action worked in the free claude plan:

I was also able to print a list of all female employees, which were identified by “typical female first names”, which is a valid approach.

I also asked to give me the highest sale order, which also returned the correct result.

Also writing to the Odoo database was working. When asking to answer the ticket with the id 22 (“What's the best kitchen cabinet varnish for your home?”) resulted in a reply on this ticket. But because my prompt was not very clear, I’ve got a perfect general answer on kitchen cabinet varnish. After asking Claude to take the available Products into account, there answer referenced the available products including prices, which would be a more likely expected answer to this question.

Tests with complex generic questions, like to create a financial report on the odoo data, failed because it did not fit into the Claude free plan.

Another downside of this solution is for sure the security. I’ve connected the MCP Server as admin/admin. Therefore the answer of the Ticket was also posted by the admin. When you integrate the MCP server into your company portal chatbot, it would be much better, when it would act as the current user and not with a service account to make sure that no information is leaked which the user does not have access to.

Best regards,

Christopher

-- 

Suggest a meeting: https://apmt.day/janikvonrotz/999120f2/

We are hiring: https://www.mint-system.ch/jobs

CTO Mint System GmbH 

Tel: +41 44 244 7222