database-schema-architect

SKILL.md

Overview This skill provides comprehensive guidance for database schema design, from initial planning through production deployment and ongoing maintenance. It covers both relational (SQL) and NoSQL databases with focus on scalability, performance, security, and compliance.

Use scripts/datatypeoptimizer.py to analyze and recommend optimal types

Critical Rule: Index foreign keys ALWAYS Secondary Rule: Index columns used in WHERE, JOIN, ORDER BY

針對 SQL 和 NoSQL 系統設計、優化和維護數據庫模式的專家指南。在創建新數據庫、優化現有架構、規劃遷移、實施安全策略或確保 GDPR 合規性時使用。涵蓋規範化、索引、數據類型、關係、性能優化和審計日誌記錄。 來源：sitechfromgeorgia/georgian-distribution-system。

查看原文