odoo-data-quality-gate

Featured

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 408 stars 187 forks Updated 2 weeks ago MIT

Install

View on GitHub

Quality Score: 88/100

Stars 20%
87
Recency 20%
90
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
tuanle96
Repository
tuanle96/mcp-odoo
Created
1 years ago
Last Updated
2 weeks ago
Language
Python
License
MIT

Integrates with

Similar Skills

Semantically similar based on skill content — not just same category

AI & Automation Featured

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.

408 Updated 2 weeks ago
erpipe-org
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.

5 Updated 1 months ago
tuanle96
Data & Documents Listed

how-to-data-quality

Put a data-quality gate on a warehouse load - map every defect to one of the six DQ dimensions (completeness, validity, consistency, timeliness, uniqueness, accuracy), run a real FAIL -> fix -> PASS cycle with a quarantine ledger that reconciles every row, and generate a self-contained executive DQ scorecard where every number is computed. Use when asked to "check data quality", "validate this load", "build DQ checks", "data quality scorecard", "should we trust this data", "set up a quality gate", "quarantine bad rows", or when a pipeline needs defects caught at ingestion instead of in a board meeting. Walks the 6-step pipeline - input, sample data, objective, find-skills, build (gate + fixes + scorecard), expert review.

1 Updated 4 weeks ago
phoebefu6