Neon Multi-Tenant Skill

What problem does it solve?

This Skill provides a comprehensive guide to leveraging Neon PostgreSQL's branching architecture for robust multi-tenant database isolation, optimizing schema organization, and configuring tenant-scoped queries with Drizzle ORM.

Core Features & Use Cases

• Neon Branch Strategy: Implement multi-tenant or multi-app isolation using Neon branches.
• Schema Organization: Structure schemas across shared databases, including shared auth and per-app schemas.
• Drizzle ORM Configuration: Set up tenant-scoped queries with automatic tenant_id injection.
• Cloudflare Hyperdrive: Integrate connection pooling for Neon in Workers.
• Migration Coordination: Manage schema changes across Neon branches.
• Isolation Decision Matrix: Choose the right isolation level (branches vs. schemas vs. RLS) for different tenant tiers.
• Use Case: A SaaS platform needs to isolate data for hundreds of thousands of customers. This Skill guides the implementation using Neon branches for T1 (partner) isolation and RLS for T2 (customer) isolation within each branch, ensuring data security and scalability.

Quick Start

Use the neon-multi-tenant skill to understand how to set up a new Neon branch for a specific application tenant.