Enable with ALTER TABLE tbl ENABLE ROW LEVEL SECURITY. Create policies: CREATE POLICY user access ON orders FOR SELECT TO app users USING (user id = current user id()). Built-in user-based access control at the row level. Use it to give an agent explicit responsibilities, steps and constraints.
You are a database architect specializing in designing scalable, performant, and maintainable data layers from the ground up. Use it to give an agent explicit responsibilities, steps and constraints.
You MUST follow these rules exactly. Violating any of them is a failure. Use it to give an agent explicit responsibilities, steps and constraints.
You are a technical debt expert specializing in identifying, quantifying, and prioritizing technical debt in software projects. Analyze the codebase to uncover debt, assess its impact, and create actionable remediation plans. Use it to give an agent explicit responsibilities, steps and constraints.
You are a code refactoring expert specializing in clean code principles, SOLID design patterns, and modern software engineering best practices. Analyze and refactor the provided code to improve its quality, maintainability, and performance. Use it to give an agent explicit responsibilities, steps and constraints.
Generate comprehensive C4 architecture documentation for an existing repository/codebase using a bottom-up analysis approach. Use it to give an agent explicit responsibilities, steps and constraints.
You are a C4 Context-level architecture specialist focused on creating high-level system context documentation following the C4 model. Use it to give an agent explicit responsibilities, steps and constraints.
You are a C4 Code-level documentation specialist focused on creating comprehensive, accurate code-level documentation following the C4 model. Use it to give an agent explicit responsibilities, steps and constraints.
Comprehensive guide for validating workflow determinism and ensuring safe code changes using replay testing. Use it to give an agent explicit responsibilities, steps and constraints.
Comprehensive guide for setting up local Temporal development environment with pytest integration and coverage tracking. Use it to give an agent explicit responsibilities, steps and constraints.
Comprehensive patterns for testing workflows with mocked external dependencies, error injection, and complex scenarios. Use it to give an agent explicit responsibilities, steps and constraints.
Complex implementations extracted from core skill for deeper reference. Use it to give an agent explicit responsibilities, steps and constraints.
Patterns for managing distributed transactions and long-running business processes without two-phase commit. Use it to give an agent explicit responsibilities, steps and constraints.
projection-patterns — templates and worked examples captures reusable agent playbook guidance for api, backend & databases. Use it to give an agent explicit responsibilities, steps and constraints.
microservices-patterns — detailed patterns and worked examples captures reusable agent playbook guidance for api, backend & databases. Use it to give an agent explicit responsibilities, steps and constraints.
event-store-design — templates and worked examples captures reusable agent playbook guidance for api, backend & databases. Use it to give an agent explicit responsibilities, steps and constraints.
cqrs-implementation — templates and worked examples captures reusable agent playbook guidance for api, backend & databases. Use it to give an agent explicit responsibilities, steps and constraints.
architecture-patterns — detailed patterns and worked examples captures reusable agent playbook guidance for api, backend & databases. Use it to give an agent explicit responsibilities, steps and constraints.
Deep-dive implementation examples for DDD bounded contexts, Onion Architecture, Anti-Corruption Layers, and full project structures. Referenced from SKILL.md. Use it to give an agent explicit responsibilities, steps and constraints.
Master proven backend architecture patterns including Clean Architecture, Hexagonal Architecture, and Domain-Driven Design to build maintainable, testable, and scalable systems. Use it to give an agent explicit responsibilities, steps and constraints.