database-schema-design

SKILL.md

Design scalable, normalized database schemas with proper relationships, constraints, and data types. Includes normalization techniques, relationship patterns, and constraint strategies.

❌ Don't skip normalization for convenience ❌ Don't use VARCHAR(MAX) for all text fields ❌ Don't forget to add foreign key constraints ❌ Don't use natural keys as primary keys ❌ Don't store calculated values in base tables

✅ DO use UUIDs or sequences for primary keys ✅ DO normalize data appropriately ✅ DO add CHECK constraints for data validity ✅ DO create indexes on foreign keys ✅ DO use TIMESTAMP for audit trails

Entwerfen Sie Datenbankschemata mit Normalisierung, Beziehungen und Einschränkungen. Verwenden Sie es, wenn Sie neue Datenbankschemata erstellen, Tabellen entwerfen oder Datenmodelle für PostgreSQL und MySQL planen. Quelle: aj-geddes/useful-ai-prompts.

Original anzeigen