Design a database schema for your software project.
Database Design Advisor
PostgreSQL, NoSQL, Hybrid Databases
Best for
- ▸Designing normalized schema for multi-tenant SaaS application with complex entity relationships
- ▸Choosing between PostgreSQL JSONB and separate tables for variable product attributes in e-commerce
- ▸Planning zero-downtime migration from MongoDB to PostgreSQL for user-generated content platform
- ▸Optimizing query performance with composite indexes for time-series analytics workload
What you'll get
- ▸Detailed schema with entity relationship diagrams, normalization explanation, and specific PostgreSQL data types with constraints
- ▸Index strategy document specifying B-tree, GIN, and partial indexes with query pattern justifications
- ▸Migration plan with rollback strategy, data validation steps, and performance impact assessment
Clear description of business domain, entity relationships, expected data volume, read/write patterns, and performance requirements.
Comprehensive schema design with normalization rationale, index recommendations, migration strategy, and database technology choices with trade-offs.
What's inside
“You are a Database Design Advisor. You design robust database schemas with optimal normalization, indexing strategies, and migration plans, helping teams choose between PostgreSQL, NoSQL, and hybrid approaches based on specific workload characteristics. - **PostgreSQL-first by default, alternatives ...”
Covers
Not designed for ↓
- ×Writing actual SQL queries or stored procedures (implementation details)
- ×Database administration tasks like backup scheduling or user management
- ×Data visualization or business intelligence dashboard design
- ×ETL pipeline implementation or data transformation logic
SupaScore
89.28▼
Evidence Policy
Standard: no explicit evidence policy.
Research Foundation: 6 sources (2 official docs, 1 expert knowledge, 2 academic, 1 community practice)
This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.
Version History
v6.0 wave-1 repair: re-distilled from masterfile/v2 (truncation incident 2026-06, delta-first rules)
v5.5 distilled from v2 via Claude Sonnet
Pipeline v4: rebuilt with 3 helper skills
Initial version
Works well with
Need more depth?
Specialist skills that go deeper in areas this skill touches.
Common Workflows
Full-Stack Database Architecture
Design database schema, create API layer, then optimize query performance based on actual usage patterns
© 2026 Kill The Dragon GmbH. This skill and its system prompt are protected by copyright. Unauthorised redistribution is prohibited. Terms of Service · Legal Notice