Agent skill · data analytics · aj-geddes
database-schema-design
Design database schemas with normalization, relationships, and constraints. Use when creating new database schemas, designing tables, or planning data models for PostgreSQL and MySQL.
Why this skill is useful
Provides specific normalization techniques and relationship patterns for PostgreSQL and MySQL that the AI wouldn't reliably generate on its own.
What it needs
About 1k tokens when loaded. Last updated 2026-03-04. 307 stars on the source repository.
What this skill does
Database Schema Design Table of Contents Overview When to Use Quick Start Reference Guides Best Practices Overview Design scalable, normalized database schemas with proper relationships, constraints, and data types. Includes normalization techniques, relationship patterns, and constraint strategies. When to Use New database schema design Data model planning Table structure definition Relationship design (1:1, 1:N, N:N) Normalization analysis Constraint and trigger planning Performance optimization at schema level Quick Start PostgreSQL - Eliminate Repeating Groups: Reference Guides Detailed implementations in the references/ directory: Guide Contents --- --- First Normal Form (1NF) First Normal Form (1NF) Second Normal Form (2NF) Second Normal Form (2NF) Third Normal Form (3NF) Third Normal Form (3NF) Entity-Relationship Patterns Entity-Relationship Patterns Best Practices ✅ DO Follow established patterns and conventions Write clean, maintainable code Add appropriate documentation Test thoroughly before deploying ❌ DON'T Skip testing or validation Ignore error handling Hard-code configuration values
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aj-geddes/database-schema-design