agentleFS
Sign inStart free
AsiaOstrichAsiaOstrich/EngramGraph/.agents/skills/database-assistant/SKILL.md

database

Skill4 starsChanged 28 days agoMITView on GitHub

Guide database design, migration, and query optimization. Use when: schema design, migration planning, query optimization, index strategy. Not for: application code migration or framework upgrades — use /migrate; the API contract over the data — use /api-design. Keywords: database, schema, migration, SQL, index, query.

31 other projects use a version of this.

Adopted by

Most recently taken up by

Used with

Projects with it also use monitoring, performance and 5 more.

Other files people use alongside this one.

Files found in the same public projects as a version of this one, more often than they turn up anywhere else. Each project counts once, large collections count for less, and this file's own repository is left out.
  • rogue-dev-studioSkill

    monitoring

    Claude monitoring and usage tracking tools (UV, claude-monitor, claude-usage-cli). Use when the project needs this capability or the user / team manifest asks for it. Use for specialized `monitoring` work when listed in TEAM.yaml or explicitly requested.

    Also in 3 projects that use this

  • klauswgSkill

    performance

    Optimize web performance for faster loading and better user experience. Use when asked to "speed up my site", "optimize performance", "reduce load time", "fix slow loading", "improve page speed", or "performance audit".

    Also in 6 projects that use this

  • mrgoonieSkill

    devops

    Deploy to Cloudflare (Workers, R2, D1), Docker, GCP (Cloud Run, GKE), Kubernetes (kubectl, Helm). Use for serverless, containers, CI/CD, GitOps, security audit.

    Also in 4 projects that use this

  • GitHubSkill

    state-management

    CoreAI Sandbox's TanStack Query + mock-JSON data layer. USE WHEN: editing data-fetching hooks (`app/hooks/use*.ts`), adding mock data in `app/data/`, or wiring a component to query state.

    Also in 3 projects that use this

  • MicrosoftSkill

    deployment

    Also in 3 projects that use this

  • NVIDIASkill

    testing

    Run Python and Rust tests for physicsnemo-curator using uv + pytest with coverage reporting via pytest-cov, and cargo-nextest for Rust tests. Includes benchmark workflows with pytest-benchmark and criterion.

    Also in 9 projects that use this

The file

We split this skill into the rules it gives an agent

4 rules. 0 are common, 3 are distinctive, and 1 is very specific to this project.

  • 0

    Common

    Most of the 22 edited versions we read keep these.

  • 3

    Distinctive

    This author's own choices. Worth a look.

  • 1

    Very specific

    Tied to their project's names, files or tools. Probably skip.

  • Common
  • Distinctive
  • Very specific
  1. Distinctive:

    Write forward and rollback scripts.

    line 60
  2. Distinctive:

    Run on staging with production-like data.

    line 65
  3. Distinctive:

    Check row counts, constraint validity, application functionality.

    line 75
  4. Very specific:

    After /database completes, the AI assistant should suggest:

    line 99

“Common” is measured: kept by at least 6 in 10 of the 22 edited versions of this file we could read. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.

Keep what fits and drop the rest. Your version, ready for your agents.
Files
SKILL.md

Database Assistant | 資料庫助手

Guide database design, migration planning, and query optimization.

引導資料庫設計、遷移規劃和查詢最佳化。

Core Principles | 核心原則

PrincipleDescription說明
NormalizationEliminate redundancy (3NF minimum)消除冗餘（至少 3NF）
Referential IntegrityEnforce FK constraints強制外鍵約束
Index StrategyIndex query patterns, not all columns依查詢模式建立索引
Migration SafetyAlways reversible, zero-downtime可逆、零停機
Data ProtectionEncrypt sensitive fields, audit access加密敏感欄位、稽核存取

Schema Design Checklist | Schema 設計檢查清單

  • Primary keys defined (prefer UUID or BIGINT) | 主鍵已定義
  • Foreign keys with proper ON DELETE/UPDATE | 外鍵含適當的級聯策略
  • NOT NULL constraints on required fields | 必填欄位加 NOT NULL
  • Indexes on frequently queried columns | 常查詢欄位建立索引
  • Created/Updated timestamps on all tables | 所有表加建立/更新時間戳
  • Sensitive data encrypted at rest | 敏感資料靜態加密
  • Naming conventions consistent (snake_case) | 命名慣例一致（snake_case）

Normalization Quick Reference | 正規化快速參考

Normal FormRule規則
1NFAtomic values, no repeating groups原子值、無重複群組
2NF1NF + no partial dependencies1NF + 無部分相依
3NF2NF + no transitive dependencies2NF + 無遞移相依
DenormalizeOnly for proven read performance needs僅針對已證實的讀取效能需求

Migration Workflow | 遷移工作流程

PLAN ──► WRITE ──► TEST ──► DEPLOY ──► VERIFY

1. Plan — Assess Impact | 評估影響

Identify affected tables, estimate data volume, plan rollback strategy.

識別受影響的表、估算資料量、規劃回滾策略。

2. Write — Create Migration | 撰寫遷移

Write forward and rollback scripts. Use incremental, numbered migrations.

撰寫正向和回滾腳本。使用遞增編號的遷移。

3. Test — Validate Migration | 驗證遷移

Run on staging with production-like data. Verify data integrity post-migration.

在 staging 環境使用類生產資料執行。驗證遷移後資料完整性。

4. Deploy — Execute Migration | 執行遷移

Apply during maintenance window or use online schema change tools.

在維護窗口執行，或使用線上 Schema 變更工具。

5. Verify — Confirm Success | 確認成功

Check row counts, constraint validity, application functionality.

檢查列數、約束有效性、應用程式功能。

Index Strategy | 索引策略

TypeUse Case使用場景
B-treeEquality, range queries (default)等值、範圍查詢（預設）
HashExact match only僅精確匹配
GINFull-text search, JSONB全文搜尋、JSONB
PartialFiltered subsets過濾子集
CompositeMulti-column queries多欄位查詢

Usage | 使用方式

/database                - Interactive database design guide | 互動式資料庫設計引導
/database schema         - Review schema design | 審查 Schema 設計
/database --migration    - Migration planning assistant | 遷移規劃助手

Next Steps Guidance | 下一步引導

After /database completes, the AI assistant should suggest:

資料庫設計完成。建議下一步 / Database design complete. Suggested next steps:

  • 執行 /security 檢查資料保護措施 — Check data protection measures
  • 執行 /testing 規劃資料庫測試策略 ⭐ Recommended / 推薦 — Plan database testing strategy
  • 執行 /checkin 確認遷移符合提交規範 — Verify migrations meet check-in standards
  • 產生 API 端點 → 執行 /api-design — Generate API endpoints → Run /api-design

Reference | 參考

  • Core standard: database-standards.md

Version History | 版本歷史

VersionDateChanges變更說明
1.0.02026-03-23Initial release初始版本

License | 授權

CC BY 4.0 — Documentation content

Download now (ZIP)

Does it work?

Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.

No reviews yet

People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.

  • It worked
  • Partly
  • It didn't
What did you use it for? e.g. Reviewing pull requests in a Rails app

Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.

Your trail

Files you open will collect here, so you can find them again.

Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.

Now do this for your own.

Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.

Check your setup, free