skills.rest
HotspotVPN
HotspotVPNCOMMUNITY
Explore all skills by this author →
GitHub

database-design

Design PostgreSQL schemas and migrations for multi-tenant SaaS applications.

Updated Aug 23, 2026
Search Tags:#design#database#multi-tenant#migrations#schema#soft-delete#audit-logs
One-click install
npx skills add https://github.com/HotspotVPN/Nest_Match_UAE --skill database-design-hotspotvpn
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/HotspotVPN/Nest_Match_UAE/tree/main/skills/database-design
Command: npx skills add https://github.com/HotspotVPN/Nest_Match_UAE --skill database-design-hotspotvpn

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Database design is the foundation of scalable, maintainable applications, ensuring data integrity, security, and efficient migrations.

Core Features & Use Cases

  • Soft-delete and audit columns across schemas to support compliant data lifecycle.
  • Multi-tenant patterns and base schema templates for users, organizations, and access control.
  • Migration-ready patterns including safe column changes, UUID keys, and foreign-key constraints for reliable deployments.

Quick Start

Define a resilient base schema for a new service by applying base columns, soft delete, audit trails, and then implement a multi-tenant pattern with a safe migration plan.

Frequently Asked Questions about database-design

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

FAQPage Schema
How do I design a database schema for a multi-tenant SaaS application?▼

Design multi-tenant database schemas by applying base templates for users and organizations, enforcing UUID primary keys and foreign-key constraints for data isolation. This approach ensures scalable, safe data foundations across PostgreSQL deployments.

How do I add soft deletes and audit logs to an existing database schema?▼

Add soft deletes and audit logs by applying standardized columns across your database schema to support a compliant data lifecycle. This enables tracking of modifications and safe record recovery without permanent data removal.

What is the best way to plan safe database migrations with schema changes?▼

Plan safe database migrations by utilizing migration-ready patterns that include safe column changes, UUID keys, and foreign-key constraints. This strategy ensures reliable deployments and maintains data integrity during schema modifications.

Does this database design approach work with PostgreSQL deployments?▼

Yes, this database schema design approach directly applies to PostgreSQL deployments. It enforces UUID primary keys, foreign-key constraints, and scalable multi-tenant patterns specifically within PostgreSQL environments.

When do I need UUID primary keys and foreign-key constraints in database design?▼

You need UUID primary keys and foreign-key constraints in database design when building migration-ready patterns for multi-tenant SaaS applications. They ensure reliable deployments, data integrity, and scalable organizational access control.

Related Skills

Explore More Software Engineering Skills→
sarimofficialsarimofficial

sqlmodel-task-models

Define SQLModel schemas for Todo users and tasks with relationships and timestamps.

Community
Intermediate
H2OSLabsH2OSLabs
1

designing-database-schemas

Design relational database schemas and generate automated migrations with Python scripts.

Official
Intermediate
marquesfelipmarquesfelip

tenant-isolation

Enforce tenant isolation across data queries, storage, and background processing.

Community
Advanced
Geralt1983Geralt1983
1

Database Designer

Design relational and NoSQL database schemas with normalization and indexing guidance.

Community
Advanced