skills.rest
tapanshah
tapanshahCOMMUNITY
Explore all skills by this author →
GitHub

Database Designer

Analyze SQL and NoSQL schemas, recommend indexes, and generate migration scripts.

Updated Mar 7, 2026
Search Tags:#indexing#database#optimization#schema#migration#normalization
One-click install
npx skills add https://github.com/tapanshah/Claude-Skills --skill database-designer-tapanshah
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Database Designer
Source: https://github.com/tapanshah/Claude-Skills/tree/main/engineering/database-designer
Command: npx skills add https://github.com/tapanshah/Claude-Skills --skill database-designer-tapanshah

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates complex database design tasks, including schema analysis, index optimization, and safe migration generation, ensuring robust and performant database systems.

Core Features & Use Cases

  • Schema Analysis: Detects normalization violations, missing constraints, and data type antipatterns.
  • Index Optimization: Recommends optimal indexes based on query patterns and identifies redundant indexes.
  • Migration Generation: Creates safe SQL migration scripts with rollback plans, supporting zero-downtime strategies.
  • Use Case: A development team needs to refactor a legacy database schema. This Skill can analyze the existing schema, identify normalization issues, suggest improvements, and generate the SQL to safely migrate to a new, optimized structure without downtime.

Quick Start

Use the database designer skill to analyze the provided SQL schema file 'schema.sql'.

Frequently Asked Questions about Database Designer

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

FAQPage Schema
How do I analyze a database schema for normalization violations and missing constraints?▼

To analyze a database schema for normalization violations, provide your DDL files or JSON schema definitions. The analysis detects missing constraints, data type antipatterns, and structural flaws to ensure a robust design.

What is the best way to generate safe SQL migration scripts for a legacy database refactor?▼

The best way to generate safe SQL migration scripts is to analyze the existing schema and produce automated migration scripts. These include rollback plans and support zero-downtime strategies for secure structural transitions.

How do I optimize database indexes based on specific query patterns?▼

To optimize database indexes based on query patterns, analyze your workload to identify redundant indexes. The system recommends optimal indexes automatically, improving query performance and reducing storage overhead.

Can I use this database optimization process with both SQL and NoSQL schema definitions?▼

Yes, database optimization and schema analysis support both SQL and NoSQL databases. You can process standard DDL files for relational databases alongside JSON schema definitions for NoSQL structures.

When do I need automated index recommendations for database performance?▼

You need automated index recommendations when query performance degrades or after refactoring a legacy schema. Identifying redundant indexes and suggesting optimal structures resolves bottlenecks without manual query profiling.

Why does schema normalization analysis matter before a database migration?▼

Schema normalization analysis matters before a migration because it identifies data type antipatterns and missing constraints early. Resolving these violations ensures the new database structure is optimized and robust before generating migration scripts.

Related Skills

Explore More Software Engineering Skills→
Fantasia1999Fantasia1999

database-designer

Analyzes SQL DDL schemas and generates zero-downtime migration scripts.

Community
Advanced
cwinvestmentscwinvestments
412

migration-planner

Generate database schema migration scripts with rollback strategies.

Community
Advanced
thehivegroup-aithehivegroup-ai

postgres-standards

Manage PostgreSQL schema design, migrations, and query optimization with psycopg2.

Official
Intermediate
Veloxia-agencyVeloxia-agency

database-designer

Design and optimize database schemas, indexes, and migrations.

Community
Advanced