What problem does it solve? Working with a large database layer of 30+ tables, 22 services, junction tables, and exclusive-arc constraints is error-prone without deep context. This Skill gives an AI assistant the full knowledge base of the Threaded Stack database repo so it can write correct queries, services, and migrations on the first attempt. ## Core Features & Use Cases - Schema Reference: Documents all 25 Drizzle-managed tables, 2 external tables (Neon Auth users, Caddy certificates), and 9 junction tables with key fields, indexes, and constraints. - Service Layer Guide: Explains the Base service class CRUD pattern, domain model conversion, and specialized methods like quota atomic increments, thread branching, and pgvector memory search. - Migration & Ops Commands: Covers drizzle-kit workflows (generate, migrate, push, studio), seeding, purging, and the fleet toggle script for standing the autonomous agent fleet up or down. - Use Case: Ask the assistant to add a new org-scoped table with a service, and it will follow the repo's base schema fields, exclusive-arc CHECK constraint conventions, and service inheritance patterns. ## Quick Start Ask the assistant to create a new Drizzle table and matching service for the database repo following the existing patterns.
