skills.rest
akillness
akillnessCOMMUNITY
Explore all skills by this author →
Website𝕏@akillness0308GitHub

database-schema-design

Define and optimize relational and NoSQL database schemas with entities, relationships, normalization, indexing, constraints, and migrations.

40|9|Updated Jan 4, 2026
Search Tags:#design#database#migrations#schema#sql#indexes#normalization
One-click install
npx skills add https://github.com/akillness/oh-my-skills --skill database-schema-design-akillness
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-schema-design
Source: https://github.com/akillness/oh-my-skills/tree/main/.agent-skills/database-schema-design
Command: npx skills add https://github.com/akillness/oh-my-skills --skill database-schema-design-akillness

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Designing scalable, correct database schemas for SQL and NoSQL platforms to ensure data integrity and scalable performance.

Core Features & Use Cases

  • Entities & Attributes: identify core data objects with appropriate types and keys.
  • Relationships & Normalization: model 1:1, 1:N, N:M relationships with proper normalization and constraints.
  • Indexing & Performance: define indexing strategies, foreign keys, and performance considerations.
  • Migrations & Constraints: craft safe migration scripts with up/down paths and constraint enforcement.

Quick Start

Create a complete database design plan for a new project, including entities, relationships, indexing strategy, constraints, and a migration outline.

Frequently Asked Questions about database-schema-design

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

FAQPage Schema
How do I design a database schema for a new application?▼

Design a database schema by defining core entities, modeling relationships with proper normalization, defining indexing strategies, and enforcing constraints. This process ensures data integrity and scalable performance for both SQL and NoSQL platforms.

What's the best way to model one-to-many and many-to-many relationships in a database schema?▼

Model 1:N and N:M relationships by applying proper normalization and database constraints to your schema. This approach maintains data integrity while structuring relational connections efficiently for your specific application context.

Does this database schema design approach work for both OLTP and OLAP contexts?▼

Yes, this database schema design supports both OLTP and OLAP contexts. It defines and optimizes relational and NoSQL schemas to ensure data integrity and scalable performance across different transactional and analytical processing environments.

How do I create safe database migration scripts with up and down paths?▼

Create safe database migration scripts by crafting up and down paths with strict constraint enforcement. This ensures safe schema migrations that maintain data integrity throughout the database evolution process without risking data loss.

How do I define indexing strategies to improve database performance?▼

Define indexing strategies by identifying appropriate foreign keys and performance considerations within your database schema. Proper indexing optimizes query performance and ensures scalable data retrieval for relational and NoSQL platforms.

When should I use normalization in my database schema design?▼

Use normalization in database schema design when you need to structure entities and relationships to eliminate data redundancy. It ensures data integrity through proper constraints, making it essential for scalable relational database architectures.

Related Skills

Explore More Software Engineering Skills→
AgentientAgentient
2

er-diagram-and-data-modeling

Identify and visualize entity-relationship structures from domain data.

Official
Basic
christopherlouetchristopherlouet
5

ops-database

Design database schemas, indexes, and migrations with SQL and TypeScript scripts.

Community
Advanced
sandros94sandros94
1

integrate-valibot

Integrate Valibot schemas with Standard Schema for interoperability and code generation.

Community
Intermediate
zangxin75zangxin75

data-model-designer

Design construction data models and generate PostgreSQL schemas.

Community
Intermediate