benthic_discover
Find the smallest signed source, columns, and join paths for a question to enable correct queries without inventing joins.
Instructions
Find the smallest relevant signed source, columns, and join paths for a question.
Use the returned source field verbatim in benthic_query. If join_paths is empty, make separate
benthic_query calls; never invent a join.
One call is normally enough: it returns the best relations together with their columns, and
columns_truncated says when that list is partial. Ask again for more columns only when
columns_truncated is true, by passing detail='full'. A wrong column guess is recoverable rather
than fatal, because benthic_query reports the near-miss signed name.Core access rules:
Call benthic_discover before benthic_query, and pass its source value verbatim.
Use benthic_join only for a signed path returned by discovery; never invent a join.
Partial joins require context_conditions and must be reported as provisional.
Heuristic matches are not exact; keep the returned reliability warning in the answer.
Never derive totals from truncated or incomplete source data.
Call benthic_playbook(dataset) when a question needs domain conventions for that dataset.
Dates in this catalog are ISO-8601; filter with gte/lte rather than string comparison.
Never use a current-only view to answer a historical question.
You have a limited number of turns, so once you have the rows you need you must stop calling tools and write the final answer, because a question left unanswered scores zero even when every call succeeded.
usaspending: Federal award transactions and the recipient entity index.
irs_ng: IRS exempt organization records, including Form 990 details.
samer: SAM entity registrations, the bridge between USAspending and IRS identifiers.
up_cdmaps: Congressional district boundaries, queried through spatial RPCs.
usp_cl: Congressional legislators and executive terms, including historical terms.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| query | No | ||
| detail | No | summary | |
| dataset | No | ||
| relation | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | ||
| warnings | No | ||
| relations | Yes | ||
| join_paths | Yes | ||
| total_matches | Yes | ||
| more_available | Yes |