Skill UI

This guide provides comprehensive patterns for designing and implementing secure multi-tenant SaaS applications using shared databases. It covers critical techniques like Row-Level Security (RLS) in PostgreSQL, implementing tenant-aware middleware in TypeScript (Express/Fastify), and enforcing data scoping at the ORM level (Prisma/Drizzle). Learn how to prevent data leakage and manage tenant isolation across shared schemas.

This comprehensive guide facilitates the development of a production-ready Minimum Viable Product (MVP) for a SaaS business. It covers the entire lifecycle, including idea validation, modern tech stack selection (Next.js, Supabase, Stripe), architectural design for multi-tenancy, database schema planning, authentication setup, payment integration, and a detailed pre-launch checklist for technical and marketing readiness.

Reference document for monopoly scale-benchmarks. Provides quick formulas for converting DAU to RPS, storage and bandwidth estimation, known scale limits of common technologies (databases, queues, caching), capacity planning by user scale (1K to 10M DAU), SLO targets, and latency budget guidelines. Useful for system design, capacity planning, and architecture decisions.

Diagnose slow SQL queries using execution plans, preserve results, and validate indexing or query modifications against representative data. This skill helps debug performance issues, design efficient schemas, reduce database load, and improve application scalability for growing datasets.

This skill provides comprehensive guidelines for optimizing Postgres database performance and security. It covers query optimization, schema design, connection management, Row-Level Security, and concurrency handling. Use it when writing SQL, reviewing database configurations, or implementing indexes. Based on Supabase best practices to ensure efficient and secure database operations for production environments.

A comprehensive reference guide for selecting core infrastructure technologies including databases, caching, message queues, and API protocols. Helps architects and developers make informed decisions based on scale, consistency, and specific use cases to optimize system design.

This skill captures and persists critical user decisions, project constraints, and architectural choices across multiple sessions and agents. It saves this context into a structured memory database (`mdbase`), ensuring that future development steps or agents can retrieve the original intent without re-deriving it from scratch. Ideal for documenting project rules, tech stacks, and design rationale.