Agent skill

Odoo Orm Expert

by sickn33 in sickn33/agentic-awesome-skills

Master Odoo ORM patterns: search, browse, create, write, domain filters, computed fields, and performance-safe query techniques.

MITAuto-check passedDatabases

Install Odoo Orm Expert

skills CLI

$ npx skills add sickn33/agentic-awesome-skills --skill odoo-orm-expert -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI

$ gh skill install sickn33/agentic-awesome-skills odoo-orm-expert --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy

$ git clone --depth 1 https://github.com/sickn33/agentic-awesome-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/odoo-orm-expert .claude/skills/odoo-orm-expert && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Paste into Claude Code

Install the "odoo-orm-expert" agent skill from https://github.com/sickn33/agentic-awesome-skills/tree/main/skills/odoo-orm-expert into .claude/skills/odoo-orm-expert/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "odoo-orm-expert", then confirm the skill loads.

Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

$skill-installer

$skill-installer install https://github.com/sickn33/agentic-awesome-skills/tree/main/skills/odoo-orm-expert

Type this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.

skills CLI

$ npx skills add sickn33/agentic-awesome-skills --skill odoo-orm-expert -a codex

Project install goes to .agents/skills/; add -g for ~/.codex/skills/.

GitHub CLI

$ gh skill install sickn33/agentic-awesome-skills odoo-orm-expert --agent codex

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/sickn33/agentic-awesome-skills.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/odoo-orm-expert .agents/skills/odoo-orm-expert && rm -rf skills-src

Use ~/.agents/skills/ instead of .agents/skills for a personal install.

Codex skills documentation · loads skills from .agents/skills/

Paste into Codex

Install the "odoo-orm-expert" agent skill from https://github.com/sickn33/agentic-awesome-skills/tree/main/skills/odoo-orm-expert into .agents/skills/odoo-orm-expert/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "odoo-orm-expert", then confirm the skill loads.

Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

skills CLI

$ npx skills add sickn33/agentic-awesome-skills --skill odoo-orm-expert -a cursor

Project install goes to .agents/skills/; add -g for ~/.cursor/skills/.

GitHub CLI

$ gh skill install sickn33/agentic-awesome-skills odoo-orm-expert --agent cursor

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/sickn33/agentic-awesome-skills.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/odoo-orm-expert .cursor/skills/odoo-orm-expert && rm -rf skills-src

Use ~/.cursor/skills/ instead of .cursor/skills for a personal install.

Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/

Paste into Cursor

Install the "odoo-orm-expert" agent skill from https://github.com/sickn33/agentic-awesome-skills/tree/main/skills/odoo-orm-expert into .cursor/skills/odoo-orm-expert/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "odoo-orm-expert", then confirm the skill loads.

Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

gemini skills install

$ gemini skills install https://github.com/sickn33/agentic-awesome-skills.git --path skills/odoo-orm-expert

--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.

skills CLI

$ npx skills add sickn33/agentic-awesome-skills --skill odoo-orm-expert -a gemini-cli

Project install goes to .agents/skills/; add -g for ~/.gemini/skills/.

GitHub CLI

$ gh skill install sickn33/agentic-awesome-skills odoo-orm-expert --agent gemini-cli

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/sickn33/agentic-awesome-skills.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/odoo-orm-expert .gemini/skills/odoo-orm-expert && rm -rf skills-src

Use ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.

Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/

Paste into Gemini CLI

Install the "odoo-orm-expert" agent skill from https://github.com/sickn33/agentic-awesome-skills/tree/main/skills/odoo-orm-expert into .gemini/skills/odoo-orm-expert/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "odoo-orm-expert", then confirm the skill loads.

Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

GitHub CLI

$ gh skill install sickn33/agentic-awesome-skills odoo-orm-expert

Installs for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).

skills CLI

$ npx skills add sickn33/agentic-awesome-skills --skill odoo-orm-expert -a github-copilot

Project install goes to .agents/skills/; add -g for ~/.copilot/skills/.

Manual copy

$ git clone --depth 1 https://github.com/sickn33/agentic-awesome-skills.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/odoo-orm-expert .github/skills/odoo-orm-expert && rm -rf skills-src

Use ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.

GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/

Paste into GitHub Copilot

