Software EngineeringEngineeringPlatinum

Broad database design expertise covering schemas, indexing, queries, migrations, and database selection

Database Design

Your database architect for schema design and query optimization

2 activationsintermediatev5.0

Best for

▸Designing normalized database schemas for specific business domains
▸Choosing indexes for query performance improvement
▸Migrating database schemas safely without downtime
▸Choosing between SQL and NoSQL for specific use cases

What you'll get

▸Normalized schema design with proper foreign keys and constraints
▸Index recommendations based on query patterns with performance impact
▸Query optimization with EXPLAIN ANALYZE walkthrough
▸Migration plan for schema changes with rollback strategy

Expects

A database design question — from schema modeling to indexing to query optimization.

Returns

Schema designs, indexing strategies, query optimization advice, and migration plans with concrete SQL examples.

What's inside

“You are a Database Designer. You design schemas that are correct first, fast second, and maintainable always, across relational, document, and hybrid storage systems. - Start from access patterns, not entity relationships. The queries you need to run dictate the schema, not the other way around. - N...”

Covers

What You Do DifferentlyMethodologyWatch For

Not designed for ↓

×Frontend UI development
×API endpoint design (beyond data layer)
×Machine learning model training
×Server infrastructure management

SupaScore

89.35▼

Research Quality (15%)

9.2

Prompt Engineering (25%)

8.9

Practical Utility (15%)

9.1

Completeness (10%)

8.7

User Satisfaction (20%)

8.8

Decision Usefulness (15%)

8.9

Evidence Policy

Standard: no explicit evidence policy.

databaseSQLPostgreSQLschema designindexingnormalizationquery optimization

Research Foundation: 8 sources (2 books, 2 official docs, 1 public domain, 1 industry frameworks, 1 web, 1 paper)

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.03/25/2026

v5 rewrite: behavior-focused, 90% shorter, no filler

v1.03/11/2026

Works well with

SQL Window Functions ExpertPlatinum Supabase RLS Security ExpertPlatinum Data Pipeline ArchitectPlatinum Graph Database ArchitectPlatinum Database Backup Strategy ArchitectPlatinum

Need more depth?

Specialist skills that go deeper in areas this skill touches.

Reverse ETL ArchitectPlatinum Data Lineage TrackerPlatinum