database-designer

Design and optimize SQL and NoSQL database schemas, migrations, and query patterns.

Updated Apr 9, 2026
One-click install
npx skills add https://github.com/Patasse97/claude-skills --skill database-designer-patasse97
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database-designer
Source: https://github.com/Patasse97/claude-skills/tree/main/engineering/database-designer
Command: npx skills add https://github.com/Patasse97/claude-skills --skill database-designer-patasse97

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) and assets (resource) components.

What problem does it solve?

The Database Designer skill provides a structured framework for crafting robust database schemas, planning zero-downtime migrations, and optimizing queries across SQL and NoSQL systems, helping teams avoid costly schema drift and downtime.

Core Features & Use Cases

  • Schema analysis and normalization guidance to enforce data integrity and scalable design.
  • Migration planning and automation to orchestrate safe, reversible changes with rollback paths.
  • Indexing and data modeling recommendations to improve read/write performance across relational and document stores.
  • Use Case: Designing a new product catalog with multi-region deployment or evolving schemas during active development.

Quick Start

Describe your current schema goals and I will generate a design plan and migration steps.

Frequently Asked Questions about database-designer

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

FAQPage Schema
How do I design robust database schemas for both SQL and NoSQL systems?

Designing robust database schemas involves normalizing data to enforce integrity and applying data modeling recommendations to improve read/write performance across SQL and NoSQL systems. This structured framework analyzes your goals to generate scalable designs.

What is the best way to plan zero-downtime database migrations during active development?

Planning zero-downtime database migrations requires orchestrating safe, reversible changes with explicit rollback paths. This approach automates migration steps to prevent costly schema drift and downtime while evolving your active database.

How does database indexing improve read and write performance for document stores?

Database indexing improves read/write performance by strategically structuring data access paths to reduce query latency. This skill provides indexing recommendations tailored for relational tables and document stores to optimize overall throughput.

Can I use this to analyze and normalize an existing data model for a multi-region deployment?

Yes, you can analyze and normalize existing data models to prepare for multi-region deployment. The framework evaluates your current schema to enforce data integrity and generates a design plan suitable for distributed environments.

When do I need to generate safe database changes with rollback paths?

You need to generate safe database changes with rollback paths when evolving schemas during active development or deploying multi-region product catalogs. This prevents costly schema drift and ensures reversible, zero-downtime transitions.