Install the "odoo-orm-expert" agent skill from https://github.com/sickn33/agentic-awesome-skills/tree/main/skills/odoo-orm-expert into .github/skills/odoo-orm-expert/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "odoo-orm-expert", then confirm the skill loads.

GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

skills CLI

$ npx skills add sickn33/agentic-awesome-skills --skill odoo-orm-expert -a opencode

OpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.

GitHub CLI

$ gh skill install sickn33/agentic-awesome-skills odoo-orm-expert --agent opencode

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/sickn33/agentic-awesome-skills.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/odoo-orm-expert .opencode/skills/odoo-orm-expert && rm -rf skills-src

Use ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.

OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/

Paste into OpenCode

Install the "odoo-orm-expert" agent skill from https://github.com/sickn33/agentic-awesome-skills/tree/main/skills/odoo-orm-expert into .opencode/skills/odoo-orm-expert/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "odoo-orm-expert", then confirm the skill loads.

OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

Facts

Skill name: odoo-orm-expert
GitHub stars: 47k
Used in: 2 other repos
Token cost: ~851 tokens
SKILL.md length: 271 words
Files: 1
Skills in repo: 1,394
Repo updated: Oct 6, 2026
First seen: Oct 7, 2026
Licence: MIT

At a glance

Master Odoo ORM patterns: search, browse, create, write, domain filters, computed fields, and performance-safe query techniques.

Works in 3 steps: Activate: Mention @odoo-orm-expert and… → Get Code: Receive correct, idiomatic… → Optimize: Ask for performance review on…
Tasks that involve ORMs and data access
SKILL.md covers Overview, When to Use This Skill, How It Works and Examples, plus 2 more sections
Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Odoo Orm Expert is an agent skill from sickn33/agentic-awesome-skills. Master Odoo ORM patterns: search, browse, create, write, domain filters, computed fields, and performance-safe query techniques.

Its SKILL.md is about 850 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases, covering ORMs and data access. It works with Odoo and SQL. The repository describes itself as: AAS Core is the local, agent-first control plane for complete catalog discovery, agent-owned selection, stack validation, and planning, backed by 2,400+ agentic skills. Includes… The licence is MIT.

When your agent uses it

Tasks that involve ORMs and data access

Example prompts

“/odoo-orm-expert”

Requirements

Python 3

Workflow steps

3 steps, taken from the first numbered list in SKILL.md.

Activate: Mention @odoo-orm-expert and describe what data operation you need.
Get Code: Receive correct, idiomatic Odoo ORM code with explanations.
Optimize: Ask for performance review on existing ORM code.

What it can do on your machine

Read from SKILL.md and the folder at commit 1e53ce2. It shows what the files ask for, not the result of running them.

Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md (its code samples are python).
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Odoo Orm Expert loads about 851 tokens when it runs. Until then it costs about 36 tokens; SKILL.md has 271 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it: ~36
When it runs · the whole SKILL.md, loaded when a task matches: ~851

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from sickn33/agentic-awesome-skills at commit 1e53ce2, republished under its MIT licence (© sickn33). 271 words, ~851 tokens.

