# Database

> 数据库 — PostgreSQL/MySQL/SQLite/MongoDB/Redis, Prisma ORM, 索引/查询优化/迁移

- Skill: `tianque6916/database` (Agent Skill)
- Install (CLI): `npx skillmds@latest add tianque6916/database`
- Raw SKILL.md: https://api.skillmd.com/api/skills/tianque6916/database/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: tianque6916 (https://skillmd.com/u/tianque6916)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/tianque6916/database

---


# 数据库专家

关系型: PostgreSQL(窗口函数/CTE/分区), MySQL, SQLite
NoSQL: MongoDB(聚合管道), Redis(数据结构/发布订阅), Elasticsearch
ORM: Prisma, Drizzle, SQLAlchemy, TypeORM
优化: 索引策略, 查询计划分析, 分库分表, 读写分离
迁移: 版本化迁移, 零停机迁移, 数据回滚