agentsclimarketplace

Frappe sql

Skill Dkm0315/frappe-agent/skills/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.From its SKILL.md

Install
npx -y skills add Dkm0315/frappe-agent --skill frappe-sql

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

SKILL.md

1.0 KB, as published. Nobody here has run it

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

Keep looking

Skills are one crate of 613,757. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.