| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Community Apps Dependencies | Show |
| Lines of code | 12413 |
| Technical Name |
n8n_ok |
| License | OPL-1 |
| Website | https://linkedin.com/in/okky-permana-sihipo |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Community Apps Dependencies | Show |
| Lines of code | 12413 |
| Technical Name |
n8n_ok |
| License | OPL-1 |
| Website | https://linkedin.com/in/okky-permana-sihipo |
n8n Integration Hub & Automation Ecosystem
Orchestrate Odoo Workflows, Local LLM Servers, and Server Consoles in One Unified Environment
Maximize your automation efficiency by connecting n8n workflows, local AI Llama servers, and secure web terminal consoles directly within the Odoo interface.
The Automation Triad: Three Modules, One Hub
1. n8n_ok
Workflow Automation Hub
Visual workflow automation engine. Spin up local n8n servers, auto-login into dashboards, sync database credentials, and route data using pre-packaged automation templates.
2. odoo_shell_ok
AI-Powered Development Suite
Integrates Gemini and local Llama.cpp servers. Download local GGUF models directly, auto-fix exceptions with code diffs, run AI OdooBot, and query data using interactive shells.
3. web_console_ok
System Console & Terminal
Fully-featured secure Linux terminal directly inside the browser. Manage backend services, run python scripts, check live logs, and manage SSH connections without leaving Odoo.
1. n8n Integration Hub (n8n_ok) - Deep Functional Analysis
The n8n Integration Hub serves as the central orchestration system to build, run, and scale event-driven Node-RED style visual workflows inside your Odoo environment.
Local & Remote n8n Instance Control
Allows Odoo administrators to manage multiple n8n servers directly from Odoo. Features include:
- Process Daemon Management: Start, stop, and restart local Node.js n8n processes from the Odoo backend. It dynamically captures and keeps track of system Process IDs (PID).
- Live Log Capture: Streams stdout/stderr from the running n8n command to a dedicated logging directory, allowing developers to inspect server logs inline inside the instance view.
- Instance Multi-Tenancy: Setup multiple instances (local node, dev server, remote Docker stack). The OwlJS client automatically updates port bindings, SSL settings, and URLs in the dashboard view.
Seamless Web SSO / Auto-Login Flow
Integrates OAuth-like session auto-login using Odoo-stored n8n credentials:
- Secure Cookie Ingestion: When the user loads the dashboard, an OwlJS controller performs a background API request (iframe-based login POST) using the encrypted n8n email and password.
- No Manual Login Popups: Automatically creates n8n session cookies in the browser. Users are instantly logged into their node editor interface within the Odoo iframe.
DNS & IPv6 Patching Engine
Built-in network compatibility layers to resolve loopback issues common in local web environments:
- Node.js dns.lookup Resolution: Automatically intercepts and patches outbound HTTP calls from n8n to local Odoo servers. Prevents Node.js from getting stuck on localhost IPv6 loopbacks (like
::1) by forcing IPv4 resolution (127.0.0.1). - SSL/TLS Bypass option: Allows bypassing certificate verification in development mode when connecting to local self-signed HTTPS hosts.
Credentials Sync & Data Protection
Protects user changes and keeps systems synchronized:
- Auto-Cred Sync: Automatically serializes Odoo database credentials, database name, and web API keys and pushes them to n8n's configuration.
- Data Protection: The default local n8n instance is loaded securely to prevent manual customization of port numbers, logins, and passwords from being overwritten when upgrading the module.
2. AI Development Suite & Llama Server (odoo_shell_ok) - Deep Functional Analysis
The AI-Powered Development Suite provides deep integration with cutting-edge local LLMs (Llama, Qwen, DeepSeek) and cloud engines (Google Gemini) to automate coding, schema design, and diagnostic support.
Local llama.cpp Server Manager
Complete control interface over local offline large language model backends:
- Multi-Instance Configs: Configure multiple Llama server records binding to different models and ports. Instantly switch between models from the Llama Dashboard selector.
- Inline GGUF Model Downloader: Features a direct GGUF downloader widget that requests and streams models from HuggingFace to Odoo's
models_local/directory. Supports background download status checks, file size reporting, and live progress bars. - GPU & CPU Tuning: Adjust CPU execution threads, select context window sizes (e.g. 2048, 4096, 8192 tokens), and specify exact GPU layers to offload (offloads entire code inference to GPU using CUDA/OpenCL with `-1` offloading).
Auto-Repairing Code & Exception Fixer
Automates bug fixing during runtime development loops:
- AI Ask popup: Integrates with Odoo's frontend error system. When a ValidationError, AccessError, or Python exception occurs, Odoo displays a smart "AI Ask" button. Clicking this triggers the LLM to inspect the full traceback, explain the root cause, and provide solutions in plain English.
- AI Fix inline patcher: If the exception resides inside custom addon files, clicking "AI Fix" prompts the LLM to read the buggy Python/JS/XML source code, write a patch, display a beautiful side-by-side visual code diff, and replace the file contents upon confirmation. Odoo then automatically restarts the background daemon.
- Safety Sandboxing: Strictly protects base/core files. AI Fix checks file paths against whitelisted custom addon directories defined in Odoo Settings, refusing to edit Odoo core code.
AI Model Assistant (Schema Auto-Generation)
Build Odoo database fields and relations using natural language instructions:
- AI Model Explanation: Generates detailed design summaries of database tables, relation paths, and security rule matrices directly from the Odoo Models view. Explanations are cached inside the database to minimize API usage.
- No-Code Field Generation: Describe a field in natural language (e.g., "Create a computed float field representing margin percent based on price and cost"). The AI dynamically compiles the python syntax, resolves dependencies, and injects it as a manual field without needing a server restart.
Conversational OdooBot & Agentic DB access
Empowers the Odoo chat assistant with real database execution abilities:
- AI OdooBot: Integrates with Gemini or Llama servers to answer business and development queries directly inside Discuss chat threads.
- Secure Database Tools: Allows authorized developers to ask the AI to query records or execute python snippets inside a sandbox environment using function calling.
3. Web Console & Terminal (web_console_ok) - Deep Functional Analysis
The Web Console & Terminal integrates browser-based shell access to eliminate complex configurations, ssh client switches, and command-line setups.
Embedded Web Terminal Client (xterm.js)
Provides a native terminal emulator interface inside the web browser:
- Direct Bash Shell Access: Run system-level commands, manage Odoo services, view system resources using
htop, and install pip/apt packages directly. - xterm.js Integration: Supports terminal sizing, copy/paste keyboard bindings, proper ansi color codes, shell history, and fullscreen terminal viewport expansion.
- Sandbox Shell: Respects system-level user permissions to isolate and protect root files from unauthorized access.
Multi-Session SSH Client Manager
Extends the local terminal functionality to remote cloud networks:
- SSH Configuration Vault: Store SSH keys, host IPs, ports, and usernames securely in the database.
- One-Click Remote SSH: Click to open a secure SSH tunnel to external staging, email, or database servers directly from the Odoo menu.
AI-Powered Contact Summary & Discuss Posting
The n8n_ok module comes with a pre-packaged, production-ready workflow template to demonstrate its power out of the box:
- Contact Registration Trigger: Triggers n8n immediately when a new Contact (res.partner) is registered in Odoo.
- Local Llama/Gemini Execution: Sends the contact's name, email, and phone info to the active local Llama server or Google Gemini.
- AI Summary Generation: Local LLM parses information and generates a summarized greeting.
- Discuss Posting Node: Submits the AI-generated greeting back to a specific Odoo Discuss Channel automatically in plain text format.
Unified Settings Panel
All configurations are unified and integrated directly into Odoo's main Settings > General Settings panel under the **AI Configuration** section. You can:
- Toggle AI providers (Google Gemini / Local Llama / Remote Llama Server).
- Download, delete, or sync local GGUF models directly.
- Configure OdooBot mode and restrict file changes to specific whitelisted addon paths.
- Configure n8n credentials for auto-login capabilities.
System Installation & Configuration
- Module Installation: Install the
n8n_okmodule, which will automatically pull in its dependencies:web_console_okandodoo_shell_ok. - Configure n8n Server: In **Settings > n8n Instances**, select your local n8n instance, set the correct path to your Node.js n8n binary (or docker credentials), and save.
- Select AI Model: Under **Settings > General Settings > AI Configuration**, choose your local or cloud LLM model. For local models, select a GGUF model and click **Download Model**.
- Enjoy Automation: Click the n8n Dashboard menu, switch dynamically between instances, and enjoy a unified, auto-logged-in workflow workspace!
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