zibyn/best-practices-skills

Postgres best practices for schema design, indexing, query performance, connection management, locking, and row-level security, for Postgres running anywhere. Load this skill BEFORE writing or changing anything that lives in a Postgres database: creating or altering tables and columns (including choosing column types), migrations, constraints, indexes, RLS policies, privileges, and SQL queries. Also load it when diagnosing slow queries, high CPU, timeouts, EXPLAIN plans, connection exhaustion, locking, bloat, or rows visible to the wrong user or tenant.

React performance optimization guidelines, including server rendering and React Server Components. Use when writing, reviewing, or refactoring React code (in any framework, such as Next.js, Remix/React Router, or Vite) to ensure optimal performance patterns. Triggers on tasks involving React components, pages, data fetching, bundle optimization, or performance improvements.

Manages shadcn components and projects — adding, searching, fixing, debugging, styling, and composing UI, including chat interfaces. Provides project context, component docs, and usage examples. Applies when working with shadcn/ui, component registries, presets, --preset codes, or any project with a components.json file. Also triggers for "shadcn init", "create an app with --preset", "switch to --preset", and for building a design system or applying a DESIGN.md or brand spec to shadcn/ui.