Is there a limit to the amount of rows returned?

[Zloka]

The documentation says the maximum rows returned defaults to 1000. We have increased this limit, and for our use-case we may need to increase it further in the future.

I was wondering if there is some maximum value, or if I can just arbitrarily increase this limit?

[silentworks]

You should probably keep that limit and paginate the rest of the results. The higher you increase it to the slower the query will become to return the records. I don't think there is a maximum value.

[soedirgo]

Hey @largesseio, this is a regression: #4544

[pencilcheck]

really, the limit is 1000?

[soedirgo]

@pencilcheck it's the default limit - you can increase it.

[ssmcb]

Is there any way of setting the max rows limit by table instead of the whole API?

[GaryAustin1]

No. You only have the option like .limit() in the calls on a table.

[wscourge]

The accepted answer doesn't help at all. You can increase the limit here:

https://supabase.com/dashboard/project/:id/settings/api

at the very bottom (Search "Max rows"). Maximum value allowed is 1000000.

[iwasrobbed]

Doesn't seem like there's a localhost variant of this for local dev. Any chance there is and I just can't find it?

[wscourge]

Add [api].max_rows = 1000000 to your supabase/config.toml:

# A string used to distinguish different Supabase projects on the same host. Defaults to the working
# directory name when running `supabase init`.
project_id = "demo"

[api]
# Port to use for the API URL.
port = 54321
# Schemas to expose in your API. Tables, views and stored procedures in this schema will get API
# endpoints. public and storage are always included.
schemas = ["public", "storage", "graphql_public"]
# Extra schemas to add to the search_path of every request. public is always included.
extra_search_path = ["public", "extensions"]
# The maximum number of rows returns from a view, table, or stored procedure. Limits payload size
# for accidental or malicious requests.
max_rows = 1000000

[db]
# Port to use for the local database URL.
port = 54322

...
...
..