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。

查看原文