skills.rest
thejordanleopold
thejordanleopoldCOMMUNITY
Explore all skills by this author →
Website𝕏@jordansleopoldGitHub

database-design

Designs normalized relational database schemas, migrations, indexing, and security patterns.

4|Updated Apr 9, 2026
Search Tags:#security#indexing#migrations#schema#normalization#database-design
One-click install
npx skills add https://github.com/thejordanleopold/claude-code-skills-distilled --skill database-design-thejordanleopold
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/thejordanleopold/claude-code-skills-distilled/tree/main/database-design
Command: npx skills add https://github.com/thejordanleopold/claude-code-skills-distilled --skill database-design-thejordanleopold

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Designing robust relational database schemas and migrations to ensure data integrity, performance, and maintainability.

Core Features & Use Cases

  • Schema normalization guidance and relationship design for scalable systems.
  • Migration planning for zero-downtime deployments, multi-tenancy, auditing, and security features like RLS.
  • Guidance on indexing strategies, data integrity constraints, and type generation from schemas.

Quick Start

Draft a normalized schema outline for your feature, including tables, keys, relationships, and migration steps.

Frequently Asked Questions about database-design

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a relational database schema that supports multi-tenancy and row-level security?▼

Designing a relational database schema for multi-tenancy involves structuring tables with tenant isolation and applying row-level security (RLS) policies. This ensures data separation by enforcing tenant-specific access controls directly at the database level.

What is the best way to plan zero-downtime migrations for large production tables?▼

Planning zero-downtime migrations for large tables requires expanding schemas incrementally and backfilling data without locking writes. This approach avoids downtime by decoupling schema changes from application deployments.

How does schema normalization to 3NF improve database design?▼

Schema normalization to 3NF improves database design by eliminating redundant data and ensuring relational dependencies are logically separated. This process minimizes anomalies during updates and maintains data integrity across relational tables.

How do I implement soft-delete and auditing trails in a relational schema?▼

Implementing soft-delete and auditing trails in a relational schema requires adding specific timestamp columns and separate history tables. This mechanism tracks record modifications and preserves deleted entries for compliance without losing historical data.

What indexing strategies should I apply for scalable relational database design?▼

Indexing strategies for scalable relational database design involve applying targeted indexes on foreign keys and frequently queried columns. This optimizes read performance and maintains efficiency as relational data volume grows.

Related Skills

Explore More Software Engineering Skills→
AgentientAgentient
2

er-diagram-and-data-modeling

Identify and visualize entity-relationship structures from domain data.

Official
Basic
jtucker9jtucker9

migration-planner

Generate ordered migration scripts and rollback plans from schema diffs.

Community
Advanced
constructive-ioconstructive-io

drizzle-orm

Design PostgreSQL schemas and build type-safe Drizzle ORM queries in TypeScript.

Official
Intermediate
chef0111chef0111
1

databases

Manage MongoDB and PostgreSQL databases with schema design, CRUD, indexing, and migrations.

Community
Advanced