Databases and API servers. Default to Postgres for app data and SQLite for local or single-writer cases. Reach for ChromaDB when the workload is small-scale vector retrieval.
Postgres
- postgres: Postgres 18 defaults, key choices, pooling, and where each topic lives.
- postgres-indexes: B-tree, GIN, GiST, BRIN, partial, expression, and covering indexes; CONCURRENTLY.
- postgres-jsonb: JSONB operators, GIN classes, SQL/JSON, and promoting keys to columns.
- postgres-explain: Reading EXPLAIN ANALYZE plans and the pg_stat_statements loop.
- postgres-vacuum: Autovacuum tuning, bloat, pg_repack, and transaction ID wraparound.
- postgres-replication: Streaming and logical replication, slots, lag, and sync modes.
- postgres-partitioning: Range, list, and hash partitioning with pg_partman.
- postgres-full-text-search: tsvector, tsquery, GIN, pg_trgm, and when to switch engines.
- migrations: Forward-only migrations, lock_timeout, and zero-downtime patterns.
Prisma
- prisma: Prisma 7 status, minimal setup, and which page covers each task.
- prisma-schema: schema.prisma modeling with the prisma-client generator.
- prisma-migrations: migrate dev and deploy, baseline, drift, and squashing.
- prisma-client: Driver adapters, the client singleton, logging, and $extends.
- prisma-transactions: Array and interactive transactions, isolation, and P2034 retries.
- prisma-pooling: Driver pool settings, PgBouncer, serverless, and Accelerate.
- prisma-raw-queries: executeRaw with Prisma.sql.
- prisma-v6-to-v7-upgrade: Checklist for upgrading Prisma 5 or 6 to 7.
FastAPI
- fastapi: FastAPI 0.142 baseline, install, and route layout.
- fastapi-pydantic: Pydantic v2 input and output models, constraints, and aliases.
- fastapi-dependencies: Depends, yield scope, and the lifespan context manager.
- fastapi-async-io: async def versus def, the threadpool, and worker sizing.
- fastapi-background-tasks: BackgroundTasks limits and when to use a real queue.
- fastapi-openapi: OpenAPI 3.1 accuracy, docs URLs, and client generation.
ChromaDB
- chromadb: Chroma 1.x clients, retrieval defaults, and when to leave.
- chromadb-collections: Collection design, distance settings, metadata, and embedding ownership.
- chromadb-filters: where, where_document, and application-side hybrid retrieval.
- chromadb-persistence: PersistentClient, server mode, Docker, auth, CVE-2026-45829, and backups.
- chromadb-scale-limits: Single-node sizing and migration to pgvector, Qdrant, or Cloud.
Other databases and services
- sqlite: When SQLite fits, WAL pragmas, the WAL-reset bug, and backups.
- supabase: Publishable and secret keys, explicit Data API grants, CLI, and pooling modes.
- supabase-rls: Grants plus RLS policies, USING and WITH CHECK, and wrapped auth.uid().
Auth, payments, and operations
- auth-sessions: Session cookies, rotation, refresh tokens, CSRF, and revocation.
- payments-stripe: Stripe webhook verification, API versions, idempotency, and fulfillment.
- webhooks: Inbound webhook HMAC, dedupe, fast 2xx, and replay protection.
- email-deliverability: SPF, DKIM, DMARC, and Gmail and Yahoo bulk-sender rules.
- observability: OpenTelemetry, structured logs, metrics, and stable semantic conventions.