Backend Database Expert

专注于数据库设计、SQL 优化和迁移策略。

16 stars

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

$curl -o ~/.claude/skills/backend-database-expert/SKILL.md --create-dirs "https://raw.githubusercontent.com/diegosouzapw/awesome-omni-skill/main/skills/development/backend-database-expert/SKILL.md"

Manual Installation

  1. Download SKILL.md from GitHub
  2. Place it in .claude/skills/backend-database-expert/SKILL.md inside your project
  3. Restart your AI agent — it will auto-discover the skill

How Backend Database Expert Compares

Feature / AgentBackend Database ExpertStandard Approach
Platform SupportNot specifiedLimited / Varies
Context Awareness High Baseline
Installation ComplexityUnknownN/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

backend-patterns

16
from diegosouzapw/awesome-omni-skill

Backend patterns for ORPC routers, Drizzle schemas, and server-side code. Use when creating API endpoints, database tables, or services.

backend-passport-js

16
from diegosouzapw/awesome-omni-skill

Authentication middleware for Express.js and Node.js applications. Use when building Express APIs that need JWT authentication, OAuth, or custom auth strategies. Provides 500+ authentication strategies. Choose Passport.js over Auth.js for Express backends, pure API servers, or when you need maximum control over auth flow.

backend-nodejs

16
from diegosouzapw/awesome-omni-skill

Node.js/TypeScript backend expert. Handles Express/Fastify API routes, TypeScript strict mode, Prisma ORM, Zod validation, error handling, configuration management. Use when project is Node.js backend (package.json + TypeScript server).

Backend Node.js Expert

16
from diegosouzapw/awesome-omni-skill

专注于 Node.js 后端开发模式与最佳实践。

Backend Migrations

16
from diegosouzapw/awesome-omni-skill

Create and manage database schema migrations with reversible operations, zero-downtime deployments, and safe rollback strategies. Use this skill when writing database migrations for PostgreSQL, MySQL, SQLite, MongoDB, or any database system; when using ORMs like Prisma, Sequelize, TypeORM, ActiveRecord, Django ORM, or similar migration tools; when implementing schema changes (adding tables, columns, indexes, constraints); when performing data migrations or transformations; when creating indexes on large tables with concurrent options to avoid locks; when separating schema changes from data migrations for safer rollbacks; when implementing zero-downtime deployment strategies for high-availability systems; when versioning database schemas and managing migration order; or when working with database change management in production environments.

backend

16
from diegosouzapw/awesome-omni-skill

Skill para diseñar y construir backends y APIs **modulares**, **auditables**, **resilientes** y **multi-tenant**, con seguridad fuerte, modelado correcto (incl. ledger cuando aplique), datos y jobs/colas operables.

backend-guidelines

16
from diegosouzapw/awesome-omni-skill

Comprehensive backend development guide for Node.js/Express/TypeScript microservices. Use when creating routes, controllers, services, repositories, middleware, or working with Express APIs, Prisma database access, Sentry error tracking, Zod validation, unifiedConfig, dependency injection, or async patterns. Covers layered architecture (routes → controllers → services → repositories), BaseController pattern, error handling, performance monitoring, testing strategies, and migration from legacy patterns.

backend-guide

16
from diegosouzapw/awesome-omni-skill

Complete backend development guide covering Node.js, Python, Go, Java, PHP, databases, APIs, authentication, and server architecture. Use when building server applications, APIs, or backend systems.

Backend Expert Pro

16
from diegosouzapw/awesome-omni-skill

A complete back-end specialist skill for designing scalable architectures, robust APIs, and secure server-side systems.

backend-expert-advisor

16
from diegosouzapw/awesome-omni-skill

Backend expert guidance for API/DB/Security/Architecture

backend-development

16
from diegosouzapw/awesome-omni-skill

Build robust backend systems with modern technologies (Node.js, Python, Go, Rust), frameworks (NestJS, FastAPI, Django), databases (PostgreSQL, MongoDB, Redis), APIs (REST, GraphQL, gRPC), authentication (OAuth 2.1, JWT), testing strategies, security best practices (OWASP Top 10), performance optimization, scalability patterns (microservices, caching, sharding), DevOps practices (Docker, Kubernetes, CI/CD), and monitoring. Use when designing APIs, implementing authentication, optimizing database queries, setting up CI/CD pipelines, handling security vulnerabilities, building microservices, or developing production-ready backend systems.

backend-development-tdd-orchestrator

16
from diegosouzapw/awesome-omni-skill

Master TDD orchestrator specializing in red-green-refactor discipline, multi-agent workflow coordination, and comprehensive test-driven development practices. Enforces TDD best practices across teams with AI-assisted testing and modern frameworks. Use PROACTIVELY for TDD implementation and governance. Use when: the task directly matches tdd orchestrator responsibilities within plugin backend-development. Do not use when: a more specific framework or task-focused skill is clearly a better match.