skills.rest
doanchienthangdev
doanchienthangdevCOMMUNITY
Explore all skills by this author →
GitHub

designing-database-schemas

Design normalized database schemas with indexing strategies and data modeling patterns.

4|1|Updated Dec 30, 2025
Search Tags:#indexing#schema design#postgresql#data modeling#normalization#database schema
One-click install
npx skills add https://github.com/doanchienthangdev/omgkit --skill designing-database-schemas-doanchienthangdev
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: designing-database-schemas
Source: https://github.com/doanchienthangdev/omgkit/tree/main/plugin/skills/databases/database-schema-design
Command: npx skills add https://github.com/doanchienthangdev/omgkit --skill designing-database-schemas-doanchienthangdev

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses the complexity of designing robust, scalable, and efficient database schemas that balance normalization with performance needs.

Core Features & Use Cases

  • Normalization: Applies principles (1NF-3NF, BCNF) to reduce redundancy and improve data integrity.
  • Indexing Strategies: Designs optimal indexes for query performance.
  • Data Modeling Patterns: Implements common patterns like audit trails, soft deletes, and multi-tenancy.
  • Use Case: When starting a new project, use this Skill to design the core database tables for users, products, and orders, ensuring relationships are correctly modeled and indexed for efficient retrieval.

Quick Start

Use the designing-database-schemas skill to create a PostgreSQL table for users with email, username, and password hash, including a unique constraint on email and username.

Frequently Asked Questions about designing-database-schemas

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

FAQPage Schema
What is the best way to design a PostgreSQL database schema for a new project?▼

Database schema indexing strategies improve query performance by creating optimal indexes on tables. This skill designs indexing strategies alongside data modeling patterns to ensure efficient data retrieval and maintainable storage solutions.

How do I model multi-tenancy and soft deletes in a database schema?▼

Database schema normalization reduces data redundancy and improves integrity by applying principles like 1NF, 2NF, 3NF, and BCNF. This skill applies these normalization forms to balance data integrity with performance requirements.

Can this skill review an existing database schema architecture?▼

Database schema design for scalable applications requires balancing normalization with performance needs. This skill crafts production-grade schemas by applying proper normalization, indexing strategies, and data modeling patterns for maintainable data storage.

How do I create PostgreSQL tables with unique constraints for users?▼

To create PostgreSQL tables with unique constraints for users, define columns for email, username, and password hash, then apply unique constraints on email and username. This ensures data integrity and prevents duplicate user records.

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
inbharataiinbharatai
22

db-schema-designer

Design normalized relational database schemas with ERDs, indexes, constraints, and migration scripts.

Community
Intermediate
CJ-1981CJ-1981

moai-domain-database

Design and optimize PostgreSQL, MongoDB, Redis, and Oracle database schemas and queries.

Community
Advanced
miles990miles990
20

data-design

Guide relational and NoSQL database schema design with normalization and pipeline patterns.

Community
Advanced