Python Odoo Cursor Rules

The python-odoo-cursor-rules skill enables AI agents to interact with Odoo ERP systems using Python-based cursor logic. It facilitates direct database querying and record manipulation within the Odoo environment through structured rule definitions. This allows for dynamic data retrieval and updates without requiring manual SQL execution or complex API orchestration.

When to use it

• Automating routine inventory checks by pulling real-time stock levels directly from the Odoo database.
• Generating custom reports that aggregate sales data across multiple records using Python cursor iteration.
• Updating customer contact information in bulk based on specific filtering criteria defined in rules.
• Validating order statuses before triggering downstream workflows within the ERP system.

Key capabilities

• Executes Python-based cursor operations to traverse Odoo database records efficiently.
• Defines reusable rules for consistent data access patterns across different agent tasks.
• Integrates seamlessly with the Odoo backend architecture for native data handling.
• Supports complex filtering and sorting logic during record retrieval.

Example prompts

• "Use the cursor rules to fetch all open sales orders created this week and calculate their total value."
• "Update the status of any customer records where the last login date is older than 90 days."
• "Retrieve a list of products with stock levels below the safety threshold and prepare them for reordering."

Tips & gotchas

Ensure your AI agent has appropriate read/write permissions within the Odoo instance before executing write operations via cursor rules. Test rule definitions in a sandbox environment first to prevent unintended data modifications in production databases.