What ORMs does this skill support?

This skill provides specialized standards and templates for both SQLModel (Python/FastAPI) and Drizzle ORM (TypeScript/TanStack).

Does this skill handle database migrations?

Yes, it includes specific patterns and CLI commands for generating and applying migrations using Drizzle Kit for TypeScript and Alembic for Python.

Can I use this for non-SaaS applications?

While optimized for multi-tenant SaaS, the schema standards, indexing rules, and relationship patterns are excellent best practices for any robust PostgreSQL-based application.

What naming convention does this skill follow?

It strictly enforces snake_case for all table and field names (e.g., email_address, created_at) to ensure PostgreSQL compatibility and team consistency.

Why is tenant_id required on every table?

Mandatory tenant IDs ensure strict data isolation in multi-tenant SaaS environments, serving as the foundation for Row Level Security (RLS) to prevent cross-tenant data leaks.

Grey Haven Multi-Tenant Data Modeling

Name: Grey Haven Multi-Tenant Data Modeling
Author: greyhaven-ai

bygreyhaven-ai

•

データベース管理

Standardize and automate multi-tenant database schema design using SQLModel and Drizzle ORM.

概要

This skill empowers Claude to design production-grade, multi-tenant database schemas specifically optimized for Grey Haven SaaS applications. It enforces strict data isolation through mandatory tenant IDs and Row Level Security (RLS) while adhering to professional naming conventions like snake_case and standardized audit fields. By integrating patterns for both SQLModel (FastAPI) and Drizzle ORM (TanStack Start), it ensures consistent data structures, optimized indexing, and reliable migration workflows across diverse tech stacks.

主な機能

Optimized indexing strategies for foreign keys and tenant-specific queries
Ready-to-use migration templates for Drizzle Kit and Alembic
Dual-ORM support for SQLModel (Python) and Drizzle ORM (TypeScript)
15 GitHub stars
Automated multi-tenant isolation via mandatory tenant_id fields and RLS policies
Strict enforcement of snake_case naming conventions and standard audit timestamps

ユースケース

Refactoring existing tables to implement Row Level Security and soft deletes
Standardizing database field naming and indexing for performance and consistency
Designing new multi-tenant database schemas from scratch with built-in isolation

概要

主な機能

Optimized indexing strategies for foreign keys and tenant-specific queries
Ready-to-use migration templates for Drizzle Kit and Alembic
Dual-ORM support for SQLModel (Python) and Drizzle ORM (TypeScript)
15 GitHub stars
Automated multi-tenant isolation via mandatory tenant_id fields and RLS policies
Strict enforcement of snake_case naming conventions and standard audit timestamps

ユースケース

Refactoring existing tables to implement Row Level Security and soft deletes
Standardizing database field naming and indexing for performance and consistency
Designing new multi-tenant database schemas from scratch with built-in isolation