| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
CRM (crm)
• Discuss (mail) • Employees (hr) • Inventory (stock) • Invoicing (account) • Purchase (purchase) • Calendar (calendar) • Contacts (contacts) |
| Lines of code | 46136 |
| Technical Name |
foggy_mcp_pro |
| License | OPL-1 |
| Website | https://odoo.foggysource.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
CRM (crm)
• Discuss (mail) • Employees (hr) • Inventory (stock) • Invoicing (account) • Purchase (purchase) • Calendar (calendar) • Contacts (contacts) |
| Lines of code | 46136 |
| Technical Name |
foggy_mcp_pro |
| License | OPL-1 |
| Website | https://odoo.foggysource.com |
Foggy Odoo Bridge Pro
Governed AI access for Odoo analysis, reporting, and operational questions
What is Foggy Odoo Bridge Pro?
Foggy Odoo Bridge Pro helps Odoo administrators provide governed AI analysis over operational data without giving users direct database access.
It adds a built-in AI Chat experience for Odoo users and an MCP endpoint for external AI clients such as Claude Desktop, Cursor, and VS Code Copilot. Both paths use the same model metadata, permission checks, audit trail, and structured query execution layer.
This release is compatible with Odoo 17.0 Community and Enterprise. The addon release version is 17.0.1.9.0; this is the Foggy addon version for the Odoo 17.0 series, not a minimum Odoo server patch version.
It is designed for governed analysis, reporting, and operational questions across Sales, Purchase, Accounting, Inventory, HR, Contacts, Companies, CRM, and Products, with optional Project and Manufacturing query models when those Odoo apps are installed, while preserving Odoo's native permission system.
The recommended deployment uses the built-in query engine inside Odoo, so most teams do not need a separate Foggy server for day-one adoption. Gateway mode remains available for advanced network topologies and external service boundaries.
Used as a standalone MCP gateway, this addon does not require openai or anthropic.
Those SDKs are only optional dependencies for the built-in AI Chat feature.
Database support for this release is currently scoped to PostgreSQL. MySQL is not yet an officially supported target for this Odoo bridge release and is better treated as a future release milestone after dedicated validation.
Architecture
AI Client (Claude, Cursor, etc.)
|
| MCP JSON-RPC
v
+----------------------------------+
| Odoo Bridge + Built-in Engine | <-- Recommended
| (Permission Layer + Query Engine)|
+----------------------------------+
|
| Direct PostgreSQL access (read-only)
v
+-------------------+
| PostgreSQL | <-- Your Odoo database
+-------------------+
Optional advanced topology: route requests from Odoo to a self-hosted Foggy gateway service over your internal network when you need a separate execution boundary.
Key Features
Embedded by Default
The recommended setup runs the query engine inside Odoo. No separate Foggy server is required for the default deployment, while gateway mode remains available for advanced topologies.
Odoo-Native Security
ir.model.access controls which data models each user can query. ir.rule domains are automatically converted to SQL WHERE clauses and injected server-side. Multi-company boundaries are enforced before AI clients ever see query results.
Governed Analytics
12 core query models for Sales, Purchase, Accounting, Inventory, HR, Contacts, Companies, CRM, and Products, plus optional Project and Manufacturing query models when the corresponding Odoo apps are installed.
Security, Audit & Export
Odoo Permission Boundaries
Queries run as the effective Odoo user. Record rules, company access, model access, and Odoo field access boundaries are enforced server-side before results reach AI clients.
Auditable Query Evidence
AI Chat can show tool calls, generated query payloads, SQL evidence, row counts, and audit records so administrators can review how answers were produced.
Governed Export
Export query results to Excel / CSV directly from AI Chat. Exports inherit the same server-side access checks and are audit-logged for operational review.
Built-in AI Chat
Talk to your Odoo data directly from the Odoo interface. Ask questions in natural language, get structured query results, view the query process, and export to Excel/CSV â all within a single conversational UI.
- Supports OpenAI-compatible APIs (GPT-4, DeepSeek, Qwen, Ollama) and Anthropic (Claude)
- Tool calls are visible to admins ("View Query Process" button)
- Multi-session conversation history
- Column governance enforced in AI Chat responses
- AI Chat is optional; if disabled, no LLM traffic is sent
Query Capabilities
| Feature | Description | Example |
|---|---|---|
| Dimensions & Captions | Query related entity names via $caption | partner$caption, company$caption |
| Aggregations | SUM, COUNT, AVG, MIN, MAX with GROUP BY | sum(amountTotal) as total |
| DISTINCT | Unique value enumeration | distinct: true, columns: ['state'] |
| Subtotals | Automatic subtotal and grand total rows | withSubtotals: true |
| Hierarchy Queries | Closure table operators for org structure | selfAndDescendantsOf, selfAndAncestorsOf |
| Slice Filters | WHERE conditions with rich operators | =, !=, >, like, in, isNotNull |
Installation
- Install this addon in your Odoo 17.0 Community or Enterprise instance
- Install
asyncpg,pydantic, andPyYAMLin the Odoo Python environment for the built-in embedded engine - Open Settings → Foggy MCP, keep the engine mode set to Embedded, and run the health check
- For built-in AI Chat, configure an LLM provider, enable the AI Chat data-transfer consent after reviewing your provider boundary, and choose whether AI Chat is available to all internal users or only explicit Foggy AI User members
- For external MCP clients, create an API Key for each user in Foggy MCP → API Keys
- Connect your AI client to
https://your-odoo.com/foggy-mcp/rpc
Need a separate execution boundary or an existing Foggy service topology? Gateway mode is still supported as an advanced deployment option.
Setup guide: https://odoo.foggysource.com/setup-guide.html
Supported Odoo Models
| Odoo App | Odoo Model | Query Model Name | Availability / Key Dimensions |
|---|---|---|---|
| Sales | sale.order | OdooSaleOrderQueryModel | Core: partner, company, salesTeam, salesperson, state, dateOrder |
| Sales | sale.order.line | OdooSaleOrderLineQueryModel | Core: order, product, productCategory, company |
| Purchase | purchase.order | OdooPurchaseOrderQueryModel | Core: partner, company, pickingType, dateOrder |
| Accounting | account.move | OdooAccountMoveQueryModel | Core: partner, company, journal, moveType, invoiceDate, dueDate |
| Accounting | account.payment | OdooAccountPaymentQueryModel | Core: partner, company, paymentType, move$date |
| Accounting | account.move.line | OdooAccountMoveLineQueryModel | Core: partner, company, account, move, dueDate |
| Inventory | stock.picking | OdooStockPickingQueryModel | Core: partner, company, pickingType, srcLocation, destLocation |
| HR | hr.employee | OdooHrEmployeeQueryModel | Core: department, company, job, workLocation |
| Contacts | res.partner | OdooResPartnerQueryModel | Core: company, country, state, type |
| Companies | res.company | OdooResCompanyQueryModel | Core: parent company, country, currency |
| CRM | crm.lead | OdooCrmLeadQueryModel | Core: salesperson, salesTeam, source, stage, probability |
| Products | product.template | OdooProductTemplateQueryModel | Core: category, type, company, list price |
| Project | project.task | OdooProjectTaskQueryModel | Optional when Project is installed: project, stage, assignee, customer |
| Manufacturing | mrp.production | OdooMrpProductionQueryModel | Optional when Manufacturing is installed: product, BOM, owner, state, planned date |
Core rows are available with this addon's required Odoo dependencies. Optional rows are published only when the corresponding Odoo app is installed and accessible to the current user.
Data Handling & LLM Options
Deployment mode matters. In the recommended embedded deployment, governed queries stay inside your Odoo environment and connect directly to PostgreSQL.
- Embedded mode: Odoo runs the governed query engine locally against PostgreSQL
- Gateway mode: Odoo forwards requests only to a self-hosted Foggy service that you deploy
- Built-in AI Chat is optional; MCP access works without OpenAI or Anthropic
- Built-in AI Chat requires an administrator opt-in before prompts and selected query context are sent to the configured LLM endpoint
- If you use a self-hosted OpenAI-compatible, Ollama, or private proxy endpoint, LLM traffic can stay inside your controlled boundary
- If you configure a cloud LLM provider such as OpenAI or Anthropic, prompts and selected query context are sent to that provider
- HTTPS is strongly recommended for production environments
- No vendor telemetry or analytics are added by this addon
Requirements
- Odoo 17.0 Community or Enterprise
- PostgreSQL 12+ (shared with Odoo, current validated database target)
- Embedded mode requires
asyncpg,pydantic, andPyYAMLin the Odoo Python environment - MySQL is not yet an officially supported database target for this release
- No
openai/anthropicdependency is required for standalone MCP usage - Built-in AI Chat optionally requires
openaiand/oranthropic - Gateway mode remains available with a self-hosted Foggy Java or Python service
FAQ
Do I need a separate Foggy server?
No. The built-in embedded engine is the default recommended path for most deployments.
Can I still use gateway mode?
Yes. Gateway mode is still supported when you want a separate execution boundary or an existing service topology.
Do I need OpenAI or Anthropic to use MCP access?
No. Those SDKs are only needed for the optional built-in AI Chat feature.
Can I keep LLM traffic inside my own boundary?
Yes. Use MCP without AI Chat, or connect AI Chat to a self-hosted OpenAI-compatible / Ollama endpoint. Cloud providers remain optional.
Version History
| Addon Version | Release | Highlights |
|---|---|---|
| 17.0.1.9.0 | v1.6 commercial prelaunch | Embedded engine default, governed MCP endpoint, optional AI Chat with LLM data transfer opt-in, 12 core Odoo business query models, optional Project / Manufacturing models, SQL evidence, governed export, and hardened compose / pivot analysis contracts. |
Version 17.0.1.9.0 is the Foggy addon release for the Odoo 17.0 series.
It is not a minimum Odoo server patch version.
Support, Privacy & Terms
Support: support@foggysource.com
Setup guide: https://odoo.foggysource.com/setup-guide.html
Privacy note: Embedded mode and self-hosted gateway mode keep governed query traffic inside your own environment. Optional cloud LLM providers only apply if you enable built-in AI Chat with those providers.
AI disclaimer: AI-generated analysis may be incomplete or incorrect and may not fully match your intended business definition. For important business decisions, review the source records, tool calls, query payloads, SQL evidence, and exported results with your administrator, implementation partner, or technical team.
Terms note: Distributed under OPL-1. Any external LLM or infrastructure service you connect remains subject to your own provider agreements and deployment choices.
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module