database-design SKILL.md skillA
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:20261009.b4230f2Pins git:20261009.b4230f2 in mdr.lock. Pin the fingerprint instead.
- Audit grade
- A, 17 of 17 checks passed
- Kind
- SKILL.md skill
- Repository
- projanvil/mindforge
- Path
skills/zh-cn/database-design/SKILL.md- Versions recorded
- 5
- Latest version
- git:20261009.b4230f2, committed Oct 9, 2026
- First version recorded
- Dec 17, 2025
- 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:1ccb0e1108b026b9The line at the top of this page pins the label git:20261009.b4230f2, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.
[](https://markdownregistry.com/a/art_2gm6hgnfbk7mnpns)
2 badge image fetches in 30 days. What the badge shows.
Versions
The registry has recorded 5 versions of this file, between Dec 17, 2025 and Oct 9, 2026, about one every 74 days.
| version | committed | commit | size | audit | |
|---|---|---|---|---|---|
| git:20261009.b4230f2 latest | 2026-10-09 | b4230f2 | 14,671 B | A | view · diff |
| git:20260305.a2f116c | 2026-03-05 | a2f116c | 14,423 B | A | view · diff |
| git:20260303.0dd7018 | 2026-03-03 | 0dd7018 | 22,124 B | A | view · diff |
| git:20251226.c184618 | 2025-12-26 | c184618 | 22,169 B | A | view · diff |
| git:20251217.373f3b7 | 2025-12-17 | 373f3b7 | 22,037 B | A | view |
Audit of the latest version
- pass: Frontmatter block present
- pass: Frontmatter declares a name
- pass: Frontmatter declares a description
- pass: Size between 200 bytes and 200 KB (14671 bytes)
- pass: No zero-width or bidi control characters
- pass: No instruction hidden inside an HTML comment
- pass: No link to an exfiltration or paste host
- pass: No credential-shaped string
- pass: No instruction to send local credentials anywhere
- pass: No text hidden with inline styles
- pass: No prompt-injection phrasing
- pass: No curl or wget piped into a shell
- pass: No recursive delete of root, home or parent
- pass: No instruction to read or print local credentials
- pass: No base64 blob over 200 characters
- pass: No link to a raw IP address
- pass: No script tag
Source
projanvil/mindforge · 3 stars · license MIT · pushed 2026-10-21 · branch main
API
GET https://markdownregistry.com/api/v1/artifacts/art_2gm6hgnfbk7mnpns 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