frappe-reports

Create Frappe reports using Report Builder, SQL, and Python scripts.

48|17|Updated Feb 7, 2026
One-click install
npx skills add https://github.com/lubusIN/agent-skills --skill frappe-reports
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: frappe-reports
Source: https://github.com/lubusIN/agent-skills/tree/main/skills/frappe/frappe-reports
Command: npx skills add https://github.com/lubusIN/agent-skills --skill frappe-reports

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Frappe reports streamline data access within the ERP framework, reducing manual aggregation and enabling non-technical users to explore data insights through standardized reporting.

Core Features & Use Cases

  • Supports Report Builder for UI-driven reports, Query Reports (SQL), and Script Reports (Python + JS) for custom logic and visualizations.
  • Enables dashboards, data analysis, and printable report formats across multiple DocTypes.
  • Real-world example: build a Sales Performance dashboard showing orders, customers, totals, and charts with filters.

Quick Start

Use the frappe-reports skill to generate a Sales Summary report for the current quarter.

Frequently Asked Questions about frappe-reports

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

FAQPage Schema
How do I create custom Frappe reports for data analysis and dashboards?

To create custom Frappe reports, you can use the Report Builder for UI-driven generation, Query Reports for direct SQL data aggregation, or Script Reports combining Python and JS for complex dashboard visualizations.

What is the difference between Query Reports and Script Reports in Frappe?

Query Reports in Frappe use SQL templates for straightforward data extraction, while Script Reports leverage Python and JS to apply custom logic, format client-side UI code, and build advanced visualizations.

Can I enforce permission controls and data integrity in Frappe report builders?

Yes, Frappe report builders enforce proper permission controls and data integrity through metadata configurations, ensuring standardized reporting and secure data access across multiple DocTypes.

How do I build a Sales Performance dashboard with Frappe reports?

You build a Sales Performance dashboard by creating a Frappe report that aggregates orders, customers, and totals, then applying filters and charts to visualize data through client-side UI code and SQL templates.

When should I use SQL templates versus Python and JS for Frappe reports?

Use SQL templates for Frappe reports when you need direct database queries and simple data aggregation, and switch to Python and JS Script Reports when you require custom logic, flexible formatting, or visualizations.