Skip to content
cccskills
FreePublished on GitHub

frappe-sql

Frappe-native SQL and ORM guidance for `frappe.db`, Query Builder, `tab{DocType}` tables, permission-sensitive queries, and raw SQL review. Use when writing or reviewing database access in Frappe.

The English summary is being prepared. Showing the original description.

See how to install

Files included (1)

  • SKILL.md988 B

SKILL.md (original)

Review the instructions the agent will receive before you install.

Treat SQL and ORM decisions as first-class Frappe architecture choices.

Cover:

  • frappe.db.get_list
  • frappe.db.get_all
  • frappe.db.get_value
  • frappe.db.exists
  • frappe.qb
  • frappe.db.sql
  • transaction boundaries
  • permission implications

Rules:

  • prefer Frappe-native APIs when they express the query clearly
  • treat get_all and raw SQL as deliberate choices
  • use correct tab{DocType} table naming when raw SQL is necessary
  • flag brittle or permission-blind SQL
  • distinguish reporting SQL from transactional logic

When reviewing code, explicitly state:

  • why the chosen access layer is or is not appropriate
  • whether permissions are respected or bypassed
  • whether the query belongs in a report, service, patch, or controller

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

Frappe backend guidance for Python and backend-adjacent JavaScript surfaces such as client interaction patterns, hooks, APIs, patches, scheduler logic, reports, and server-side review. Use when implementing or reviewing Frappe backend behavior.

The English summary is being prepared. Showing the original description.

Dkm0315/frappe-agent25Updated Oct 11, 2026

Bench-aware Frappe operations guidance for app installs, branch switching, updates, migrations, site inspection, ports, and process state. Use when a task involves bench commands or local environment operations.

The English summary is being prepared. Showing the original description.

Dkm0315/frappe-agent25Updated Oct 11, 2026

Frappe Builder website and page-building guidance for pages, blocks, components, forms, routing, CMS-style content, SEO, and web UX. Use when work touches Frappe Builder, website pages, landing pages, or content-driven experiences.

The English summary is being prepared. Showing the original description.

Dkm0315/frappe-agent25Updated Oct 11, 2026

Frappe CRM guidance for leads, deals, contacts, organizations, pipelines, activities, assignment, dashboards, and sales workflows. Use when work touches Frappe CRM or CRM-style sales processes in the Frappe ecosystem.

The English summary is being prepared. Showing the original description.

Dkm0315/frappe-agent25Updated Oct 11, 2026

Frappe customization-surface guidance covering Custom Field, Property Setter, Client Script, Server Script, Workspace, Web Page, Page, Print Format, Report, Dashboard, Workflow, Role, Notification, Webhook, and related builder/admin DocTypes. Use when choosing or changing Frappe customization layers.

The English summary is being prepared. Showing the original description.

Dkm0315/frappe-agent25Updated Oct 11, 2026

Frappe DocType creation and form UX guidance. Use when creating, reviewing, or redesigning DocTypes, including field choice, tabs, sections, columns, required fields, naming, child tables, and form usability.

The English summary is being prepared. Showing the original description.

Dkm0315/frappe-agent25Updated Oct 11, 2026

See all skills by Dkm0315

Report a problem with this skill