db-schema-design

仓库创建 2026年7月27日最近提交 1 天前SkillHot 收录 1 天前

▸ 精选理由

包含审计查询与可引用规则，适合迁移与性能诊断场景。

这个 Skill 做什么

为 Postgres/MySQL 提供模式设计、索引与查询优化建议。

帮你把 Postgres/MySQL 的表、索引和 SQL 调优讲清楚，能从写迁移、选列类型到看 EXPLAIN 报告都给出建议。遇到慢查询、N+1 问题或需要设计复合索引时会用到，能把性能问题定位并提出可执行的改进。以 Postgres 为默认方言，会明确标出 MySQL 的差异，并用编号规则方便引用和审计。

▸ 展开 SKILL.md 英文原文

Designs database schemas and tunes SQL indexing and query performance. Use when writing migrations or CREATE TABLE statements, choosing column types or primary keys, diagnosing slow queries or EXPLAIN plans, designing composite indexes, fixing N+1 problems, or reviewing any Postgres/MySQL schema.

开发编程数据库设计索引优化性能调优通用

Stars

Forks

仓库内 Skill

积累中

7 日增星

安装 / 使用

给你的 Agent 一句话（通用）

帮我安装这个 skill：https://raw.githubusercontent.com/Ludenox-GIT/portable-agent-skills/main/skills/db-schema-design/SKILL.md

或 curl 直取 SKILL.md

curl -fsSL "https://raw.githubusercontent.com/Ludenox-GIT/portable-agent-skills/main/skills/db-schema-design/SKILL.md"

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

# Database Schema Design & Query Performance

Numbered rules are citable: report violations as "violates rule #12". Postgres is the default dialect; MySQL differences are called out inline. For full rationale, exceptions, the complete PostgreSQL-wiki "Don't Do This" list, and catalog audit queries, read references/RULES.md (load when auditing an existing schema, when a rule is challenged, or when you need the SQL to find violations). For migration execution, copy assets/migration-checklist.md into the PR.

## When to use

- Writing or reviewing `CREATE TABLE` / `ALTER TABLE` / migration files.
- Choosing column types, primary keys, or constraints.
- Diagnosing slow queries, reading EXPLAIN o

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