Home / impertio-studio / frappe_claude_skill_package · skills/source/syntax/frappe-syntax-reports/SKILL.md · GitHub

frappe-syntax-reports skillA

frappe-syntax-reports is agent-read markdown (skill) from impertio-studio/frappe_claude_skill_package: Use when building Query Reports, Script Reports, or configuring Report Builder, including chart data integration. Prevents report errors from wrong column definitions, missing permissions, and incorrect data formatting. Covers Query Report (SQL-based), Script Report (Python-based), Report Builder, report columns definition, filters, chart_data, report permissions, prepared_report. Keywords: Query Report, Script Report, Report Builder, report columns, filters, chart_data, frappe.query_report, pre.

Indexed from public GitHub and served as immutable, content-addressed versions. Install it pinned to an exact SHA-256 with the mdr CLI, and every file is verified against the hash recorded here before it reaches your agent. The deterministic audit below grades the latest version, and the same file always earns the same grade.

What the file says

# Reports: Query, Script & Report Builder

## Quick Reference

### Report Types at a Glance

| Type | Code Required | Use Case | Permission |
|------|--------------|----------|------------|
| Report Builder | None | Simple single-DocType listing with filters, group by | Any user |
| Query Report | SQL only | Direct SQL queries, legacy column format | System Manager |
| Script Report (Standard) | Python + JS | Complex logic, charts, summaries, trees | Administrator + Developer Mode |
| Script Report (Custom) | Python in UI | Quick custom reports without app deployment | System Manager |

### Script Report execute() Return Values

```python
def execute(filters=None):
    columns = [...]   # List of dicts
    data = [...]      # List of dicts or lists
    message = "..."   # Optional: HTML message above report
    chart = {...}     # Optional: chart configuration
    report_summary = [...]  # Optional: summary cards
    skip_total_row = False  # Optional: suppress auto-total
    return columns, data, message, chart, report_summary, skip_total_row
```

### Column Definition (Dict Format)

```python
columns = [
    {
        "fieldname": "customer",
        "label": _("Customer"),
…

Read the whole file at its exact version.

How to install

Latest version
mdr add impertio-studio/frappe_claude_skill_package/frappe-syntax-reports@v2.0
Exact content
mdr add impertio-studio/frappe_claude_skill_package/frappe-syntax-reports@sha256:6607df8d84eda53f

Pin to a label to follow the author's releases, or to a sha256 to freeze the exact bytes forever. Either way the resolved hash is written to mdr.lock, and mdr install reproduces it on any machine.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_sis2u2wpcongzkzd.svg)](https://markdownregistry.com/a/art_sis2u2wpcongzkzd)

1 badge views in 30 days

Versions

versioncommittedcommitsizeaudit
v2.0 latest2026-03-30 d83dc82 9,130 BA view · diff
v2.02026-03-20 a105128 9,050 BA view · diff
v2.02026-03-20 bb8f8c3 965 BA view

Audit of the latest version

A  17 of 17 checks passed. Deterministic, no model, same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (9130 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

impertio-studio/frappe_claude_skill_package · 182 stars · license NOASSERTION · pushed 2026-09-17 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_sis2u2wpcongzkzd
GET https://markdownregistry.com/api/v1/resolve?ref=impertio-studio/frappe_claude_skill_package/frappe-syntax-reports
GET https://markdownregistry.com/api/v1/blob/6607df8d84eda53fb7633030ee51f5064759d1f77dec6d8a92581aed39df1cc1

Your agent does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

More from impertio-studio/frappe_claude_skill_package

CLAUDE.md claude
impertio-studio/frappe_claude_skill_package · CLAUDE.md
git:20260401.36cfa80 · audit A · 182 stars
frappe-agent-architect skill
impertio-studio/frappe_claude_skill_package · skills/source/agents/frappe-agent-architect/SKILL.md · Use when designing multi-app Frappe architectures, deciding whether to split functionality into separate apps, or…
v2.0 · audit A · 182 stars
frappe-agent-debugger skill
impertio-studio/frappe_claude_skill_package · skills/source/agents/frappe-agent-debugger/SKILL.md · Use when debugging Frappe errors, using bench console for live inspection, analyzing tracebacks, or reading Frappe log…
v2.0 · audit A · 182 stars
frappe-agent-interpreter skill
impertio-studio/frappe_claude_skill_package · skills/source/agents/frappe-agent-interpreter/SKILL.md · Use when receiving vague or unclear ERPNext/Frappe development requests that need interpretation. Transforms…
v2.0 · audit A · 182 stars
frappe-agent-migrator skill
impertio-studio/frappe_claude_skill_package · skills/source/agents/frappe-agent-migrator/SKILL.md · Use when migrating a Frappe app between major versions, detecting breaking API changes, or resolving post-migration…
v2.0 · audit A · 182 stars
frappe-agent-validator skill
impertio-studio/frappe_claude_skill_package · skills/source/agents/frappe-agent-validator/SKILL.md · Use when reviewing or validating Frappe/ERPNext code against best practices and common pitfalls. Checks generated code…
v2.0 · audit A · 182 stars
frappe-core-api skill
impertio-studio/frappe_claude_skill_package · skills/source/core/frappe-core-api/SKILL.md · Use when building ERPNext/Frappe API integrations (v14/v15/v16) including REST API, RPC API, authentication, webhooks…
v2.0 · audit A · 182 stars
frappe-core-cache skill
impertio-studio/frappe_claude_skill_package · skills/source/core/frappe-core-cache/SKILL.md · Use when implementing Redis caching, cache invalidation, or distributed locking in Frappe. Prevents stale cache bugs…
v2.0 · audit A · 182 stars
frappe-core-database skill
impertio-studio/frappe_claude_skill_package · skills/source/core/frappe-core-database/SKILL.md · Use when performing database operations in ERPNext/Frappe v14-v16. Covers frappe.db methods, ORM patterns…
v2.0 · audit A · 182 stars
frappe-core-files skill
impertio-studio/frappe_claude_skill_package · skills/source/core/frappe-core-files/SKILL.md · Use when handling file uploads, attachments, private/public file access, or S3 storage configuration. Prevents broken…
v2.0 · audit A · 182 stars
frappe-core-logging skill
impertio-studio/frappe_claude_skill_package · skills/source/core/frappe-core-logging/SKILL.md · Use when implementing logging, error tracking, or monitoring in Frappe v14-v16. Covers frappe.logger() for file-based…
v3.0 · audit A · 182 stars
frappe-core-notifications skill
impertio-studio/frappe_claude_skill_package · skills/source/core/frappe-core-notifications/SKILL.md · Use when implementing email notifications, system alerts, Assignment Rules, Auto Repeat, or ToDo items. Prevents…
v2.0 · audit A · 182 stars

Every file in impertio-studio/frappe_claude_skill_package

Browse by kind, by grade A, or by owner.