A tool for copying a remote Odoo database and file storage directly into a local Odoo development environment. Odoo is business software, and the filestore is where its uploaded files are kept.

It helps developers stream an Odoo environment into the local ~/odoo project over SSH. It can also neutralize the copied data when requested.

It refreshes local development data from a remote production, staging, or test system without creating temporary dump files on disk. Database and file transfers run at the same time.

odoo-stream — Skill for Claude Code and Codex by dannyg-sys

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent

npx skills add dannyg-sys/odoo-mcp-server --skill skill-stream

Clone the repo

git clone --depth 1 https://github.com/dannyg-sys/odoo-mcp-server

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

README.md

[![agentmods](https://agentmods.dev/badge/skills/dannyg-sys/odoo-mcp-server/skill-stream/github.svg)](https://agentmods.dev/skills/dannyg-sys/odoo-mcp-server/skill-stream)

Your own site

<a href="https://agentmods.dev/skills/dannyg-sys/odoo-mcp-server/skill-stream"><img src="https://agentmods.dev/badge/skills/dannyg-sys/odoo-mcp-server/skill-stream/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

Your own site · 80×15

<a href="https://agentmods.dev/skills/dannyg-sys/odoo-mcp-server/skill-stream"><img src="https://agentmods.dev/badge/skills/dannyg-sys/odoo-mcp-server/skill-stream.svg" alt="Reviewed on agentmods" width="80" height="20"></a>

Per session 101 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.

When invoked 1,361 The whole file, excluding the scripts and references it only reads on demand.

Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.

Origin original No closer match found in the catalogue.

Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

Model	Per session	Once invoked
Fable 5.1	$0.00101	$0.01361
Opus 5.5	$0.00040	$0.00544
Sonnet 5.5	$0.00020	$0.00272
Haiku 4.5	$0.00010	$0.00136

Measured 2mo ago against content hash 2633e47b5d27, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

odoo-stream scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 2mo ago.

The scan reads SKILL.md. This mod also ships 1 executable file (stream_odoo.sh), listed below but not scanned — reading those needs a real analyzer, not pattern matching.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

skill-stream/SKILL.md · 120 lines

How it starts

The opening of the file, as written. The whole thing — 120 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Stream a remote Odoo DB + filestore into local dev

Pulls a remote nellika.sh / tcff Odoo deployment's database and filestore directly into the LOCAL dev environment at ~/odoo by streaming over SSH — pg_dump | pg_restore and tar | tar, with no intermediate dump files on disk. The DB and filestore transfers run in parallel.

The skill entry point is a thin wrapper script:

__STREAM_SH__ <remote_ssh_host> [options]

It forwards to the single shared implementation — the engine's stream verb in manage_odoo.sh (stream_remote_odoo), the same code the odoo CLI and the MCP server use. So these are equivalent:

__STREAM_SH__ nellika_production_odoo --neutralize     # this skill (prompts unless --yes)
node __ODOO_CLI__ stream nellika_production_odoo --neutralize   # the odoo CLI
# MCP:  odoo_project  action=stream  remoteHost=nellika_production_odoo  neutralize=true

What it does

Discovers the remote (read-only): one ssh sources the remote ~/scripts/odoo.env to read odoo_db and data_dir (and PGUSER/PGPASSWORD, so pg_dump authenticates there). Override with --remote-db / --remote-data-dir.
Reads the ACTIVE local project from ~/odoo/odoo.conf (db_name, db_user, db_host, db_port, filestore).
Stops local Odoo, then runs two streams in parallel:
- DB: terminate connections → dropdb/createdb -O <user> → create unaccent+pg_trgm (IMMUTABLE) → ssh … pg_dump -Fc | pv | pg_restore.
- Filestore: ssh … tar -zc | pv | tar -zx, then rename $odoo_db → <db_name>.
Optionally neutralize (reuses odoo-bin neutralize), then start Odoo.

Prerequisites

Local Postgres major version must be >= the remote's. Remote production is PG17, so the local cluster must be PG17. The script uses the Postgres.app 17 client tools at /Applications/Postgres.app/Contents/Versions/17/bin (pg_restore, createdb, dropdb, psql) when present, else falls back to PATH.
pv (progress bar) is optional — falls back to a plain pipe.
SSH access configured in ~/.ssh/config.d/. Hosts follow the pattern <deployment>_<env>_odoo, e.g. nellika_production_odoo, nellika_staging_odoo, nellika_test_odoo, tcff_production_odoo, …
The remote must have ~/scripts/odoo.env exporting odoo_db, data_dir, PGUSER, PGPASSWORD.

Read the full file on GitHub · 120 lines

Files

What ships with it

1 file beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

stream_odoo.sh 585 B runs code

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

2mo ago First seen · 120 lines · 101 tokens per session scan A 2633e47b5d27

Subscribe to this mod's changes

odoo-stream is a skill published in the GitHub repository dannyg-sys/odoo-mcp-server (2 stars, last pushed 1mo ago), licensed MIT. It adds 101 tokens to every session and 1,361 once invoked, about $0.0004 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.

Databases DevOps and cloud

odoo-stream next to 6 skills from other repositories
Mod	Type	Stars	Last push	Licence	Scan	Tokens	Works with
odoo-streamdannyg-sys/odoo-mcp-server	Skill	2	1mo ago	MIT	A	101	Claude Code, Codex
create-prprisma/orm	Skill	48k	yesterday	Apache-2.0	A	48	Claude Code, Codex
schema-explorationlangchain-ai/deepagents	Skill	31k	yesterday	MIT	A	57	Claude Code, Codex
atlas-mssqlariga/atlas	Skill	8.8k	2d ago	Apache-2.0	A	163	Claude Code
ha-data-storesshiwenwen/hope-agent	Skill	1.9k	yesterday	MIT	A	115	Claude Code, Codex
nornicdb-cypher-queriesorneryd/NornicDB	Skill	924	yesterday	MIT	A	79	Claude Code, Codex
volcengine-rds-postgresqlbytedance/agentkit-samples	Skill	484	2d ago	Apache-2.0	A	63	Claude Code, Codex