skills.rest
FindMalek
FindMalekCOMMUNITY
Explore all skills by this author →
Website𝕏@foundmalekGitHub

database-schema-designer

Design normalized SQL and NoSQL schemas with keys, constraints, and migration templates.

9|2|Updated Nov 10, 2025
Search Tags:#design#database#migrations#schema#sql#normalization#nosql
One-click install
npx skills add https://github.com/FindMalek/dukkani --skill database-schema-designer-findmalek
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-schema-designer
Source: https://github.com/FindMalek/dukkani/tree/main/.cursor/skills/database-schema-designer
Command: npx skills add https://github.com/FindMalek/dukkani --skill database-schema-designer-findmalek

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Database schema design is error-prone and time-consuming when starting new projects or evolving existing systems. This Skill provides a structured approach to model entities, define relationships, and enforce data integrity.

Core Features & Use Cases

  • Normalize data to 3NF for SQL and design practical NoSQL schemas with embedding or referencing.
  • Define keys, constraints, and migration patterns to support zero-downtime deployments.
  • Tailor indexing strategies to optimize OLTP and OLAP workloads, with guidance for migrations and audits.

Quick Start

Describe your data model to generate production-ready schemas and a reversible migration plan.

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 database schema with proper normalization for SQL?▼

Database schema design normalizes SQL data to 3NF by defining primary and foreign keys, data types, and constraints to ensure data integrity and accurately model entities.

What is the best way to structure a NoSQL database schema?▼

NoSQL database schema design structures data using embedding or referencing patterns to optimize practical queries, differing from SQL normalization to suit document or key-value store workloads.

How do I generate reversible database migrations for evolving systems?▼

Database schema design generates reversible migration templates to support zero-downtime deployments, ensuring structural changes can be safely rolled back or applied during system evolution.

How do I optimize indexing strategies for OLTP and OLAP workloads?▼

Database schema design tailors indexing strategies specifically for OLTP and OLAP workloads, optimizing transactional throughput and analytical query performance based on data access patterns.

Can I use database schema design for both new projects and existing systems?▼

Yes, database schema design streamlines modeling for both new projects and evolving existing systems, providing structured approaches to enforce data integrity and guide structural changes.

What constraints and keys are defined during database schema design?▼

Database schema design defines primary and foreign keys alongside data type constraints, enforcing data integrity and establishing clear relationships between modeled entities.

Related Skills

Explore More Software Engineering Skills→
popup-studio-aipopup-studio-ai
589

phase-1-schema

Define project terminology and data models to eliminate ambiguity.

Official
Intermediate
layeddielayeddie
1

migration-patterns

Plan and execute zero-downtime Elixir/Phoenix database migrations with reversible rollbacks.

Community
Advanced
TiepbmTiepbm

sql-and-query-optimization

Optimize SQL and ORM-generated queries by analyzing execution plans and indexes.

Community
Advanced
snoodleboot-iosnoodleboot-io
2

mermaid-erd-creation

Generate ERD blueprints from Mermaid syntax descriptions.

Official
Basic