afenda-database-patterns

What problem does it solve?

This Skill provides clear, actionable guidance and examples for adhering to AFENDA-NEXUS's specific database schema design, multi-tenancy implementation, and migration strategies using Drizzle ORM and PostgreSQL.

Core Features & Use Cases

• Schema Design: Understand and implement composite primary keys, entity column helpers, and indexing strategies.
• Multi-tenancy: Learn how to apply Row-Level Security (RLS) for robust tenant isolation.
• Migrations: Follow best practices for creating, reviewing, and applying database migrations.
• Drizzle ORM: Master conventions for defining schemas, writing queries, and leveraging type inference.
• Use Case: When developing a new feature that requires database interaction, consult this Skill to ensure your schema adheres to AFENDA's standards for security, performance, and maintainability.

Quick Start

Show me an example of a Drizzle ORM schema definition for a new table that includes composite primary keys and tenant RLS.