Odoo 18 CLI Toolkit

A comprehensive command-line toolkit for managing Odoo 18 Community Edition. Combines click-odoo ecosystem with PostgreSQL MCP server for seamless database operations and business logic automation.

Features

Database Management — Backup, restore, copy, and initialize Odoo databases directly from terminal without web interface.

Module Operations — Update, install, and manage Odoo modules programmatically with automatic transaction handling.

Custom Scripting — Execute Python scripts with full Odoo environment access, automatic DB connection, and transaction management.

AI-Powered Queries — PostgreSQL MCP server enables natural language database operations through AI assistants.

Components

Component	Purpose
click-odoo	Core library for running Python scripts with Odoo environment
click-odoo-contrib	Pre-built CLI tools for database and module management
postgres-mcp	MCP server for AI-powered PostgreSQL operations

Quick Start

Prerequisites

• Python 3.10+
• PostgreSQL 14+
• Odoo 18 Community Edition
• uv (Python package manager)

Installation

# Clone repository
git clone https://github.com/nghidanh2005/odoo-18-cli-toolkit.git
cd odoo-18-cli-toolkit

# Create virtual environment
uv venv
.venv\Scripts\activate  # Windows
source .venv/bin/activate  # Linux/Mac

# Install dependencies
uv pip install click-odoo click-odoo-contrib

Usage Examples

# Update all modules
click-odoo-update -d your_database --all

# Backup database
click-odoo-backupdb -d your_database backup.zip

# Copy database for testing
click-odoo-copydb -d source_db -n test_db

# Run custom script
click-odoo -d your_database your_script.py

MCP Server Configuration

Add to your MCP config for AI-powered database access:

{
  "postgres": {
    "command": "uv",
    "args": [
      "run",
      "--directory",
      "/path/to/postgres-mcp",
      "postgres-mcp",
      "postgresql://user:pass@localhost:5432/your_database"
    ]
  }
}

Documentation

• KNOWLEDGE_BASE.md — Detailed component documentation and workflow guide
• click-odoo docs — Core library documentation
• click-odoo-contrib docs — CLI tools reference

License

This project integrates open-source tools under their respective licenses:

• click-odoo: LGPL-3.0
• click-odoo-contrib: LGPL-3.0
• postgres-mcp: Apache-2.0

Contributing

Issues and pull requests welcome. See individual component repositories for contribution guidelines.