skills.rest
imMamdouhaboammar
imMamdouhaboammarCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-schema-designer

Design SQL and NoSQL database schemas with normalization and indexing plans.

Updated Jul 24, 2026
Search Tags:#indexing#database#schema#migration#sql#normalization#nosql
One-click install
npx skills add https://github.com/imMamdouhaboammar/kaku-chatgpt-harness --skill database-schema-designer-immamdouhaboammar
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-schema-designer
Source: https://github.com/imMamdouhaboammar/kaku-chatgpt-harness/tree/main/.agents/skills/database-schema-designer
Command: npx skills add https://github.com/imMamdouhaboammar/kaku-chatgpt-harness --skill database-schema-designer-immamdouhaboammar

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill solves the complexity of designing scalable, performant, and maintainable database schemas by automating best practices for normalization, indexing, and migration planning.

Core Features & Use Cases

  • Schema Generation: Automatically creates DDL statements for SQL and document structures for NoSQL based on domain requirements.
  • Performance Optimization: Provides expert-level indexing strategies and normalization guidance to ensure query efficiency.
  • Migration Management: Generates reversible, zero-downtime migration scripts to safely evolve your database as your application grows.

Quick Start

Use the database schema designer to create a schema for an e-commerce platform with users, products, and orders.

Frequently Asked Questions about database-schema-designer

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

FAQPage Schema
How do I design a scalable database schema for both SQL and NoSQL environments?▼

Designing a scalable database schema involves applying normalization rules and indexing strategies to generate entity-relationship models for SQL and document structures for NoSQL environments.

What is the best way to generate reversible migration scripts for production databases?▼

Generating reversible migration scripts requires applying industry-standard schema evolution patterns to produce zero-downtime scripts that safely update production databases.

How do I optimize database indexing strategies for query performance?▼

Optimizing database indexing strategies involves applying expert-level indexing plans and normalization guidance during schema design to ensure query efficiency and performance.

Can I use this database schema designer for an e-commerce platform with users, products, and orders?▼

Yes, you can design schemas for e-commerce platforms with users, products, and orders by providing domain requirements to automatically generate DDL statements and document structures.

How do I ensure data integrity through constraint design in SQL schemas?▼

Ensuring data integrity through constraint design requires applying industry-standard schema evolution patterns and constraint rules during entity-relationship model creation for SQL schemas.

When should I use normalization rules vs document structures for NoSQL database design?▼

Use normalization rules for relational SQL schemas to minimize redundancy, while NoSQL database design utilizes document structures optimized for specific query patterns and scalability.

Related Skills

Explore More Software Engineering Skills→
smithisrealdevsmithisrealdev

database-schema-designer

Design SQL and NoSQL database schemas with normalization and migration scripts.

Community
Advanced
zebbernzebbern
5

database-patterns

Design database schemas and migrations with naming, typing, and indexing conventions.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate
amanhsnamanhsn

Database Designer - POWERFUL Tier Skill

Analyze SQL schemas for normalization, indexing, and constraint issues.

Community
Advanced