Database Design
Design schemas, write migrations, and optimize queries for PostgreSQL, MySQL, MongoDB, and DynamoDB.
How it works
Generates schemas with proper normalization, indexing strategies based on query patterns, migration scripts, and optimized queries. Understands PostgreSQL, MySQL, MongoDB, and DynamoDB. Generates foreign keys, constraints, partial/covering indexes, and explains query plans.
Example prompts
“Design a schema for a multi-tenant SaaS with row-level security”
“Optimize my slow PostgreSQL query scanning 10M rows”
“Create a migration to add soft deletes without downtime”
Real-world example
A SaaS with slow dashboard loads got a covering index that eliminated 3 table lookups, a materialized view for frequent joins, and zero-downtime migration — reducing p95 from 3.2s to 180ms.
Try the Database Design skill
Available on all plans. 71 skills total. Start free.
Get Started Free