Skip to main content
GET
Get database table rows

Authorizations

Authorization
string
header
required

Session access JWT or an API token (insta_<prefix>_<secret>).

Path Parameters

projectId
string<uuid>
required
schema
string
required
table
string
required

Query Parameters

branch
string

Branch name (defaults to the project's default branch)

group
string

postgres service name (default: the sole postgres service)

database
string

database on the instance (default: the connection-string database)

limit
integer
default:100
Required range: 1 <= x <= 1000
offset
integer
default:0
Required range: x >= 0

Response

Default Response

columns
object[]
required
rows
any[][]
required

rows as positional cells — duplicate column names stay distinct; numeric/int8 arrive as strings

rowCount
integer
required
truncated
boolean
required

true when the 5MB byte budget dropped wide rows from this page

approxRows
integer
required

reltuples estimate — exact COUNT(*) would scan the table on the user's compute