infrastructure-guidelines

What problem does it solve?

This Skill manages complex, multi-component infrastructure (database, Kubernetes, eventing) with a focus on safety, idempotency, and compliance. It streamlines the creation and evolution of database schemas, event contracts, and service deployments, reducing manual errors and ensuring consistency across environments.

Core Features & Use Cases

• Idempotent Supabase SQL Migrations: Safely evolve your PostgreSQL schema with RLS policies and event triggers, ensuring changes are reversible and repeatable.
• Kubernetes Deployments for Temporal Workers: Deploy and manage Temporal.io workers with best practices for resource limits, health checks, and rolling updates.
• CQRS Projections & AsyncAPI Contracts: Implement event-driven read models and define robust, versioned event schemas for a scalable, auditable architecture.
• Use Case: Automatically provision a new multi-tenant environment, including database schema, RLS policies, and eventing infrastructure, ensuring every step is auditable and recoverable.

Quick Start

Use the infrastructure-guidelines skill to create a new idempotent Supabase SQL migration for a 'patients' table, including RLS for tenant isolation.