frappe-sql
Frappe-native SQL and ORM guidance for `frappe.db`, Query Builder, `tab{DocType}` tables, permission-sensitive queries, and raw SQL review.
Skill by Dkm0315
Install
Works with Claude Code, Claude apps, Codex, Cursor, Gemini CLI, GitHub Copilot, VS Code, OpenCode, Goose, Windsurf. Read the repository before you give any tool access to your data.
npx agentmarket install skill/dkm0315-frappe-sql
Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.
Get the weekly diff
The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.
About
Use cases: backend, writing
Reviews
Write a reviewNo reviews yet. Installed it? Reviews come from verified installers only. How reviews work
Permissions
What this skill can do and what it asks for, from its SKILL.md. Checked Oct 25, 2026.
- Tools
- No tools found
- Secrets
- None asked for
- Install scripts
- None found
Network hosts it talks to 1
codeload.github.com· found in install command
Files it touches
~/.claude/skills/frappe-sql
What's inside
- Skill name
frappe-sql- Description
- 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.
- License
- MIT
- Instructions
- 26 lines in SKILL.md · view on GitHub
Files (1)
- SKILL.md
SKILL.md (first lines)
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 controllerFrom Dkm0315/frappe-agent, MIT.
More from Dkm0315/frappe-agent
- 0.558score
frappe-backend
Dkm0315
Frappe backend guidance for Python and backend-adjacent JavaScript surfaces such as client interaction patterns, hooks, APIs, patches, scheduler logic…
SkillCFreshness: C★ 26Claude Code +9 - 0.558score
frappe-bench
Dkm0315
Bench-aware Frappe operations guidance for app installs, branch switching, updates, migrations, site inspection, ports, and process state.
SkillCFreshness: C★ 26Claude Code +9 - 0.558score
frappe-crm
Dkm0315
Frappe CRM guidance for leads, deals, contacts, organizations, pipelines, activities, assignment, dashboards, and sales workflows.
SkillCFreshness: C★ 26Claude Code +9 - 0.558score
frappe-customization
Dkm0315
Frappe customization-surface guidance covering Custom Field, Property Setter, Client Script, Server Script, Workspace, Web Page, Page, Print Format, Report…
SkillCFreshness: C★ 26Claude Code +9 - 0.558score
frappe-drive
Dkm0315
Frappe Drive guidance for files, folders, sharing, permissions, storage, previews, document workflows, and file-linked business processes.
SkillCFreshness: C★ 26Claude Code +9 - 0.558score
frappe-erpnext
Dkm0315
ERPNext-aware reasoning for accounting, selling, buying, stock, manufacturing, projects, HR, support, education, CRM, and other ERPNext module work.
SkillCFreshness: C★ 26Claude Code +9 - 0.558score
frappe-frontend
Dkm0315
Frappe frontend guidance for Vue and React, including desk pages, `www` pages, `frappe-ui`, Doppio-style frontends, client scripts, and external SPA…
SkillCFreshness: C★ 26Claude Code +9 - 0.558score
frappe-fullstack
Dkm0315
End-to-end Frappe and ERPNext implementation guidance spanning backend Python, backend JavaScript surfaces, Vue or React frontends, customizations, and…
SkillCFreshness: C★ 26Claude Code +9 - 0.558score
frappe-helpdesk
Dkm0315
Frappe Helpdesk implementation and customization guidance for ticket intake, SLAs, assignment, portals, knowledge base, notifications, and support workflows.
SkillCFreshness: C★ 26Claude Code +9 - 0.558score
frappe-insights
Dkm0315
Frappe Insights and analytics guidance for dashboards, query design, charts, permissions, metrics, ERPNext reporting, and operational analytics.
SkillCFreshness: C★ 26Claude Code +9 - 0.558score
frappe-lms
Dkm0315
Frappe LMS customization guidance for courses, batches, lessons, quizzes, assessments, enrollment, progress, certificates, portals, and learning workflows.
SkillCFreshness: C★ 26Claude Code +9 - 0.558score
frappe-search
Dkm0315
Frappe-specific search and discovery guidance for finding benches, apps, remotes, sites, ports, hooks, DocTypes, builder DocTypes, and frontend surfaces…
SkillCFreshness: C★ 26Claude Code +9
Signals
- Stars
- 26
- Forks
- 4
- Open issues
- 1
- Last commit (this folder)
- Apr 22, 2026 (6 months ago)
- Last release
- May 16, 2026 (5 months ago)
From GitHub (fetched Oct 24, 2026).
Details
- License
- MIT
- Repository
- github.com/Dkm0315/frappe-agent
- First seen
- Oct 24, 2026
- Last checked
- Oct 24, 2026
- Source
- GitHubgithub-graphql
More from Dkm0315
- 0.558score
frappe-bench
Dkm0315
Bench-aware Frappe operations guidance for app installs, branch switching, updates, migrations, site inspection, ports, and process state.
SkillCFreshness: C★ 26Claude Code +9 - 0.558score
frappe-crm
Dkm0315
Frappe CRM guidance for leads, deals, contacts, organizations, pipelines, activities, assignment, dashboards, and sales workflows.
SkillCFreshness: C★ 26Claude Code +9 - 0.558score
frappe-customization
Dkm0315
Frappe customization-surface guidance covering Custom Field, Property Setter, Client Script, Server Script, Workspace, Web Page, Page, Print Format, Report…
SkillCFreshness: C★ 26Claude Code +9 - 0.558score
frappe-drive
Dkm0315
Frappe Drive guidance for files, folders, sharing, permissions, storage, previews, document workflows, and file-linked business processes.
SkillCFreshness: C★ 26Claude Code +9 - 0.558score
frappe-erpnext
Dkm0315
ERPNext-aware reasoning for accounting, selling, buying, stock, manufacturing, projects, HR, support, education, CRM, and other ERPNext module work.
SkillCFreshness: C★ 26Claude Code +9 - 0.558score
frappe-backend
Dkm0315
Frappe backend guidance for Python and backend-adjacent JavaScript surfaces such as client interaction patterns, hooks, APIs, patches, scheduler logic…
SkillCFreshness: C★ 26Claude Code +9
Cite this page
frappe-sql skill. Agent Mart. https://agentmart.dev/skills/dkm0315-frappe-sql (last updated 2026-10-24)