An advanced data-auditing skill that scans live Odoo databases for duplicates, missing fields, and orphans, executing safe, human-in-the-loop remediation workflows.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install odoo-data-quality-gate
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install odoo-data-quality-gate using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Odoo Data-Quality Gate?
The Odoo Data-Quality Gate skill provides automated data auditing and safe remediation pipelines for live Odoo databases. Dirty data represents a major point of failure for enterprise AI systems and ERP migration projects. This skill connects seamlessly to the odoo-mcp server to discover anomalies, track down duplicate records, find missing required properties, and pinpoint orphaned references across critical models like res.partner and product.template.
Designed with strict safety protocols, this skill ensures that all analytical insights are backed by actionable, granular evidence. Instead of summarizing away key details, the system exposes exact database IDs and problem values to human operators. Data modifications remain locked behind a rigid approval gate, preventing unauthorized database alterations and keeping the user in full control of every batch update.
Odoo Data-Quality Gate Use Cases
- Preparing an enterprise Odoo database for seamless AI integration or data migration tasks.
- Auditing core business records to identify and merge duplicate partners, customers, or product templates.
- Finding and diagnosing orphaned entity references or missing required database values.
- Validating data fidelity before importing external records or executing major system upgrades.
- Reviewing database conditions when aggregated AI reports or analytics outputs look suspicious.
How Odoo Data-Quality Gate Works
- Scope definition: The agent establishes context with the human operator to identify target Odoo models, defaulting to core records like contacts, templates, and account lines.
- Database auditing: The agent calls the data quality report tool, utilizing asynchronous background workers for high-volume, enterprise-scale Odoo databases.
- Evidence compilation: Findings are categorized into comprehensive summary tables containing distinct issue counts and specific record IDs.
- Access diagnostics: Orphaned foreign keys undergo automated permission checks to distinguish true dangling references from localized record access restrictions.
- Batch formulation: Remediation proposals are grouped into small, structured batches defining exact changes and target resource IDs.
- Gated execution: Modifications progress through a multi-step verification pipeline (preview, validation, user confirmation) before any writes are committed.
Odoo Data-Quality Gate Setup
Ensure you have the odoo-mcp server configured and linked to your target Odoo instance (v16+). Verify connection stability by invoking the health check.
To allow data cleaning actions, you must explicitly pass the permission flag to your workspace environment variable configurations:
export ODOO_MCP_ENABLE_WRITES=1
If this variable is omitted, the Openclaw Skills agent will operate exclusively in a read-only audit state, gathering evidence without altering production data.
Odoo Data-Quality Gate Data Schema & Taxonomy
The skill manages its analytical findings, system checks, and structural reviews using structured metrics. It organizes data outputs according to the following baseline schema:
| Element | Description | Target Applications |
|---|---|---|
data_quality_report |
Executes deep record inspection over target models. | res.partner, product.template, account.move |
checks_with_issues |
Stores data errors, value tracking, and unique system IDs. | Integrity validation tables |
orphaned_references |
Identifies broken or restricted database associations. | Diagnostic workflows via diagnose_access |
redacted_fields |
Maintains row-level and column-level data protection. | Field-level ACL compliance |
All output presentations include an explicit verdict for every evaluated database model: Clean, Needs Remediation, or Blocked.
Odoo Data-Quality Gate Advanced Features
- Asynchronous Task Processing: Offloads intense database operations on massive tables to background workers via asynchronous task tracking APIs.
- Access Control Diagnostics: Differentiates between actual broken database paths and active row-level access control list restrictions.
- Gated Mutation Workflows: Bypasses raw execution routes entirely, forcing all write requests to move through preview and token-validated verification gates.
- Automatic Addon Scanning: Parses custom addon source code structures automatically to discover secondary models that require auditing prior to migration.
SKILL.md
Loading
Related Openclaw Skills
Odoo Month-End Close Skill
A controlled, multi-step financial reconciliation workflow for Odoo that automates AR/AP aging, draft reviews, and close documentation under strict human supervision.
Odoo Agency Fleet Review
A powerful MCP-driven skill that enables agencies to audit, analyze, and manage multi-instance Odoo databases simultaneously for comprehensive accounting and fleet health reports.
twosio
A unified, pay-per-call API gateway giving AI agents instant access to over 575 endpoints for ground-truth data, model orchestration, and stateful developer infrastructure without API keys or accounts.
PLUR Memory
PLUR Memory is a persistent learning and open memory framework that allows AI coding agents to retain corrections, preferences, and patterns across sessions and platforms.
SkillFlowChart
SkillFlowChart reads agent skill definitions and automatically generates responsive, zero-dependency HTML decision flowcharts and workflow diagrams.
ElegantBook LaTeX Book Builder
An intelligent typesetting skill that semantically re-authors Markdown files into publication-ready Chinese books using the ElegantBook LaTeX template.
Featured*
