postgres
PlanetScale Postgres
Generic Postgres
| Topic | Reference | Use for |
|---|---|---|
| Schema Design | references/schema-design.md | Tables, primary keys, data types, foreign keys |
| Indexing | references/indexing.md | Index types, composite indexes, performance |
| Index Optimization | references/index-optimization.md | Unused/duplicate index queries, index audit |
| Partitioning | references/partitioning.md | Large tables, time-series, data retention |
| Query Patterns | references/query-patterns.md | SQL anti-patterns, JOINs, pagination, batch queries |
| Optimization Checklist | references/optimization-checklist.md | Pre-optimization audit, cleanup, readiness checks |
| MVCC and VACUUM | references/mvcc-vacuum.md | Dead tuples, long transactions, xid wraparound prevention |
Operations and Architecture
More from pageai-pro/ralph-loop
prd-creator
Guides creation of comprehensive Product Requirement Documents (PRDs) for software projects through structured questioning and validation, then generates implementation task lists in JSON format. Use when users want to document a software idea, create specifications for development, plan a new application feature/bug, or break down requirements into actionable tasks. Transforms ideas into implementation-ready documents with verifiable pass criteria.
1.0Kvitest-best-practices
Comprehensive vitest testing patterns covering test structure, AAA pattern, parameterized tests, assertions, mocking, test doubles, error handling, async testing, and performance optimization. Use when writing, reviewing, or refactoring vitest tests, or when user mentions vitest, testing, TDD, test coverage, mocking, assertions, or test files (*.test.ts, *.spec.ts).
32e2e-tester
>
31frontend-code-review
Trigger when the user requests a review of frontend files (e.g., `.tsx`, `.ts`, `.js`). Support both pending-change reviews and focused file reviews while applying the checklist rules.
24component-refactoring
Refactor high-complexity React components in frontend. Use when the user asks for code splitting, hook extraction, or complexity reduction, or when you come across a component that is too complex to understand and refactor it.
24frontend-testing
Generate Vitest + React Testing Library tests for frontend components, hooks, and utilities. Triggers on testing, spec files, coverage, Vitest, RTL, unit tests, integration tests, or write/review test requests.
23