skills.rest
nathanabay
nathanabayCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/nathanabay/epc_bespo --skill frappe-core-database-nathanabay
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
OpenAEC-FoundationOpenAEC-Foundation
163

frappe-core-api

Define REST/RPC endpoints, authentication, and webhooks for Frappe/ERPNext integrations.

Official
Advanced
BirdywenBirdywen
1

sqlite-data

Create, query, analyze, and export SQLite data via the sqlite3 CLI.

Community
Intermediate
juliochwdjuliochwd
1

pdf

Extract text and tables from PDF documents using Python libraries.

Community
Advanced
anonymousminatianonymousminati

frappe-syntax-query-builder

Builds Frappe database queries with frappe.qb across MariaDB and PostgreSQL.

Community
Advanced