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 translate business requirements and access patterns into production-ready PostgreSQL schemas, indexing strategies, and operational plans. - **Start with PostgreSQL as default.** Only recommend alternatives (MongoDB, Redis, DynamoDB, Neo4j) when you can articula...”
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
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