skills.rest
xleliberty
xlelibertyCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-designer

Analyze SQL schemas for normalization violations and generate index optimization reports.

Updated Nov 3, 2016
Search Tags:#database#optimization#schema#migration#sql#normalization
One-click install
npx skills add https://github.com/xleliberty/mydotfiles --skill database-designer-xleliberty
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-designer
Source: https://github.com/xleliberty/mydotfiles/tree/main/.config/.claude/plugins/cache/claude-code-skills/engineering-advanced-skills/2.1.2/database-designer
Command: npx skills add https://github.com/xleliberty/mydotfiles --skill database-designer-xleliberty

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses the complexity of designing scalable database schemas, planning zero-downtime migrations, and optimizing query performance, preventing common architectural pitfalls and performance bottlenecks.

Core Features & Use Cases

  • Schema Analysis: Automatically detects normalization violations (1NF-BCNF) and suggests improvements.
  • Index Optimization: Identifies missing indexes and redundant structures based on query patterns.
  • Migration Planning: Generates safe, zero-downtime migration scripts using expand-contract patterns.
  • Use Case: Use this tool to analyze a legacy SQL schema for normalization issues and generate a prioritized list of indexes to improve query performance for your most frequent application queries.

Quick Start

Use the database-designer skill to analyze the schema in assets/sample_schema.sql and generate a performance report.

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 SQL schema for normalization violations?▼

To analyze a SQL schema for normalization violations, the tool automatically detects violations across 1NF through BCNF and suggests targeted schema improvements to ensure data integrity.

What's the best way to plan zero-downtime database migrations?▼

The best way to plan zero-downtime database migrations is by generating safe scripts using expand-contract patterns, preventing architectural pitfalls and ensuring safe data migration orchestration without service interruption.

How do I identify missing indexes for slow SQL query performance?▼

To identify missing indexes for slow SQL query performance, the tool analyzes your query patterns to pinpoint missing indexes and redundant structures, generating a prioritized performance optimization report.

Can I generate an ERD from an existing database schema?▼

Yes, you can generate an ERD from an existing database schema. The tool provides expert-level schema analysis and ERD generation to help visualize and validate structural relationships within your SQL systems.

Does this tool work with legacy SQL systems for schema optimization?▼

Yes, this tool works with legacy SQL systems for schema optimization by analyzing existing schemas, detecting normalization issues, and generating a prioritized list of indexes to improve query performance.

Related Skills

Explore More Software Engineering Skills→
hjemmesidekongenhjemmesidekongen
1

prisma-patterns

Optimize Prisma schema design, migrations, queries, and transactions.

Community
Advanced
stephanjstephanj
9

database-schema-designer

Design normalized SQL and NoSQL schemas with indexing and migration scripts.

Community
Advanced
0xBigBoss0xBigBoss
53

atlas-best-practices

Enforce Atlas best practices for declarative and versioned database migrations.

Community
Advanced
lance-doniflance-donif

data-model-creation

Generate Mermaid class diagrams for visual data relationship modeling.

Community
Advanced