1. Browse the catalog and choose a table
Open the SQLite or DuckDB file with Open data. Review the available user tables and their schema. Select the table you intend to inspect instead of accepting the first table as the complete database.
Choose a table whose meaning you understand. Tables named results, trades, quotes or features can contain very different levels of aggregation; a profitable result summary is not the underlying trade history.
2. Project fields and use native predicates
Request only the fields needed for the question. Apply supported equality or range predicates, such as a symbol plus a time interval. The database optimizer and available indexes may reduce the work, depending on the schema and query.
The bounded page workflow avoids a full-table count merely to display the first records. A quick first page does not imply that a complete scan or complex sort will have the same cost.
3. Choose a stable ordering when it matters
If repeatable pagination matters, order by columns that uniquely identify a row or a suitable compound key. An ambiguous timestamp order can move rows between pages when several records share the same time.
A database query offset is not a file-source record locator. Keep the selected schema, table, predicates and ordering with your notes. Snapshot consistency and keyset pagination are separate guarantees that should not be assumed from a displayed page.
4. Check the interpretation before drawing a conclusion
Inspect exact timestamp representations, NULL values, numeric precision and the units of each measure. For research results, look for full costs, losing cases and chronological evidence before treating a top-ranked row as a robust strategy.
Use the database workflow instructions and MCP tutorial to make the same explicit choices in an automated inspection.
Try the first page on your own data.
Start with the free Windows Preview: source information and up to 100 records, read-only. Review reader capabilities before planning a full-file Pro workflow.
Pro checkout is being prepared. The initial Windows install enables signed in-app updates for later versions.