Ctrl+Z Therapy
CasesQuick answers10-minute checklistHow we testCartoonSend it in

Why does my Supabase app only show 1,000 rows?

Ship ItChecked against the official source

Source checked 30 Sept 2026 · Published 1 Oct 2026 · Last reviewed 1 Oct 2026 · By Ctrl+Z Therapy (how we test)

The short answer

By default, Supabase returns at most 1,000 rows per request. There's no error: the rest just isn't in the answer, so your list looks complete when it isn't. The fix is to load big lists in pages, with range(), instead of all at once.

What to do

  1. If a list shows exactly 1,000 items, assume it's cut off.
  2. Ask your AI tool: "Where do we load lists without paging? Load them in pages with range()."
  3. You can raise the max rows setting in the project's API settings, but Supabase recommends keeping it low.

Source

Checked on 30 Sept 2026. Prices, limits and settings change, so check the source before you rely on them.

Related