Auto-generated
This page is regenerated from odoo-db --help by make cli-docs.
Do not edit by hand — your changes will be overwritten on the next build.
odoo-db¶
Usage:
Options:
-V, --version: Display the odoo-db version.--output-file TEXT: [default: -]--output-format TEXT: [default: text]--log-level TEXT: [default: WARNING]--log-file TEXT--include-sensitive-information: Global PII master switch: unmask identifying data (e.g. attachment filenames) in any command that would otherwise redact it. Off by default so output is safe to ship.--install-completion: Install completion for the current shell.--show-completion: Show completion for the current shell, to copy it or customize the installation.--help: Show this message and exit.
Commands:
list: List all Odoo databases: name, version,...modules: List installed modules with version for a...crons: List scheduled actions for a database.params: Show ir_config_parameter keys and values...jobs: List queue job counts by state for a...users: List active users for a database.locks: Show active database locks for a database.stats: Show per-table record counts and sizes for...bloat: Estimate table + index bloat (reclaimable...attachments: Audit ir.attachment storage: repartition +...studio: Show Studio customizations: custom models,...not-odoo: Show non-Odoo database objects: custom...prepare-audit: Combine summary + modules + stats +...
odoo-db list¶
List all Odoo databases: name, version, neutralized status.
Usage:
Options:
-v, --verbose--help: Show this message and exit.
odoo-db modules¶
List installed modules with version for a database.
Usage:
Arguments:
DB: [required]
Options:
--help: Show this message and exit.
odoo-db crons¶
List scheduled actions for a database.
Usage:
Arguments:
DB: [required]
Options:
--running: List crons currently running (RowShareLock on ir_cron).--include-code: Show the python source of each cron's server action, if any (populated only for state='code' actions).--all: Also include inactive crons, adding an 'active' column (ignored with --running).--help: Show this message and exit.
odoo-db params¶
Show ir_config_parameter keys and values for a database.
Values of secret-bearing keys (database.secret, *.client_secret, *.api_key, tokens, ...) are masked as ******** by default; pass the global --include-sensitive-information to reveal them. Keys are always shown.
Masking is best-effort by key name and not exhaustive — verify output before sharing.
Usage:
Arguments:
DB: [required][PATTERN]: Case-insensitive substring match on key.
Options:
--help: Show this message and exit.
odoo-db jobs¶
List queue job counts by state for a database.
Usage:
Arguments:
DB: [required]
Options:
--help: Show this message and exit.
odoo-db users¶
List active users for a database.
Usage:
Arguments:
DB: [required]
Options:
--help: Show this message and exit.
odoo-db locks¶
Show active database locks for a database.
Usage:
Arguments:
DB: [required]
Options:
--help: Show this message and exit.
odoo-db stats¶
Show per-table record counts and sizes for a database.
Usage:
Arguments:
DB: [required]
Options:
-y, --years INTEGER: Number of years to show [default: 3]-n, --top INTEGER: Number of top tables to show [default: 20]--help: Show this message and exit.
odoo-db bloat¶
Estimate table + index bloat (reclaimable by VACUUM FULL / REINDEX / dump+restore).
Uses pgstattuple for exact numbers when the extension is installed (and the
relation fits under --exact-max-scan), otherwise a cheap statistical
estimate. Each row is tagged exact or est. Also flags high dead-tuple
ratios, stale autovacuum, and unused indexes.
Usage:
Arguments:
DB: [required]
Options:
-n, --top INTEGER: Top relations by size to inspect [default: 25]--exact-max-scan INTEGER: Max relation size (MB) to measure exactly with pgstattuple; larger ones are estimated. [default: 2048]--help: Show this message and exit.
odoo-db attachments¶
Audit ir.attachment storage: repartition + cleanup/archive candidates.
Read-only — only metadata and file_size are read, never the payload. Sizes are file_size sums (reliable on any storage backend). Filenames are redacted by default; pass --include-individual-filenames (or the global --include-sensitive-information) to include them.
Usage:
Arguments:
DB: [required]
Options:
-n, --top-models INTEGER: Heaviest models to show (text) [default: 25]--top-files INTEGER: Largest single attachments to list [default: 20]--validate-orphans: Find attachments whose res_id no longer exists (heaviest models).--orphan-top-models INTEGER: How many heaviest models to validate. [default: 15]--orphan-max-scan INTEGER: Skip orphan validation for models above this attachment count. [default: 50000]--include-individual-filenames: Show real filenames in the largest-attachments list (PII). Off by default; also enabled by the global --include-sensitive-information.--help: Show this message and exit.
odoo-db studio¶
Show Studio customizations: custom models, extended models, studio-flagged records.
Usage:
Arguments:
DB: [required]
Options:
--help: Show this message and exit.
odoo-db not-odoo¶
Show non-Odoo database objects: custom views, triggers, and functions.
Usage:
Arguments:
DB: [required]
Options:
--help: Show this message and exit.
odoo-db prepare-audit¶
Combine summary + modules + stats + not-odoo into a $db.json audit export.
Output goes to ./$db.json by default; override with --output-file. Always written as JSON regardless of --output-format. Intended as input for the /odoo-dev:audit-db skill.
Stats payload is compacted: empty tables drop year_counts/index/attachment
fields; non-empty tables drop zero year entries. Consumers should use
.get(key, 0) for the dropped fields.
Usage:
Arguments:
DB: [required]
Options:
-y, --years INTEGER: Years for stats breakdown [default: 3]-n, --top INTEGER: Top tables by size to include (0 = all) [default: 0]--admin-user TEXT: Login to exclude from customized-records scan (repeat for multiple). Use when the project admin uses a personal account instead of 'admin'.--help: Show this message and exit.