db-sculptor

仓库创建 2026年5月12日最近提交 10 小时前SkillHot 收录 20 天前

▸ 精选理由

聚焦访问模式、索引策略与零宕机迁移，适合后端工程师

这个 Skill 做什么

基于 PostgreSQL 与 Prisma/Drizzle 设计高性能数据库模式并优化查询与迁移

基于 PostgreSQL 为业务设计高性能数据库模式，配合 Prisma/Drizzle 写迁移、做索引策略（B-tree、GIN、GiST 等）、用 EXPLAIN ANALYZE 优化慢查询并设计零停机迁移及分区/分片方案。需要做模式设计、优化慢 SQL 或决定索引与迁移策略时用。特点是以访问模式优先、兼顾生产可运行性和迁移安全的实战方案。

▸ 展开 SKILL.md 英文原文

Design database schemas with Prisma/Drizzle, PostgreSQL index strategy (B-tree, GIN, GiST, BRIN, Hash), query optimization (EXPLAIN ANALYZE), migration safety (expand/contract, zero-downtime), and sharding/partitioning. Use when user asks to design schema, create migrations, optimize slow queries, add indexes, choose between SQL/NoSQL, or set up Prisma/Drizzle. Do NOT use for data warehouse dimensional modeling, ETL pipeline design, or non-relational (MongoDB, DynamoDB) schema design.

开发编程数据库设计PostgreSQL迁移通用

110

Stars

Forks

仓库内 Skill

7 日增星

安装 / 使用

给你的 Agent 一句话（通用）

帮我安装这个 skill：https://raw.githubusercontent.com/EliasOulkadi/shokunin/master/.pack/skills/db-sculptor/SKILL.md

或 curl 直取 SKILL.md

curl -fsSL "https://raw.githubusercontent.com/EliasOulkadi/shokunin/master/.pack/skills/db-sculptor/SKILL.md"

SKILL.MD 节选查看完整文件 ↗

# DB Sculptor

Design performant database schemas. Model for access patterns first, normalize later. Based on PostgreSQL internals, Prisma/Drizzle best practices, and production patterns from PlanetScale, Neon, and pganalyze.

## Sub-Commands

| Command | Description |
|---------|-------------|
| `design` | Design a schema from access patterns and data volume estimates |
| `index` | Analyze queries and recommend/create optimal indexes |
| `optimize` | Diagnose slow queries with EXPLAIN ANALYZE and fix them |
| `migrate` | Create a safe, zero-downtime migration (expand/contract) |
| `audit` | Audit existing schema against best practices and anti-patterns |

## Workflow

### Step 1: Model for

via SKILL·HOT · 数据来自 GitHub 公开信息 · 原文版权归作者所有