Data explorer
View your tables, views, and rows from the console, with search and filters, without installing a client.
The Data tab of each database lists its tables and views with their row counts, and lets you browse, search, and filter rows without leaving the console.
Tables
You see each object with its type (Table, View, Materialized view, or External) and how many rows it has. New tables show up automatically: create your schema with your ORM or your client, then click Refresh.
Rows
When you open a table, you see its rows, with the primary key highlighted. You can:
- search the entire table,
- filter by column,
- open a row to see all its values. Long values are truncated to 2000 characters.
Read-only
The explorer connects as your database’s app user, uses read-only transactions, and applies a maximum time per query. It can’t modify data or see anything your user can’t see.
SQL from your agent
To run SQL, use your favorite client with external access, or ask your agent:
list_tableslists tables and views with their row counts and sizes.query_postgresruns a read query and returns up to 200 rows as JSON. Withwrite: true, it runs any statement in a transaction with a 30-second limit, and requiresconfirmwith the database name.
See Tools.