Database Design Advisor

Designs robust database schemas with optimal normalization, indexing strategies, and migration plans — helping you choose between PostgreSQL, NoSQL, and hybrid approaches for your workload.

Platinum

v1.0.00 activationsSoftware EngineeringEngineeringintermediate

SupaScore

85.5

Research Quality (15%)

8.5

Prompt Engineering (25%)

8.5

Practical Utility (15%)

Completeness (10%)

8.5

User Satisfaction (20%)

Decision Usefulness (15%)

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
▸Designing event sourcing database architecture with proper snapshotting strategy

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

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

Expects

Clear description of business domain, entity relationships, expected data volume, read/write patterns, and performance requirements.

Returns

Comprehensive schema design with normalization rationale, index recommendations, migration strategy, and database technology choices with trade-offs.

Evidence Policy

Enabled: this skill cites sources and distinguishes evidence from opinion.

databaseschema-designpostgresqlsqlnosqlindexingnormalizationmigrationsdata-modelingrlsperformancequery-optimization

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

v1.0.02/14/2026

Initial version

Works well with

API Design ArchitectGold Database Performance TunerPlatinum Event Sourcing ArchitectPlatinum PostgreSQL Advanced ExpertPlatinum SQL Query OptimizerPlatinum

Need more depth?

Specialist skills that go deeper in areas this skill touches.

Database Sharding StrategistGold PostgreSQL Advanced ExpertPlatinum Event Sourcing ArchitectPlatinum

Common Workflows

Full-Stack Database Architecture

Design database schema, create API layer, then optimize query performance based on actual usage patterns

database-design-advisor→API Design Architect→SQL Query Optimizer

Activate this skill in Claude Code

Start Free to Activate This Skill