backend-skill: Skill for Claude Code

.claude/skills/proj-gen/SKILL.md

proj-gen is a skill for Claude Code from zhangloveyan/backend-skill. It costs 20 tokens per session (2,291 once invoked), scanned A, original, MIT.

A code-generation guide for creating database table SQL, CRUD code, API endpoints, and enum classes. CRUD means creating, reading, updating, and deleting data.

In plain words
What is it for?
Use it to generate table-creation SQL, complete CRUD code, one API endpoint, an enum class, or code based on a technical design document.
Why use it?
It reduces repeated manual work when building standard database and application code.

Skill for Claude Code

Written for Claude Code: installed under .claude/. Also seen: mentions CLAUDE.md.

This is zhangloveyan/backend-skill's own configuration. It tells Claude Code how to work on backend-skill itself, so it is not a mod to install elsewhere. Copy it as a starting point and replace the rules that are about this project. Everything backend-skill configures →

Reuse

Borrowing it

Nothing to install: this file belongs to zhangloveyan/backend-skill. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.

Copy the file
curl -O https://raw.githubusercontent.com/zhangloveyan/backend-skill/main/.claude/skills/proj-gen/SKILL.md
Clone the repo
git clone --depth 1 https://github.com/zhangloveyan/backend-skill

Made for: Claude Code.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for proj-gen

README.md
[![agentmods](https://agentmods.dev/badge/skills/zhangloveyan/backend-skill/proj-gen/github.svg)](https://agentmods.dev/skills/zhangloveyan/backend-skill/proj-gen)
Your own site
<a href="https://agentmods.dev/skills/zhangloveyan/backend-skill/proj-gen"><img src="https://agentmods.dev/badge/skills/zhangloveyan/backend-skill/proj-gen/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for proj-gen

Your own site · 80×15
<a href="https://agentmods.dev/skills/zhangloveyan/backend-skill/proj-gen"><img src="https://agentmods.dev/badge/skills/zhangloveyan/backend-skill/proj-gen.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 20 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 2,291 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00020 $0.02291
Opus 5.5 $0.00008 $0.00916
Sonnet 5.5 $0.00004 $0.00458
Haiku 4.5 $0.00002 $0.00229

Measured 23d ago against content hash 40964c9ba1b1, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

proj-gen scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 23d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

.claude/skills/proj-gen/SKILL.md · 257 lines

How it starts

The opening of the file, as written. The whole thing — 257 lines — stays where its author put it; the contents beside it link to each section on GitHub.

代码生成

统一入口,根据参数生成不同类型的代码。

使用方式

/proj-gen sql      - 生成建表 SQL
/proj-gen crud     - 生成完整 CRUD 代码
/proj-gen api      - 生成单个接口
/proj-gen enum     - 生成枚举类
/proj-gen          - 自动模式(读取技术方案文档)

前置检查

  • 全流程任务文档已创建并可追溯
  • 技术方案已确认且路径已记录在产物清单
  • 任务清单已拆分并确认
  • 涉及新增或重命名的数据库表、字段时,按 SQL 命名规范 校验目标 MySQL 精确版本的全部关键字(含非保留关键字);范围包括 Entity 最终映射的列名,适用于 SQL、CRUD 和自动模式。新名称冲突修正后再生成,未核实版本或关键字清单时标记待核验,不得声称检查通过。已有冲突名称先记录影响并提出迁移方案,未经确认不得自动改名或改变映射。

未满足前置条件时:先补文档/确认流程,禁止生成代码。


自动模式

当存在技术方案文档时,直接执行 /proj-gen,自动:

  1. 从任务文档的产物清单读取技术方案路径
  2. 提取表结构、实体、接口等信息
  3. 按顺序生成:SQL → Entity → Mapper → DTO → Service → Controller

同步更新任务文档:

  • 流程状态总览标记“代码生成”为进行中/已完成
  • 产物清单记录生成代码清单或路径
  • 更新下一步指令为“业务开发”

触发时机:任务拆分完成后,开始编码前。

注意:自动模式生成的是代码骨架,业务逻辑仍需手动实现。


1. 生成 SQL (/proj-gen sql)

输入参数

参数 必填 说明 示例
表名 是 小写下划线 feedback
表描述 是 中文 建议反馈
业务字段 是 字段列表

字段类型、通用字段与建表模板


2. 生成 CRUD (/proj-gen crud)

输入参数

参数 必填 说明 示例
模块名 是 小写 feedback
实体名 是 大驼峰 Feedback
表名 是 小写下划线 feedback
中文描述 是 建议反馈
端类型 是 Web/App/Both

生成文件清单

core/{module}/
├── entity/{Entity}.java
├── mapper/{Entity}Mapper.java
├── service/{Entity}Service.java
└── service/impl/{Entity}ServiceImpl.java

admin/  (Web端)
├── controller/{Entity}Controller.java
├── service/{Entity}ManageService.java
├── service/impl/{Entity}ManageServiceImpl.java
└── model/
    ├── request/{Entity}CreateRequest.java
    ├── request/{Entity}UpdateRequest.java
    ├── request/{Entity}QueryRequest.java
    └── response/{Entity}Response.java

api/  (App端)
├── controller/{Entity}Controller.java
├── service/{Entity}AppService.java
└── model/...

Read the full file on GitHub · 257 lines

Files

What ships with it

8 files beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 23d ago Changed · +4 lines 40964c9ba1b1
  2. 2mo ago First seen · 253 lines · 20 tokens per session scan A 238ccb6708c4

Subscribe to this mod's changes

proj-gen is a skill published in the GitHub repository zhangloveyan/backend-skill (103 stars, last pushed 23d ago), licensed MIT. It adds 20 tokens to every session and 2,291 once invoked, about $0.0001 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Related

proj-gen compared with skills from other repositories

proj-gen next to 6 skills from other repositories
ModTypeStarsLast pushLicenceScanTokensWorks with
proj-genzhangloveyan/backend-skillSkill10323d agoMITA20Claude Code
event-store-designwshobson/agentsSkill42kyesterdayMITA33Claude Code
platform-custom-field-generateforcedotcom/sf-skillsSkill1.1k2d agoApache-2.0A139Claude Code
field-service-sobject-create-configureforcedotcom/sf-skillsSkill1.1k2d agoApache-2.0A74Claude Code
durable-objectsfcakyon/claude-codex-settingsSkill1.2kyesterdayApache-2.0A22Claude Code
nornicdb-grpcorneryd/NornicDBSkill923yesterdayMITA98Claude Code, Codex
nw-ddd-eventsourcingnWave-ai/nWaveSkill631yesterdayMITA38Claude Code