Menu
后端开发工程师 Agent — 覆盖 API 开发、数据库设计、系统架构、性能优化、安全防护、CI/CD、部署运维等全栈后端工作流
The review-first prompt is selected by default. You can switch to a direct command or download a local copy.
Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
A direct command skips the review prompt. Inspect the source before running it.
npx skills add https://github.com/aiskillstore/marketplace --skill backend-developerThe command stays on one line. Scroll horizontally to inspect it before copying.
Prefer a local copy? Download the files currently available to SkillsMP.
Showing SKILL.md
Maintain a portable task-state ledger for long, multi-step work. Use when a task spans many files, produces large logs, needs a reliable handoff, or requires traceable evidence without repeatedly loading full outputs. Creates concise state records and private evidence references with explicit limits, redaction checks, and retention guidance.
【收纳储物必看】装修前不会规划收纳，入住半年家变仓库？这个 Skill 内置装修课堂会员版「家居收纳储物方法」152篇原创知识库，专门讲收纳储物——收纳是家的骨架、柜子不是越多越好、收纳本质是把东西藏起来、收纳加勤快缺一不可。问玄关鞋柜怎么装、问厨房9个收纳位置、问衣柜衣帽间怎么做、问小户型怎么榨干每1平米、问收纳避坑和鸡肋神器，全部覆盖。适合正在装修、准备收纳规划、家里东西多总是乱、想做满墙柜/通顶柜/800库的业主。
【儿童房装修必看】家里有小孩、正准备要孩子、或想给儿童房做环保安全装修？这个 Skill 内置装修课堂知识库，专门讲"适童化"——儿童是最易受甲醛伤害的人群，儿童房必须实木/ENF/控总量。问儿童房怎么装环保、问儿童房墙面地面用什么、问儿童家具选实木还是人造板、问孩子学习/游戏专区怎么规划、问有娃家庭怎么防磕碰防污染，全部覆盖。适合家里有娃、备孕婚房、想装出健康儿童房的业主。
Based on SOC occupation classification
| name | backend-developer |
| description | 后端开发工程师 Agent — 覆盖 API 开发、数据库设计、系统架构、性能优化、安全防护、CI/CD、部署运维等全栈后端工作流 |
| category | software-engineering |
当用户提出以下需求时，加载本技能：
需求澄清 → 技术选型 → 数据库设计 → API 设计 → 实现 → 测试 → 部署
arch-adr 技能）路由设计 → 请求校验 → 业务逻辑 → 数据持久化 → 响应格式化 → 错误处理 → 测试
{code, message, data, trace_id}idx_表名_字段名npm audit / snyk / trivy）# 数据库
EXPLAIN ANALYZE SELECT ...;
SHOW INDEX FROM table_name;
# Docker
docker compose up -d
docker compose logs -f service_name
docker exec -it container_name sh
# K8s
kubectl get pods -n namespace
kubectl logs -f pod_name -n namespace
kubectl exec -it pod_name -- sh
kubectl port-forward svc/service_name 8080:80
# 性能
curl -o /dev/null -s -w 'Total: %{time_total}s\n' http://localhost:8080/api
ab -n 1000 -c 10 http://localhost:8080/api
pprof http://localhost:6060/debug/pprof/
# Git
git commit --amend # 修改上次提交
git rebase -i HEAD~3 # 交互式 rebase
git stash # 暂存工作区
| 问题类型 | 排查步骤 |
|---|---|
| 接口慢 | 看日志耗时 → 加 trace_id 追踪 → 查数据库慢查询 → 查外部调用耗时 |
| 内存泄漏 | top 看 RES → heap dump / pprof → 分析对象引用 |
| 连接池耗尽 | 检查最大连接数 → 看是否有未释放连接 → 检查慢查询阻塞 |
| 接口超时 | 看上游调用超时设置 → 看数据库连接池 → 看是否有死锁 |
| 数据不一致 | 检查事务边界 → 看是否有并发写 → 检查幂等性设计 |
# FastAPI 项目结构
project/
├── app/
│ ├── api/ # 路由层
│ ├── core/ # 配置、中间件、依赖
│ ├── models/ # 数据模型
│ ├── schemas/ # 请求/响应 schema
│ ├── services/ # 业务逻辑
│ ├── repositories/ # 数据访问层
│ └── utils/ # 工具函数
├── tests/
├── migrations/
├── Dockerfile
├── docker-compose.yml
└── README.md
统一错误响应
# FastAPI 示例
class APIResponse(BaseModel):
code: int = 0
message: str = "success"
data: Any = None
trace_id: str = ""
@app.exception_handler(Exception)
async def global_exception_handler(request: Request, exc: Exception):
return JSONResponse(
status_code=500,
content=APIResponse(code=500, message=str(exc), trace_id=request.state.trace_id).model_dump()
)
分页查询（cursor-based）
# 优于 offset 分页，避免深度翻页性能问题
class CursorPage(BaseModel):
cursor: Optional[str] = None # base64(last_id)
limit: int = 20
async def list_items(cursor: Optional[str], limit: int):
query = select(Item).order_by(Item.id).limit(limit + 1)
if cursor:
last_id = decode_cursor(cursor)
query = query.where(Item.id > last_id)
items = await db.fetch_all(query)
has_more = len(items) > limit
next_cursor = encode_cursor(items[-2].id) if has_more else None
return {"items": items[:limit], "next_cursor": next_cursor}
评估一个技术方案时，按以下维度打分（1-5）：
/health、/ready）arch-adr — 架构决策记录arch-c4-diagram — C4 架构图生成arch-tech-evaluation — 技术选型评估arch-codebase-analysis — 代码库架构分析ops-engineer — 运维工程师 Agent（部署、容器、CI/CD、监控等运维操作）chinese-pdf-generation — 将技能内容/报告输出为 PDF 文档