Odoo Service Skill

Capabilities

This skill manages the complete Odoo server lifecycle:

• Server: Start, stop, restart, status check (Windows/Linux/macOS)
• Environment: Auto-detect venv/Docker/bare Python; initialize new environments
• Database: Backup, restore, create, drop, list, reset admin password
• Docker: Generate Dockerfiles/compose, manage containers, exec into shells
• IDE: Generate VSCode and PyCharm configurations with debug support
• Module: Install, update, scaffold, refresh module list
• Readiness: Production quality gate (tests, security, translations, manifest)

Environment Detection

Priority order: Docker > venv > bare Python.

Override with flags: --docker, --venv, --env bare.

Odoo Version Matrix

Quick Reference

Server

# Start (dev mode)
python -m odoo -c conf/PROJECT.conf --dev=all

# Start (production)
python -m odoo -c conf/PROJECT.conf --workers=4

# Stop (Windows)
FOR /F "tokens=5" %P IN ('netstat -ano ^| findstr :8069') DO taskkill /PID %P /F

# Stop (Linux/Mac)
lsof -ti:8069 | xargs kill -9

Module Operations

# Install
python -m odoo -c conf/PROJECT.conf -d DB -i MODULE --stop-after-init

# Update (most common after code changes)
python -m odoo -c conf/PROJECT.conf -d DB -u MODULE --stop-after-init

# Refresh module list (before installing NEW modules)
python -m odoo -c conf/PROJECT.conf -d DB --update-list

Database

# Backup (compressed custom format - recommended)
pg_dump -U odoo -h localhost -Fc DBNAME -f backups/DBNAME_YYYYMMDD.dump

# Restore
createdb -U odoo NEWDB && pg_restore -U odoo -d NEWDB backup.dump

# Reset admin password
psql -U odoo -d DBNAME -c "UPDATE res_users SET password='newpass' WHERE login='admin';"

Docker

docker-compose up -d              # Start
docker-compose down               # Stop
docker-compose up -d --build      # Rebuild and start
docker-compose exec odoo bash     # Shell into container

Scripts

Located in odoo-service/scripts/ — all standalone, stdlib-only (optional psutil):

Config File Format

[options]
addons_path = odoo/addons,projects/PROJECTNAME
admin_passwd = 123
db_host = localhost
db_port = 5432
db_user = odoo
db_password = odoo
dbfilter = PROJECTNAME.*
http_port = 8069
gevent_port = 8072
workers = 0

Naming convention: conf/{PROJECT}{VERSION}.conf (e.g., conf/myproject17.conf).