About keysetBuilder

Paste the ORDER BY of a list or an API endpoint and get the keyset (seek) pagination queries for PostgreSQL, MySQL 8 or SQLite: the first page, the next page from the last row's values, the index that makes every page one index range, and a cursor to hand the client instead of page numbers. Mixed ASC and DESC and nullable columns are written out the long way, because a row comparison like (a, b) > (x, y) is only right when every column sorts the same way and none can be NULL. Every query it writes was checked on the real engines.

Runs entirely in your browser: your SQL and files are not uploaded. Signed-in members can keep a history of runs and results.