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

•

数据库管理

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.

主要功能

15 GitHub stars
Standardized timestamp and indexing strategies for optimized queries
Automated templates for Row Level Security (RLS) policies
Strict enforcement of snake_case naming for database columns
Cross-language support for Drizzle ORM (TS) and SQLModel (Python)
Mandatory multi-tenant isolation patterns using tenant_id

使用场景

Migrating existing camelCase application models to standardized SQL schemas
Implementing robust data isolation using Row Level Security policies
Designing a new multi-tenant SaaS database schema with PostgreSQL

关于

主要功能

15 GitHub stars
Standardized timestamp and indexing strategies for optimized queries
Automated templates for Row Level Security (RLS) policies
Strict enforcement of snake_case naming for database columns
Cross-language support for Drizzle ORM (TS) and SQLModel (Python)
Mandatory multi-tenant isolation patterns using tenant_id

使用场景

Migrating existing camelCase application models to standardized SQL schemas
Implementing robust data isolation using Row Level Security policies
Designing a new multi-tenant SaaS database schema with PostgreSQL