Best use case
Backend Database Expert is best used when you need a repeatable AI agent workflow instead of a one-off prompt.
专注于数据库设计、SQL 优化和迁移策略。
Teams using Backend Database Expert should expect a more consistent output, faster repeated execution, less prompt rewriting.
When to use this skill
- You want a reusable workflow that can be run more than once with consistent structure.
When not to use this skill
- You only need a quick one-off answer and do not need a reusable workflow.
- You cannot install or maintain the underlying files, dependencies, or repository context.
Installation
Claude Code / Cursor / Codex
Manual Installation
- Download SKILL.md from GitHub
- Place it in
.claude/skills/05-backend-database/SKILL.mdinside your project - Restart your AI agent — it will auto-discover the skill
How Backend Database Expert Compares
| Feature / Agent | Backend Database Expert | Standard Approach |
|---|---|---|
| Platform Support | Not specified | Limited / Varies |
| Context Awareness | High | Baseline |
| Installation Complexity | Unknown | N/A |
Frequently Asked Questions
What does this skill do?
专注于数据库设计、SQL 优化和迁移策略。
Where can I find the source code?
You can find the source code on GitHub using the link provided at the top of the page.
SKILL.md Source
# Backend Database Skills
## 🤖 智能体与 MCP 增强 (Agent & MCP Enhancements)
本 Skill 支持并推荐配合特定的智能体角色和 MCP 工具使用，以获得最佳效果。
### 推荐智能体角色
* **Database Consultant**: 详见 [AGENTS.md](AGENTS.md)。
* 该角色专注于数据库架构设计、性能调优和数据安全。
* 启用后，AI 将优先进行 Schema 内省和执行计划分析。
### 推荐 MCP 工具
* **PostgreSQL/MySQL MCP**: 允许 AI 直接连接数据库，获取实时的 Schema 信息和执行 EXPLAIN 分析，而不仅仅是基于静态代码推断。
* **mcp-feedback-enhanced**: 允许 AI 在设计表结构或优化策略时，如果遇到不确定性，使用 `ask_followup_question` 等工具主动向用户确认业务需求或权衡方案。
---
提供专业的数据库开发与维护能力，帮助你构建高性能、高可靠的数据层。
## 包含的技能模块
### 1. [SQL 优化模式 (SQL Optimization)](./SQL优化模式.md)
- **核心价值**: 解决慢查询，提升数据库性能。
- **关键技术**: EXPLAIN 分析, 索引策略, N+1 问题修复.
- **使用场景**: 数据库性能瓶颈分析、复杂查询优化。
### 2. [数据库迁移 (Database Migration)](./数据库迁移.md)
- **核心价值**: 安全、可控地变更数据库结构。
- **关键技术**: 迁移脚本编写, 向后兼容性, 零停机迁移.
- **使用场景**: 版本迭代、Schema 变更、数据清洗。
## 如何使用
- **性能调优**: "请使用 SQL 优化模式帮我分析这条查询语句为什么这么慢。"
- **结构变更**: "请参考数据库迁移指南，帮我写一个给用户表添加字段的迁移脚本。"Related Skills
adhd-design-expert
Designs digital experiences for ADHD brains using neuroscience research and UX principles. Expert in reducing cognitive load, time blindness solutions, dopamine-driven engagement, and compassionate design patterns. Activate on 'ADHD design', 'cognitive load', 'accessibility', 'neurodivergent UX', 'time blindness', 'dopamine-driven', 'executive function'. NOT for general accessibility (WCAG only), neurotypical UX design, or simple UI styling without ADHD context.
add-database-table
Create database migrations, define table schemas, and manage constant tables (enums). Use when: (1) creating a new database table, (2) running 'make migrate.create', (3) adding enum/status values, (4) modifying table structure. REQUIRED first step before add-domain-entity.
add-backend-tool
Add a new tool to the backend OpenAI function calling system. Use when user mentions "new tool", "add tool", "backend function", "agent capability", or wants to extend what the AI agent can do.
add-backend-testing
Add backend integration testing with Vitest to an existing app. Sets up isolated test database schema and writes tests for tRPC routers.
adapter-expert
Adapter Layer 전문가. CommandAdapter(persist만, JpaRepository 1:1), QueryAdapter(4개 메서드, QueryDslRepository 1:1), AdminQueryAdapter(Join 허용, DTO Projection), LockQueryAdapter(6개 Lock 메서드). 필드 2개만(Repository + Mapper). @Component 필수. @Transactional 절대 금지.
acsets-algebraic-databases
ACSets (Attributed C-Sets): Algebraic databases as in-memory data structures. Category-theoretic formalism for relational databases generalizing graphs and data frames.
plaid-accounts-expert
Expert on Plaid accounts and account management. Covers account data retrieval, balance checking, account types, multi-account handling, and account webhooks. Invoke when user mentions Plaid accounts, account balance, account types, or account management.
accountant-expert
Expert-level accounting, tax, financial reporting, and accounting systems
Build Your Database Skill
Create a relational-db-agent skill that knows SQLModel async patterns
33GOD System Expert
Deep knowledge expert for the 33GOD agentic pipeline system, understands component relationships and suggests feature implementations based on actual codebase state
2000s-visualization-expert
Expert in 2000s-era music visualization (Milkdrop, AVS, Geiss) and modern WebGL implementations. Specializes in Butterchurn integration, Web Audio API AnalyserNode FFT data, GLSL shaders for audio-reactive visuals, and psychedelic generative art. Activate on "Milkdrop", "music visualization", "WebGL visualizer", "Butterchurn", "audio reactive", "FFT visualization", "spectrum analyzer". NOT for simple bar charts/waveforms (use basic canvas), video editing, or non-audio visuals.
Operations & Growth Expert
专注于内容创作（文案、运营稿件）、运营数据分析、以及营销活动策划与设置。帮助项目实现从“可用”到“好用”及“增长”的闭环。