erpnext-database
Installation
SKILL.md
ERPNext Database Operations
Quick Overview
Frappe provides three abstraction levels for database operations:
| Level | API | Usage |
|---|---|---|
| High-level ORM | frappe.get_doc, frappe.new_doc |
Document CRUD with validations |
| Mid-level Query | frappe.db.get_list, frappe.db.get_value |
Reading with filters |
| Low-level SQL | frappe.db.sql, frappe.qb |
Complex queries, reports |
RULE: Always use the highest abstraction level appropriate for your use case.
Decision Tree
Related skills