whodb_erd
Read-onlyIdempotent
Retrieve table relationship metadata from a database schema. Displays columns and foreign key connections to help understand table joins programmatically.
Instructions
Load backend graph metadata for a schema or database.
Best for: Understanding how tables relate before writing joins; inspecting primary/foreign key relationships programmatically. Not recommended for: Query execution. Common mistakes: Expecting row data instead of metadata.
Usage Example:
{
"name": "whodb_erd",
"arguments": {
"connection": "mydb",
"schema": "public"
}
}Returns: Storage units with columns plus normalized relationship edges sourced from backend graph metadata.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connection | Yes | Connection name (optional if only one exists) | |
| schema | No | Schema or database name override |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | ||
| storage_units | Yes | ||
| relationships | Yes | ||
| error | No | ||
| request_id | No |