# database-schema-modeling

> Design normalized, secure, and performant relational database schemas for multi-user systems. Use when defining SQLModel schemas and enforcing user-level data isolation.

- Author: Farheenzehra99
- Repository: Farheenzehra99/Hackathone-2
- Version: 20260130004406
- Stars: 0
- Forks: 0
- Last Updated: 2026-02-06
- Source: https://github.com/Farheenzehra99/Hackathone-2
- Web: https://mule.run/skillshub/@@Farheenzehra99/Hackathone-2~database-schema-modeling:20260130004406

---

---
##name: "relational-schema-designer"
description: "Design normalized, secure, and performant relational database schemas for multi-user systems. Use when defining SQLModel schemas and enforcing user-level data isolation."
version: "1.0.0"
---

# Database Schema Modeling Skill

## When to Use This Skill

- Relational database schema design  
- Multi-user data isolation required  
- ORM (SQLModel) based access  
- Performance and data integrity are important

## How This Skill Works

1. Identify entities: tables and ownership  
2. Define relationships: foreign keys and constraints  
3. Apply field constraints: required, optional  
4. Add indexes for query performance  
5. Enforce user-level isolation

## Output Format

- Table Definitions  
- Field Constraints  
- Relationships  
- Indexes and Performance Notes

## Quality Criteria

- Data ownership enforced at DB level  
- Invalid states impossible  
- Queries scale efficiently  
- ORM mapping is clean and predictable