everystack-backend

What problem does it solve?

This Skill provides a comprehensive set of conventions and patterns for backend development within the EveryStack multi-tenant SaaS platform, ensuring consistency, maintainability, and adherence to best practices.

Core Features & Use Cases

• Database Schema & Access: Enforces Drizzle ORM patterns for PostgreSQL, including UUIDv7 primary keys, tenant isolation columns, and canonical JSONB storage.
• Migrations & RLS: Guides the creation of safe, zero-downtime migrations and robust Row-Level Security policies.
• Testing & Error Handling: Mandates tenant isolation testing, use of test factories, and structured error reporting with Zod validation.
• Sync Engine & CockroachDB: Outlines patterns for the sync engine and essential safeguards for CockroachDB compatibility.
• Use Case: When developing a new feature that involves storing tenant-specific user data, this Skill will guide the creation of the Drizzle schema, ensure the tenant_id column is present, set up the necessary RLS policy, and dictate how data access functions should be written and tested.

Quick Start

Use the everystack-backend skill to define a new Drizzle schema for user profiles, ensuring it includes a tenant_id and uses UUIDv7 for the primary key.