Can I use camelCase for my database columns?

No, this skill strictly enforces snake_case for all database fields to follow industry best practices and ensure consistent SQL performance.

How does it handle data isolation for multi-tenant apps?

It enforces a mandatory tenant_id field on all tables and provides standard SQL templates for Row Level Security (RLS) to ensure data privacy.

What common fields are automatically suggested?

The skill ensures every table includes standard audit timestamps (created_at, updated_at) and appropriate foreign key indexing.

Which ORMs does this database skill support?

This skill provides specialized implementation patterns and templates for Drizzle ORM (TypeScript) and SQLModel (Python).

Does this skill help with database migrations?

Yes, it includes workflows and command references for Drizzle-kit (TypeScript) and Alembic (Python) to manage schema changes safely.

Database Design & Schema Standards

Name: Database Design & Schema Standards
Author: greyhaven-ai

bygreyhaven-ai

•

Database Management

Enforces standardized database conventions, multi-tenant isolation, and schema best practices for Drizzle ORM and SQLModel.

The Database Design & Schema Standards skill ensures your data layer is consistent, scalable, and secure by applying Grey Haven's proven database conventions. It specializes in multi-tenant architectures, mandating snake_case naming, tenant_id isolation, and Row Level Security (RLS) policies. Whether you are using Drizzle ORM in TypeScript or SQLModel in Python, this skill provides the patterns, indexing strategies, and migration workflows needed to maintain high-quality database schemas and prevent common data modeling errors.

Key Features

0115 GitHub stars

02Standardized timestamp and indexing strategies for optimized queries

03Automated templates for Row Level Security (RLS) policies

04Strict enforcement of snake_case naming for database columns

05Cross-language support for Drizzle ORM (TS) and SQLModel (Python)

06Mandatory multi-tenant isolation patterns using tenant_id

Use Cases

01Migrating existing camelCase application models to standardized SQL schemas

02Implementing robust data isolation using Row Level Security policies

03Designing a new multi-tenant SaaS database schema with PostgreSQL

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add greyhaven-ai/claude-code-config database-conventions

For use in Claude.ai and ChatGPT

Download Skill