frappe-core-database

Build parameterized SQL queries for ERPNext and Frappe database operations.

Updated Aug 23, 2026

Search Tags:#performance #database #data #sql #query #frappe #erpnext

Ready to run

npx skills add https://github.com/nathanabay/epc_bespo --skill frappe-core-database-nathanabay

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: frappe-core-database
Source: https://github.com/nathanabay/epc_bespo/tree/main/skills-frappe/core/frappe-core-database
Command: npx skills add https://github.com/nathanabay/epc_bespo --skill frappe-core-database-nathanabay

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pypika, pypdf, pdfplumber, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies and consolidates database operations within ERPNext and Frappe frameworks, reducing manual SQL scripting and improving data handling accuracy.

Core Features & Use Cases

Database Interaction: Performs CRUD operations, complex queries, and data migrations efficiently.
Data Retrieval & Maintenance: Facilitates data validation, performance tuning, and reporting tasks for developers and administrators.
Use Case: A developer needs to query sales data across multiple branches using parameterized SQL, ensuring safety and efficiency in data access.

Quick Start

Use the frappe-core-database skill to run a parameterized query that fetches all open sales invoices.

Frequently Asked Questions about frappe-core-database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I run parameterized SQL queries in ERPNext to fetch sales data safely?▼

To run parameterized SQL queries in ERPNext safely, use this Skill to build queries and perform data retrieval, ensuring safe and efficient database access without manual scripting risks.

How do I perform database migrations and CRUD operations in Frappe without writing manual SQL?▼

You can perform database migrations and CRUD operations in Frappe by using this Skill to consolidate database interactions, reducing manual SQL scripting and improving data handling accuracy.

Does this database query building approach work with the Pypika library in Frappe?▼

Yes, this database query building approach works with Pypika, utilizing the dependency to facilitate safe and efficient query building and data manipulation within ERPNext and Frappe frameworks.

What is the best way to tune database performance and validate data in an ERPNext environment?▼

The best way to tune database performance and validate data in ERPNext is using this Skill, which facilitates data validation, performance tuning, and reporting tasks for administrators and developers.

Can I use this Skill to query sales data across multiple branches in Frappe?▼

Yes, you can use this Skill to query sales data across multiple branches in Frappe, as it supports developers in executing complex queries and ensuring safe, efficient data access.