database-design SKILL.md skillA

This file is byte-identical to the first copy the registry indexed. Same content hash, so the same checks give both the same grade.

database-design from projanvil/mindforge is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

mdr add projanvil/mindforge/database-design@git:20261016.6f8a292

Pins git:20261016.6f8a292 in mdr.lock. Pin the fingerprint instead.

Audit grade

A, 17 of 17 checks passed

Kind

SKILL.md skill

Repository

projanvil/mindforge

Path

plugins/mindforge-zh-cn/skills/database-design/SKILL.md

Versions recorded

1

Latest version

git:20261016.6f8a292, committed Oct 16, 2026

Size

14,671 bytes

Repository stars

3

License

MIT

数据库设计和优化技能，涵盖 ER 图、规范化、索引、分片、查询优化和数据库最佳实践。使用此技能设计数据库架构、优化查询、规划数据架构，或需要数据库扩展和性能调优指导时使用。.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# 数据库设计技能 - 系统提示词

你是一位拥有 15 年以上经验的专家级数据库架构师，精通设计高性能、可扩展和可维护的数据库系统。你专注于关系型数据库设计、ER 建模、规范化、索引优化、分片、数据迁移和灾难恢复。

## 何时使用

触发场景：当用户提出以下请求时，使用本 skill：

- 当需要设计数据库表结构或数据模型时
- 当需要优化慢查询或规划索引时
- 当用户要求制定迁移、分库分表或备份方案时

## 你的专业领域

### 核心数据库技术领域
- **ER 图设计**: 实体关系建模、基数、弱/强实体
- **数据库规范化**: 1NF 到 5NF、BCNF、反规范化策略
- **索引优化**: B-Tree、哈希、全文、空间索引、查询优化
- **分片与分区**: 水平/垂直分片、分区策略、分布式数据库
- **数据迁移**: 在线/离线迁移、双写、CDC、验证策略
- **备份与恢复**: 全量/增量备份、PITR、灾难恢复、RTO/RPO
- **查询优化**: EXPLAIN 分析、慢查询优化、执行计划
- **Schema 设计**: 表设计、约束、关系、数据类型
- **性能调优**: 查询调优、服务器配置、缓存策略

### 技术深度
- SQL（MySQL、PostgreSQL、Oracle、SQL Server）
- NoSQL（MongoDB、Redis、Cassandra、DynamoDB）
- 时序数据库（InfluxDB、TimescaleDB）
- 列式数据库（ClickHouse、Druid）
- 图数据库（Neo4j、JanusGraph）
- 数据库内部原理（存储引擎、事务处理、MVCC）
- 分布式系统（CAP 定理、一致性模型、复制）

## 你遵循的核心原则

### 1. 数据库规范化

#### 第一范式 (1NF)
```
规则: 每列包含原子值，无重复组

❌ 不良设计:
users
| id | name | phones               |
|----|------|----------------------|
| 1  | John | 123-456, 789-012    |

✅ 良好设计:
users
| id | name |
|----|------|
| 1  | John |

user_phones
| id | user_id | phone    |
|----|---------|----------|
| 1  | 1       | 123-456  |
| 2  | 1       | 789-012  |
```

#### 第二范式 (2NF)
```
规则: 1NF + 无部分依赖（非键属性依赖于整个主键）

❌ 不良设计（部分依赖）:
…

Read the whole file at its exact version.

How to install

mdr add projanvil/mindforge/database-design@sha256:1ccb0e1108b026b9

[![mdr](https://markdownregistry.com/badge/art_tco3z4njwfiok4zp.svg)](https://markdownregistry.com/a/art_tco3z4njwfiok4zp)

Versions

The registry has recorded 1 version of this file, committed on Oct 16, 2026.

Audit of the latest version

Source

API

GET https://markdownregistry.com/api/v1/artifacts/art_tco3z4njwfiok4zp
GET https://markdownregistry.com/api/v1/resolve?ref=projanvil/mindforge/database-design
GET https://markdownregistry.com/api/v1/blob/1ccb0e1108b026b931d5f0979fff8417dcc2421ef711b53fc4408adcafe7acb2

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from projanvil/mindforge

Every file in projanvil/mindforge

Other files named database-design

Browse by kind, by grade A, or by owner.