SQL

Write, explain, and optimize Postgres/MySQL queries with indexes and EXPLAIN analysis.

Local analytics on Parquet/CSV/JSON with DuckDB. Window functions, joins, no-server data prep.

Room ORM scaffolds: entities, DAOs, migrations, Flow queries, type converters, instrumentation tests.

Prisma schemas, migrations, relations, transactions, and the patterns that scale past 10k requests/min.

Drizzle ORM — SQL-first TypeScript, schema, queries, migrations, edge-runtime compatible.

Neon serverless Postgres — copy-on-write branches, the @neondatabase/serverless HTTP driver, scale-to-zero, per-tenant DBs.

Build a Convex backend — schema, reactive queries, mutations, actions, crons, and live React data with zero cache invalidation.

Production RAG on Postgres with pgvector — embeddings, HNSW vs IVFFlat tuning, hybrid search, scaling.

Astro 6 content sites — server islands, Content Layer API, partial hydration, Cloudflare deploy.