odoo-data-quality-gate

Solid

Audit an Odoo database's data quality with evidence before trusting AI answers, importing, or migrating — duplicates, missing required values, orphaned references, format anomalies — and drive remediation through odoo-mcp's gated write workflow. Use when the user asks to "check data quality", "clean up data", "prepare for migration", "find duplicates", or when aggregate answers look suspicious.

AI & Automation 372 stars 172 forks Updated 5 days ago MIT

Install

View on GitHub

Quality Score: 90/100

Stars 20%
86
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

# Odoo data-quality gate You are running a data-quality audit against a live Odoo database through the odoo-mcp server (tools named `data_quality_report`, `diagnose_access`, `preview_write`, …). Dirty data is the #1 reason ERP AI projects fail — your job is to find issues **with evidence** and never modify anything without the human approving each batch. ## Prerequisites - odoo-mcp connected (any Odoo 16+; check with `health_check`). - Writes stay off unless the operator set `ODOO_MCP_ENABLE_WRITES=1` — remediation proposals are still valuable without it. ## Playbook 1. **Scope with the human.** Which models matter? Default set for a general audit: `res.partner`, `product.template`, `account.move`. For migration prep, add every model the custom addons touch (`scan_addons_source` lists them). 2. **Run the report per model:** `data_quality_report(model=...)`. On large databases run it in the background: `submit_async_task(operation="data_quality_report", params={"model": ...})` then poll `get_async_task`. 3. **Read `summary.checks_with_issues` and show evidence.** Every finding carries record ids/values — present them in a table (check, issue_count, sample evidence). Never summarize away the ids; the human needs them. 4. **Verify orphans before judging.** `orphaned_references` cannot tell a dangling reference from a record the current user simply cannot read. For each one, run `diagnose_access(model=<target_model>)` and report which expla...

Details

Author
erpipe-org
Repository
erpipe-org/mcp-odoo
Created
1 years ago
Last Updated
5 days ago
Language
Python
License
MIT

Integrates with

Similar Skills

Semantically similar based on skill content — not just same category

AI & Automation Solid

odoo-data-quality-gate

Audit an Odoo database's data quality with evidence before trusting AI answers, importing, or migrating — duplicates, missing required values, orphaned references, format anomalies — and drive remediation through odoo-mcp's gated write workflow. Use when the user asks to "check data quality", "clean up data", "prepare for migration", "find duplicates", or when aggregate answers look suspicious.

372 Updated 5 days ago
tuanle96
Code & Development Listed

odoo-review

Reviewing Odoo code before it merges — your own AI-generated patch or someone else's PR. Use after writing or generating an Odoo change and before commit, or when asked to review/audit an Odoo module, diff, or addon. Catches the Odoo-specific defects AI confidently ships that lint and "it ran for me as admin" miss: blanket sudo() / privilege bypass, missing ACL or record rules, N+1 recordset loops, incomplete @api.depends on stored computes, patching core instead of a separate addon, wrong inheritance mode / MRO layer, deprecated v≤16 syntax (attrs/states/<tree>/name_get), guessed field & method names, unwired __init__ / manifest, data-loss-on-upgrade renames, and public routes with the wrong auth. Pairs with odoo-testing (review finds it, tests prove it). Read ground truth from the running instance to confirm a suspicion — don't guess whether a field or rule exists. Targets Odoo 17/18/19.

4 Updated 1 weeks ago
tuanle96
AI & Automation Solid

odoo-migration-copilot

Plan and de-risk an Odoo version upgrade (16→17→18→19/20) using odoo-mcp's migration workbench — audit custom addons, classify upgrade-log failures into a worklist, resolve model renames, and preview JSON-2 payloads for the XML-RPC sunset. Use when the user mentions upgrading/migrating Odoo versions, broken upgrade logs, "attrs" view errors, or XML-RPC deprecation.

372 Updated 5 days ago
erpipe-org