skills.rest
lucaspedrozaem
lucaspedrozaemCOMMUNITY
Explore all skills by this author →
GitHub

database

Design and optimize database schemas and migrations for SaaS products.

1|Updated Apr 3, 2026
Search Tags:#indexing#schema design#database#postgresql#migrations#multi-tenancy#prisma
One-click install
npx skills add https://github.com/lucaspedrozaem/saasskills --skill database-lucaspedrozaem
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/lucaspedrozaem/saasskills/tree/main/skills/database
Command: npx skills add https://github.com/lucaspedrozaem/saasskills --skill database-lucaspedrozaem

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Helps teams design and operate reliable, performant, and evolvable databases for SaaS products by guiding schema design, migrations, multi-tenant isolation, and operational practices to reduce downtime and data integrity incidents.

Core Features & Use Cases

  • Schema design: entity modeling, UUID keys, timestamps, foreign keys, and naming conventions tailored to SaaS domains.
  • Migrations & safety: additive-first migration patterns, backfill strategies, and production-safe deployment guidance.
  • Performance & indexing: index planning, composite and partial indexes, and query optimization techniques.
  • Multi-tenancy & security: tenant column strategies, Row-Level Security (RLS) patterns, and audit trails for compliance.
  • Operational practices: backups, connection pooling, seeding strategies, and monitoring recommendations.
  • Use Case: Migrate a single-tenant project to a shared multi-tenant Postgres deployment with zero-downtime migrations and enforced tenant isolation.

Quick Start

Analyze my current schema and recommend a safe, step-by-step migration and indexing plan for a PostgreSQL-based SaaS app.

Frequently Asked Questions about database

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

FAQPage Schema
How do I design a multi-tenant PostgreSQL schema with Row-Level Security for SaaS?▼

Design a multi-tenant PostgreSQL schema by implementing tenant column strategies and Row-Level Security (RLS) patterns to enforce strict tenant isolation and compliance audit trails.

What is the best way to run zero-downtime database migrations for a SaaS app?▼

The best way to run zero-downtime database migrations is using additive-first migration patterns, backfill strategies, and production-safe deployment workflows to prevent data integrity incidents.

How do I optimize PostgreSQL query performance with composite and partial indexes?▼

Optimize PostgreSQL query performance by planning index strategies that utilize composite and partial indexes, reducing latency and improving overall database operational efficiency.

Does this approach support Prisma migrations and UUID primary keys?▼

Yes, this approach supports Prisma migrations and satisfies requirements for UUID primary keys, timestamps, and foreign key constraints within scalable SaaS schema designs.

When do I need connection pooling and backup strategies for my PostgreSQL database?▼

You need connection pooling and backup strategies for your PostgreSQL database when establishing operational practices to ensure reliability, reduce downtime, and maintain data integrity.

How do I migrate a single-tenant project to a shared multi-tenant Postgres deployment?▼

Migrate a single-tenant project to a shared multi-tenant Postgres deployment by applying additive-first migration patterns, backfill strategies, and enforced tenant isolation workflows.

Related Skills

Explore More Software Engineering Skills→
TorbenMerraldTorbenMerrald
1

Backend Models

Define and enforce database models and entity schemas across ORM and migration scripts.

Community
Advanced
frankxaifrankxai
7

database-migrations

Manage database schema evolution with Prisma and Drizzle ORM.

Community
Advanced
markus41markus41
1

database

Design database schemas, optimize SQL queries, and manage migrations for PostgreSQL, MySQL, and SQLite.

Community
Intermediate
7a336e6e7a336e6e
1

Optimizing Performance

Diagnose PostgreSQL bottlenecks via EXPLAIN ANALYZE and optimize indexing.

Community
Advanced