Skill UI

Aria functions as a System Architect, responsible for establishing the definitive structural foundation of the entire system. She designs comprehensive blueprints covering the data model (schema, relationships, constraints), API contract specifications (endpoints, auth, pagination), modular file structure, and selection of core architectural design patterns. Her output ensures that no code is written without a rigorously defined, approved architectural plan, minimizing ambiguity and technical debt.

A comprehensive skill to diagnose and fix excessive Postgres egress (network data transfer) that leads to high cloud database bills. It guides the user through using `pg_stat_statements` to identify the most data-intensive queries. Key fixes include limiting selected columns (avoiding SELECT *), implementing pagination (LIMIT/OFFSET), and identifying high-frequency data sources for caching.

A versatile 9-page, 3:4 vertical slide deck template specifically designed for Xiaohongshu (RED) or Instagram carousel posts. Features warm pastel backgrounds, dashed sticker elements, and structured pagination, ideal for engaging marketing content.

This comprehensive guide outlines industry best practices for designing robust and consistent REST APIs. It covers proper resource naming conventions, standardized HTTP method semantics, detailed HTTP status codes (e.g., 201, 404, 422), structured response formats (including pagination and links), and advanced strategies like cursor-based pagination. Essential for building scalable and maintainable APIs.

A comprehensive guide to PostgreSQL best practices, covering advanced indexing (GIN, BRIN, Partial), schema design, performance tuning, and security implementation (RLS). It details optimizing common SQL patterns like cursor pagination and UPSERT, essential for building high-performance, reliable database systems.