src/lib/routers/pipeline.ts list procedure returns ALL pipeline runs for accessible projects with no LIMIT clause. A platform running 100+ pipelines per project will return tens of thousands of rows per request, OOMing the serverless function and saturating the Neon HTTP connection.
Category: api
File: src/lib/routers/pipeline.ts
Recommendation: Add .limit(200) and cursor-based or offset pagination. The dashboard page at src/app/dashboard/pipelines/page.tsx already loads ALL runs server-side and then client-filters in JS — this pattern must be replaced with server-side pagination and filtering pushed to the DB WHERE clause.
Estimated Improvement: Could cut response payload by 95%+ and reduce p99 latency from seconds to <100ms on large projects