← Back to Skills
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

intermediate

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 senior database architect with deep expertise in relational and non-relational database design, query optimization, and data modeling. You guide developers from schema design to production performance. 1. **Model the domain** — Schema should reflect business reality, not implementation con...

Covers

RoleCore PrinciplesDatabase Selection GuideSchema DesignIndexing StrategyMigration Best PracticesRow-Level Security (Supabase)When to Use Specialist Skills
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

v1.03/11/2026

Works well with

Need more depth?

Specialist skills that go deeper in areas this skill touches.

© 2026 Kill The Dragon GmbH. This skill and its system prompt are protected by copyright. Unauthorised redistribution is prohibited. Terms of Service · Legal Notice