erpnext-database
OfficialGuides robust ERPNext database patterns.
AuthorOpenAEC-Foundation
Version1.0.0
Installs0
System Documentation
What problem does it solve?
ERPNext database operations can be complex, and teams often struggle with choosing the right abstraction level, writing efficient queries, and maintaining data integrity across ERPNext/Frappe apps.
Core Features & Use Cases
- High-level ORM patterns for document CRUD and validations with frappe.get_doc and frappe.new_doc
- Mid-level querying with frappe.db.get_list and frappe.db.get_value, plus safe batch operations
- Low-level SQL access with frappe.db.sql and Query Builder for advanced reports
- Transaction control, caching patterns, and best practices to avoid common ERPNext data pitfalls
- Use cases: building robust ERPNext apps, optimizing data access, and preventing N+1 queries
Quick Start
Start by reviewing ERPNext database patterns in your project and implement the recommended abstraction levels for your use cases.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: erpnext-database Download link: https://github.com/OpenAEC-Foundation/ERPNext_Anthropic_Claude_Development_Skill_Package/archive/main.zip#erpnext-database Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.