frappe-core-database
OfficialMaster ERPNext DB ops with safe queries.
AuthorOpenAEC-Foundation
Version1.0.0
Installs0
System Documentation
What problem does it solve?
ERPNext/Frappe database operations across v14–v16 can be error-prone and unsafe if not standardized. This skill provides best practices for using frappe.db, ORM patterns, raw SQL with parameterization, caching strategies, and transaction handling to ensure robust, high-performance data access.
Core Features & Use Cases
- Standardized patterns for common database tasks (read, write, update, delete) with proper permission handling and error checking.
- Clear guidance on when to use ORM vs raw SQL vs the Query Builder, including performance-focused strategies and caching.
- Real-world usage examples covering get_value/get_list, bulk updates, transaction control, and safe SQL patterns for ERPNext apps.
Quick Start
Begin by reviewing core database patterns and integrating safe, scalable operations into your Frappe ERPNext codebase.
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: frappe-core-database Download link: https://github.com/OpenAEC-Foundation/Frappe_Claude_Skill_Package/archive/main.zip#frappe-core-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 471,000+ vetted skills library on demand.