inspect_row
Retrieve a PostgreSQL row by its full primary key plus immediate foreign-key neighbors in one call, returning bounded related rows and status details.
Instructions
Fetch one row by its full primary key plus its depth-1 declared foreign-key neighborhood in one call. Each relation is one FK constraint: direction outgoing (rows the root references) or incoming (rows referencing the root), the related table, constraint, source_columns (referencing) paired by position with target_columns (referenced), status (ok, timeout, error), and compact rows (columns once, rows as arrays). Each relation returns up to N rows (default 5) ordered by the related table's primary key (order_by; ctid without one), never by recency; has_more means more rows existed, with no count. Relations not attempted due to the relation cap or total deadline are listed in relations_not_attempted with reason (max_relations, deadline). Values are truncated and redacted as in query, totalled in values_truncated and values_redacted. Tables without a declared primary key need query instead.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| key | Yes | Every primary key column and its value, e.g. {"id": 4821}. Pass integers beyond 2^53 as strings. | |
| table | Yes | Schema-qualified table name, e.g. public.users |