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

•

Database Management

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.

Key Features

01Optimized indexing strategies for foreign keys and tenant-specific queries

02Ready-to-use migration templates for Drizzle Kit and Alembic

03Dual-ORM support for SQLModel (Python) and Drizzle ORM (TypeScript)

0415 GitHub stars

05Automated multi-tenant isolation via mandatory tenant_id fields and RLS policies

06Strict enforcement of snake_case naming conventions and standard audit timestamps

Use Cases

01Refactoring existing tables to implement Row Level Security and soft deletes

02Standardizing database field naming and indexing for performance and consistency

03Designing new multi-tenant database schemas from scratch with built-in isolation

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add greyhaven-ai/claude-code-config data-modeling

For use in Claude.ai and ChatGPT

Download Skill