Download SKILL.mdSave it as .claude/skills/odoo-orm-expert/SKILL.md (or your agent's skills folder).

name: odoo-orm-expert
description: Master Odoo ORM patterns: search, browse, create, write, domain filters, computed fields, and performance-safe query techniques.
risk: safe
source: self
date_added: 2026-09-04

Odoo ORM Expert

Overview

This skill teaches you Odoo's Object Relational Mapper (ORM) in depth. It covers reading/writing records, building domain filters, working with relational fields, and avoiding common performance pitfalls like N+1 queries.

When to Use This Skill

Writing search(), browse(), create(), write(), or unlink() calls.
Building complex domain filters for views or server actions.
Implementing computed, stored, and related fields.
Debugging slow queries or optimizing bulk operations.

How It Works

Activate: Mention @odoo-orm-expert and describe what data operation you need.
Get Code: Receive correct, idiomatic Odoo ORM code with explanations.
Optimize: Ask for performance review on existing ORM code.

Examples

Example 1: Search with Domain Filters

python

# Find all confirmed sale orders for a specific customer, created this year
import datetime

start_of_year = datetime.date.today().replace(month=1, day=1).strftime('%Y-%m-%d')

orders = self.env['sale.order'].search([
    ('partner_id', '=', partner_id),
    ('state', '=', 'sale'),
    ('date_order', '>=', start_of_year),
], order='date_order desc', limit=50)

# Note: pass dates as 'YYYY-MM-DD' strings in domains,
# NOT as fields.Date objects — the ORM serializes them correctly.

Example 2: Computed Field

python

total_order_count = fields.Integer(
    string='Total Orders',
    compute='_compute_total_order_count',
    store=True
)

@api.depends('sale_order_ids')
def _compute_total_order_count(self):
    for record in self:
        record.total_order_count = len(record.sale_order_ids)

Example 3: Safe Bulk Write (avoid N+1)

python

# ✅ GOOD: One query for all records
partners = self.env['res.partner'].search([('country_id', '=', False)])
partners.write({'country_id': self.env.ref('base.us').id})

# ❌ BAD: Triggers a separate query per record
for partner in partners:
    partner.country_id = self.env.ref('base.us').id

Best Practices

✅ Do: Use mapped(), filtered(), and sorted() on recordsets instead of Python loops.
✅ Do: Use sudo() sparingly and only when you understand the security implications.
✅ Do: Prefer search_count() over len(search(...)) when you only need a count.
✅ Do: Use with_context(...) to pass context values cleanly rather than modifying self.env.context directly.
❌ Don't: Call search() inside a loop — this is the #1 Odoo performance killer.
❌ Don't: Use raw SQL unless absolutely necessary; use ORM for all standard operations.
❌ Don't: Pass Python datetime/date objects directly into domain tuples — always stringify them as 'YYYY-MM-DD'.

Limitations

Does not cover cr.execute() raw SQL patterns in depth — use the Odoo performance tuner skill for SQL-level optimization.
Stored computed fields can cause significant write overhead at scale; this skill does not cover partitioning strategies.
Does not cover transient models (models.TransientModel) or wizard patterns.
ORM behavior can differ slightly between Odoo SaaS and On-Premise due to config overrides.

Files

Just SKILL.md in skills/odoo-orm-expert of sickn33/agentic-awesome-skills.

Open the folder on GitHubat commit 1e53ce2

Used in 2 other repositories

We found 15 copies of this SKILL.md (exact, near-identical or edited) in other folders, from 2 other GitHub owners. This page covers the copy in sickn33/agentic-awesome-skills, which our catalogue first saw on October 7, 2026.

Compare with similar skills

Odoo Orm Expert next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Odoo Orm Expert compared with similar skills
Skill	Stars	Used in	Tokens	Auto-check	Licence	Repo updated
Odoo Orm Expert this skillsickn33/agentic-awesome-skills	47k	2 repos	~851	Automated safety check: Pass	MIT	yesterday
Wtfnoobnooc/agent	1.4k	—	~2.1k	Automated safety check: Notes	None	1 mo ago
Jimmer OrmCoooolfan/XiaomiAlbumSyncer	418	—	~702	Automated safety check: Pass	GPL-3.0	yesterday
Drizzle Migrationsbretzel-app/crumbs	127	1 repos	~2.6k	Automated safety check: Pass	MIT	yesterday
Releaserogerpadilla/uql	125	—	~842	Automated safety check: Pass	MIT	yesterday
Database FundamentalsDanielPodolsky/ownyourcode	290	1 repos	~1.6k	Automated safety check: Pass	MIT	3 mo ago

Similar skills

Wtf
noobnooc/agent
Pre-launch and pre-commit audit for vibe coding projects. An agent skill from noobnooc/agent.
1.4k GitHub stars~2.1k tokensUpdated 1 mo ago
DatabasesAuto-check: notes
Jimmer Orm
Coooolfan/XiaomiAlbumSyncer
Jimmer ORM 开发助手（XiaomiAlbumSyncer 服务端），帮助编写实体映射代码、DTO 和 DSL 查询语句。适用于：(1) 定义或修改 Jimmer 实体（使用 @Entity 注解的 interface）；(2) 编写 Jimmer DSL 查询代码；(3) 配置实体关联关系（@ManyToOne, @OneToMany, @ManyToMany）；(4)…
418 GitHub stars~702 tokensUpdated yesterday
DatabasesAuto-check passed
Drizzle Migrations
bretzel-app/crumbs
Drizzle ORM schema management and SQLite migrations — adding tables, modifying columns, creating indexes, generating and running migrations, Drizzle query patterns.
127 GitHub starsUsed in 1 repo~2.6k tokens
DatabasesAuto-check passed
Release
rogerpadilla/uql
Cut and publish a uql release - review the change, changelog entry, commit, version bump and tag, GitHub Release, npm publish, docs site.
125 GitHub stars~842 tokensUpdated yesterday
DatabasesAuto-check passed
Database Fundamentals
DanielPodolsky/ownyourcode
Reviews schema design, SQL queries, ORM patterns. An agent skill from DanielPodolsky/ownyourcode.
290 GitHub starsUsed in 1 repo~1.6k tokens
DatabasesAuto-check passed
Typescript Bun Drizzle Quality
databuddy-analytics/Databuddy
Build or review Bun fullstack TypeScript code with Drizzle-backed SQL.
1.2k GitHub stars~1.8k tokensUpdated today
DatabasesAuto-check passed

Questions about Odoo Orm Expert

What does Odoo Orm Expert do?

Master Odoo ORM patterns: search, browse, create, write, domain filters, computed fields, and performance-safe query techniques. Odoo Orm Expert is an agent skill from sickn33/agentic-awesome-skills. Master Odoo ORM patterns: search, browse, create, write, domain filters, computed fields, and performance-safe query techniques.

When should I use Odoo Orm Expert?

Odoo Orm Expert fits situations like: tasks that involve ORMs and data access.

How do I install Odoo Orm Expert in Claude Code?

Run `npx skills add sickn33/agentic-awesome-skills --skill odoo-orm-expert -a claude-code`. Or copy the skill folder (skills/odoo-orm-expert in sickn33/agentic-awesome-skills) into .claude/skills/odoo-orm-expert in your project. Claude Code loads it when a task matches its description.

How do I install Odoo Orm Expert in Codex?

Run `npx skills add sickn33/agentic-awesome-skills --skill odoo-orm-expert -a codex`. Or copy the skill folder (skills/odoo-orm-expert in sickn33/agentic-awesome-skills) into .agents/skills/odoo-orm-expert in your project. Codex loads it when a task matches its description.

Can I use Odoo Orm Expert in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add sickn33/agentic-awesome-skills --skill odoo-orm-expert -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/odoo-orm-expert, .gemini/skills/odoo-orm-expert, .github/skills/odoo-orm-expert and .opencode/skills/odoo-orm-expert in your project.

What does Odoo Orm Expert need to run?

SKILL.md names no scripts, command-line tools or credentials: Odoo Orm Expert is instructions for the agent only. Our summary lists: Python 3.

Does Odoo Orm Expert access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Odoo Orm Expert safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Odoo Orm Expert use?

Odoo Orm Expert is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Odoo Orm Expert use?

About 851 tokens (SKILL.md is roughly 3.4k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Odoo Orm Expert?

Skills that share tags, products or a category with Odoo Orm Expert: Wtf (noobnooc/agent, 1.4k stars), Jimmer Orm (Coooolfan/XiaomiAlbumSyncer, 418 stars), Drizzle Migrations (bretzel-app/crumbs, 127 stars) and Release (rogerpadilla/uql, 125 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Odoo Orm Expert?

sickn33 (a GitHub user) maintains it in sickn33/agentic-awesome-skills, which has 47,304 GitHub stars. The repository holds 1,394 skills in this directory. The repository was last updated on October 6, 2026.

Source: sickn33/agentic-awesome-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.

Install Odoo Orm Expert

Facts

At a glance

What it does

When your agent uses it

Example prompts

Requirements

Workflow steps

What it can do on your machine

Tool permissions

Runs code

Network

Credentials

Context cost

Safety

SKILL.md

Odoo ORM Expert

Overview

When to Use This Skill

How It Works

Examples

Example 1: Search with Domain Filters

Example 2: Computed Field

Example 3: Safe Bulk Write (avoid N+1)

Best Practices

Limitations

Files

Used in 2 other repositories

Compare with similar skills

Similar skills

More from sickn33/agentic-awesome-skills

Related

Questions about Odoo Orm Expert