tilley-mcp-web - Tool Documentation

Read-only documentation page for available MCP tools and parameters.
Tool modules: 20
Total tools: 67
Health: /health
MCP transport: POST / (auth required)
OAuth protected resource: /.well-known/oauth-protected-resource
OpenAI domain challenge: /.well-known/openai-apps-challenge
Public base URL: https://mcp.farmtilley.com
MCP issuer: https://mcp.farmtilley.com
Cognito issuer: https://cognito-idp.us-east-2.amazonaws.com/us-east-2_iunpzkPju
OAuth client ID: 5p178ilbjj3001oi31jlr8pirc

Install skill: SKILLS.md. After sign-in, call agent_skills_get_download_link for tilley-agent-skills.zip.

arc-plc

arc_plc_arc_co_county_yield_override_search

read-only idempotent open-world Search ARC-CO county yield overrides

Search county-level ARC-CO yield overrides (modeling / stress test inputs).

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
state_name string no Full US state name. MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
county_name string no County name for the chosen state. MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
commodity_name string no DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
type_name string no DATANAC type name. MUST be an exact value from get_lookup_options(lookup=type_name) or the call will fail.
crop_year int? no Crop year (typical filter).
is_active bool no true Active rows only; default true.

arc_plc_program_election_search

read-only idempotent open-world Search ARC/PLC program elections

Search ARC-CO vs. PLC program elections by farm, commodity, crop year, and location.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
id string no Optional row id filter (GUID string).
crop_year int? no Crop year (typical filter).
state_name string no Full US state name. MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
county_name string no County name for the chosen state. MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
commodity_name string no DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
program_category string no FSA program category filter (e.g. arc_plc); DATANAC enumerated where applicable.
is_active bool no true Active rows only; default true.

arc_plc_program_election_select

read-only idempotent open-world Select program elections (full rows)

[User Data] Select ProgramElection rows (full table projection) for advanced use.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
id string no Optional row id filter (GUID string).
crop_year int? no Crop year (typical filter).
state_name string no Full US state name. MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
county_name string no County name for the chosen state. MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
commodity_name string no DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
program_category string no FSA program category filter (e.g. arc_plc); DATANAC enumerated where applicable.
is_active bool no true Active rows only; default true.
arc-plc-calculation

arc_plc_calculate_payments

read-only idempotent open-world Calculate ARC-County and PLC payments (model)

[Calculation] Generic ARC-County (ARC-CO) and PLC payment model: pass crop year, state, county, commodity, program (arc-co or plc), base acres, share, and PLC yield. For ARC-CO when FSA publishes split Irrigated/Non-Irrigated yields, choose one of two approaches: (1) arc_co_practice = "irrigated" or "non-irrigated" to model a single practice, OR (2) historical_irrigation_percentage (HIP, 0–1) to blend both practices by irrigated weight. Counties with a single unsplit practice need neither parameter. Loads ARCCOYields, ARCCOPrices, EffectiveReferencePrices, MarketYearAveragePrices, and PLCPaymentRates from DATANAC/FSA.ARCPLC via the same SMOCI SelectObject path as aip-pass /data (cached in-process by crop year + location + commodity). Does not use ProgramElection, producer_token, or DATANAC-Users. Outputs totalArcCoPayment, totalPlcPayment, totalArcPlcPayment, paymentsByCommodity; guidanceHints note missing FSA rows. Not an FSA official determination.

Name Type Required Default Description
crop_year int yes Marketing / crop year for the scenario (integer).
location_state_name string yes State name for county-level ARC-CO yields. MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
location_county_name string yes County name matching FSA ARC/PLC labels. MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
commodity_name string yes Commodity name matching FSA ARC/PLC labels. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
program_election string yes Program to model: arc-co (ARC-County) or plc (PLC). This is a scenario input only — not read from any database election row.
base_acreage decimal yes Base acres for the scenario (decimal).
share_percent decimal yes Producer share as a decimal fraction (e.g. 1.0 for 100%).
plc_yield decimal yes PLC yield (decimal); used for PLC payment; also carried on the scenario row for ARC-CO.
type_name string no DATANAC type name. MUST be an exact value from get_lookup_options(lookup=type_name) or the call will fail.
program_category string no Optional FSA-style program category label on the synthetic scenario row (often empty).
arc_co_practice string no ARC-CO only: "irrigated" or "non-irrigated" to narrow to one practice when the county FSA publishes a split. Alternatively, omit this and provide historical_irrigation_percentage (HIP) to blend both Irrigated and Non-Irrigated rows by irrigated weight. Omit both to auto-detect (unsplit / single-practice counties). Synonyms: i, irrigated, ni, dry, dryland, non-irrigated.
historical_irrigation_percentage decimal? no When ARC-CO yields include both Irrigated and Non-Irrigated rows, this sets the irrigated blend weight (0–1, i.e. HIP). Providing this value is an alternative to arc_co_practice: both Irrigated and Non-Irrigated practice rows are kept and ARCPLC weights them by this percentage. Pass 1.0 for fully irrigated, 0.0 for fully non-irrigated, or any value in between for a blended scenario. Omit (null) when using arc_co_practice to model a single practice, or when the county publishes only one practice. When the tool narrows to a single Irrigated practice via arc_co_practice, it overrides this to 1.0.
budget

budget_cost_of_production_search

read-only idempotent open-world Search Cost of Production rows

Returns **Cost of Production** rows (one per practice in a given state/county for that year — yield, projected price, reported acreage, projected revenue, production cost). Each row rolls up under an **Enterprise Budget**. Provide `budget_id` (preferred — drills under a known Enterprise Budget) **or** `year` + `state_name` + `county_name` + `commodity_name` (+ optional `type_name` / `practice_name`) for a dimensional query. Use the returned `id` as `budget_county_practice_id` for `budget_line_item_search` or `budget_line_item_detail_search`.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
budget_id string no **Enterprise Budget** id (GUID) — the year-level budget that contains all counties and crops. Returned as `id` from `budget_enterprise_budget_search`; pass it here as `budget_id` to scope a Cost of Production search or to anchor a new Cost of Production row.
year int? no Crop year (e.g. 2026). Allowed range: 2000–2100.
status BudgetStatus? no **Enterprise Budget** status: "active" or "draft". Only `active` Enterprise Budgets feed into other modules (insurance, marketing, ARC/PLC).
state_name string no Full US state name (budget county-practice). MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
county_name string no County name (budget county-practice). MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
commodity_name string no DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
type_name string no DATANAC type name. MUST be an exact value from get_lookup_options(lookup=type_name) or the call will fail.
practice_name string no DATANAC practice name. MUST be an exact value from get_lookup_options(lookup=practice_name) or the call will fail.
is_active bool no true Soft-delete flag. Defaults to true (live rows). Pass false to include archived rows.

budget_cost_of_production_update

open-world Create or update a Cost of Production row

Creates or updates one Cost of Production row (yield, projected price, reported acreage, geography) under an Enterprise Budget. Requires budget_id from budget_enterprise_budget_search. To create, call util_new_guid and pass that value as id. To update, pass the id from budget_cost_of_production_search.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
budget_id string no "" **Enterprise Budget** id (GUID) — the year-level budget that contains all counties and crops. Returned as `id` from `budget_enterprise_budget_search`; pass it here as `budget_id` to scope a Cost of Production search or to anchor a new Cost of Production row.
state_name string no Full US state name (budget county-practice). MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
county_name string no County name (budget county-practice). MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
commodity_name string no DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
type_name string no DATANAC type name. MUST be an exact value from get_lookup_options(lookup=type_name) or the call will fail.
practice_name string no DATANAC practice name. MUST be an exact value from get_lookup_options(lookup=practice_name) or the call will fail.
is_active bool no true Soft-delete flag. Defaults to true (live rows). Pass false to include archived rows.
id string no Row id (GUID). For an **update**, pass the existing row's `id` from the corresponding Search tool. For an **insert**, obtain a fresh value by calling `util_new_guid` first — do not invent your own GUID, and do not reuse an existing row's id.
reported_acreage double? no Reported acreage for this **Cost of Production** row. Units are acres; meaningful bounds vary by commodity, so no fixed range is enforced at the schema layer.
yield double? no Projected or approved yield for this **Cost of Production** row. Units depend on commodity (bushels/acre, hundredweight/acre, lbs/head). Server logic forces yield = 1.0 for livestock; for crops, pass the per-acre yield. No fixed range enforced at the schema layer.
projected_price double? no Projected price for this **Cost of Production** row, in $/unit (matching the yield unit). No fixed range enforced at the schema layer.

budget_enterprise_budget_search

read-only idempotent open-world Search Enterprise Budgets

Returns **Enterprise Budget** rows (the year-level header containing all counties and crops). Typical filters: `year`, `status`, `id`. Only `status="active"` Enterprise Budgets feed into other modules. Use the returned `id` as `budget_id` for `budget_cost_of_production_search` to drill into per-practice rows.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
year int? no Crop year (e.g. 2026). Allowed range: 2000–2100.
status BudgetStatus? no **Enterprise Budget** status: "active" or "draft". Only `active` Enterprise Budgets feed into other modules (insurance, marketing, ARC/PLC).
is_active bool no true Soft-delete flag. Defaults to true (live rows). Pass false to include archived rows.
id string no **Enterprise Budget** id (GUID) — the year-level budget that contains all counties and crops. Returned as `id` from `budget_enterprise_budget_search`; pass it here as `budget_id` to scope a Cost of Production search or to anchor a new Cost of Production row.

budget_enterprise_budget_update

open-world Create or update an Enterprise Budget header

Creates or updates an Enterprise Budget header: name, year, and status. To create, call util_new_guid and pass that value as id. To update, pass the id from budget_enterprise_budget_search. Does not change Cost of Production rows or line items.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
name string no "" **Enterprise Budget** display name (e.g. "2026 Crop Plan"). Max 50 characters.
year int no 0 Crop year (e.g. 2026). Allowed range: 2000–2100.
status BudgetStatus? no **Enterprise Budget** status: "active" or "draft". Only `active` Enterprise Budgets feed into other modules (insurance, marketing, ARC/PLC).
is_active bool no true Soft-delete flag. Defaults to true (live rows). Pass false to include archived rows.
id string no Row id (GUID). For an **update**, pass the existing row's `id` from the corresponding Search tool. For an **insert**, obtain a fresh value by calling `util_new_guid` first — do not invent your own GUID, and do not reuse an existing row's id.

budget_line_item_detail_search

read-only idempotent open-world Search Budget Line Item Details

Returns **Budget Line Item Details** under a **Cost of Production** row — the inputs/components inside each line item (e.g. "Ammonia", "Nitrogen" under the "Chemicals" line item). Requires `budget_county_practice_id`. Optional `line_item_name` filter narrows to details under one parent line item.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
budget_county_practice_id string no "" **Cost of Production** id (GUID) — one practice row (state/county/commodity/type/practice) under an Enterprise Budget. Returned as `id` from `budget_cost_of_production_search`; pass it here as `budget_county_practice_id` to drill into Budget Line Items or Budget Line Item Details, or to anchor an upsert.
line_item_name string no Parent **Budget Line Item** name to filter Budget Line Item Details by (e.g. "Chemicals" returns details like "Ammonia", "Nitrogen"). Max 50 characters. Omit to return all details under the Cost of Production row.
is_active bool no true Soft-delete flag. Defaults to true (live rows). Pass false to include archived rows.

budget_line_item_detail_update

Create or update Budget Line Item Details

Use this when the user wants to save the inputs inside a cost category, such as Ammonia or Nitrogen under Chemicals. Creates or updates only the Budget Line Item Details in budget_county_practice_schedule_items_json, and overwrites the fields of those included rows. Requires budget_county_practice_id from budget_cost_of_production_search. Each detail line_item_name must already exist as a Budget Line Item name on that same row. For a new detail, call util_new_guid and set that value as the item id. To change an existing detail, pass its id from budget_line_item_detail_search. Details omitted from the array are left unchanged. An empty array changes nothing. Sending a new id inserts another row, so retry with the same ids. Does not create or rename the parent category. Use budget_line_item_update for category totals. Returns how many rows were affected. Writes only this producer's private budget.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
budget_county_practice_id string no "" **Cost of Production** id (GUID) — one practice row (state/county/commodity/type/practice) under an Enterprise Budget. Returned as `id` from `budget_cost_of_production_search`; pass it here as `budget_county_practice_id` to drill into Budget Line Items or Budget Line Item Details, or to anchor an upsert.
budget_county_practice_schedule_items_json string no [] JSON array of Budget Line Item Details to create or update on this Cost of Production row. A detail is one input inside a parent line item, such as Ammonia under Chemicals. Only objects in this array are written, and their fields are overwritten. Objects left out stay as they are. [] writes nothing. Each object: id (GUID; new row: call util_new_guid first; existing row: id from budget_line_item_detail_search), category (string), ordinal (integer), line_item_name (must equal the name of a Budget Line Item already saved on this same Cost of Production row), name (the input), quantity (number), unit_of_measure (string), case_quantity (number), case_unit_of_measure (string), unit_value (number), value (number), is_active (boolean), input_share_percent (number).

budget_line_item_search

read-only idempotent open-world Search Budget Line Items

Returns **Budget Line Items** (e.g. "Seed", "Chemicals", "Rent") under one **Cost of Production** row. Requires `budget_county_practice_id` (the Cost of Production id, returned as `id` from `budget_cost_of_production_search`).

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
budget_county_practice_id string no "" **Cost of Production** id (GUID) — one practice row (state/county/commodity/type/practice) under an Enterprise Budget. Returned as `id` from `budget_cost_of_production_search`; pass it here as `budget_county_practice_id` to drill into Budget Line Items or Budget Line Item Details, or to anchor an upsert.
budget_id string no **Enterprise Budget** id (GUID) — the year-level budget that contains all counties and crops. Returned as `id` from `budget_enterprise_budget_search`; pass it here as `budget_id` to scope a Cost of Production search or to anchor a new Cost of Production row.
is_active bool no true Soft-delete flag. Defaults to true (live rows). Pass false to include archived rows.

budget_line_item_update

Create or update Budget Line Items

Use this when the user wants to save cost categories on one Cost of Production row, such as Seed, Chemicals, or Cash Rent. Creates or updates only the Budget Line Items in budget_county_practice_line_items_json, and overwrites the fields of those included rows. Requires budget_county_practice_id from budget_cost_of_production_search. For a new line item, call util_new_guid and set that value as the item id. To change an existing line item, pass its id from budget_line_item_search. Line items omitted from the array are left unchanged. An empty array changes nothing. Sending a new id inserts another row, so retry with the same ids. Does not save the inputs inside a category. Use budget_line_item_detail_update for those. Returns how many rows were affected. Writes only this producer's private budget.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
budget_county_practice_id string no "" **Cost of Production** id (GUID) — one practice row (state/county/commodity/type/practice) under an Enterprise Budget. Returned as `id` from `budget_cost_of_production_search`; pass it here as `budget_county_practice_id` to drill into Budget Line Items or Budget Line Item Details, or to anchor an upsert.
budget_county_practice_line_items_json string no [] JSON array of Budget Line Items to create or update on this Cost of Production row. A line item is one cost category, such as Seed, Chemicals, or Cash Rent. Only objects in this array are written, and their fields are overwritten. Objects left out stay as they are. [] writes nothing. Each object: id (GUID; new row: call util_new_guid first; existing row: id from budget_line_item_search), category (direct or indirect), ordinal (integer), name (category name), value (number, cost per acre; ignored when detail rows already exist for that name, because the server sums those details), is_active (boolean), input_share_percent (number), unit_of_measure (string), case_quantity (number), case_unit_of_measure (string), unit_value (number), quantity (number).
Code Interpreter

code_interpreter

read-only open-world Code interpreter (hosted)

Runs the hosted code interpreter (Responses API with built-in code_interpreter; Python in the provider sandbox). Put the task or instructions in input. Optional: instructions, model, tool_choice, memory_limit (1g|4g|16g|64g), file_ids (comma-separated), container_id (reuse an existing container).

Name Type Required Default Description
input string yes Primary user/task text (maps to Responses API input).
instructions string no Optional system/developer instructions.
model string no Optional model id (defaults to config key OpenAI:ResponsesModel, else gpt-4.1-mini).
tool_choice string no Optional tool_choice JSON string for the request body.
memory_limit string no Container memory_limit for auto container: 1g, 4g, 16g, or 64g.
file_ids string no Comma-separated file ids for the hosted interpreter container.
container_id string no Container id to reuse (overrides auto container object).
Datanac

scn_soybean_risk_calculator

read-only idempotent open-world Soybean cyst nematode risk

Do not call this tool until every required parameter has a concrete value—never invoke with placeholders, omissions, or guesses; collect missing values from the user or from prerequisite tool calls first. Calculates Soybean Cyst Nematode (SCN) yield loss percentage, yield loss in bu/acre, and profit loss per acre. Conversation flow (do not stall on sand/pH—the user picks a formation; you fetch sand/pH from SSURGO): 1) First user message: establish state and county and begin collecting yield_potential, soybean_price, and scn_egg_count as needed. Do NOT call soil_composition_lookup on that opening message only—wait until county is confirmed and you are on a follow-up turn. 2) Early—on your next reply once state and county are known (second interaction onward)—you MUST call soil_composition_lookup WITHOUT map_unit_name, SHOW the returned formation (map unit) names to the user in full, and PROMPT them to choose one. Do not treat formations as optional fine print, do not wait until yield/price/egg count are all collected before this lookup, and do not repeatedly offer to list formations without actually calling the tool and displaying results. 3) Continue collecting any still-missing yield_potential, soybean_price, or scn_egg_count across turns as needed. 4) After the user picks a formation, call soil_composition_lookup WITH that map_unit_name to obtain Avg_sand and Avg_soil_ph. 5) Call this tool only when every required argument is ready. Do NOT prompt the user for female_index — the state-average default is applied automatically.

Name Type Required Default Description
scn_egg_count decimal yes Required. SCN eggs per 100 cc soil from a laboratory soil test. Typical risk bands: low < 2,000; moderate 2,000–10,000; high > 10,000 eggs/100cc.
state_name string yes Full US state name. MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
sand_percentage decimal yes Required. Percent sand in the soil (0–100). Normally supply Avg_sand from soil_composition_lookup after the user picks a map unit (formation)—do not ask the user for sand % unless they volunteer measured values. Higher sand increases SCN risk.
soil_ph decimal yes Required. Soil pH (typically 4.5–8.5). Normally supply Avg_soil_ph from soil_composition_lookup after the user picks a formation—do not ask the user for pH unless they volunteer measured values. SCN risk increases as pH rises above 7.
yield_potential decimal yes Required. Expected soybean yield in bu/acre for this field under non-SCN conditions (yield potential / APH).
soybean_price decimal yes Required. Local soybean cash price in $/bu used to calculate profit loss per acre.
female_index decimal? no Do NOT prompt the user for this value. The calculator automatically applies a published state-average when omitted (IL=30, IN=43, IA=45, MO=56, MI=40, NE=35, OH=33, SD=22, WI=23, etc.). Only supply this if the user explicitly volunteers a female index from their own SCN resistance test (0–100 scale; lower = better resistance).

soil_composition_lookup

read-only idempotent open-world SSURGO soil composition

Do not call this tool until every required parameter has a concrete value—never invoke with placeholders, omissions, or guesses; collect missing values from the user or from prerequisite tool calls first. GSSURGO soil composition lookup — filter by state_name, county_name, and optional map_unit_name. Required inputs for every call: state_name and county_name. After county is known, call WITHOUT map_unit_name early in the thread (not on the user's very first message—see SCN tool flow): list formations, display them prominently, and ask the user to select one for sand/pH. Then call again WITH that exact map_unit_name to get Avg_sand and Avg_soil_ph for SCN_Soybean_Risk_Calculator.

Name Type Required Default Description
state_name string yes Full US state name. MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
county_name string yes County name for the chosen state. MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
map_unit_name string no Optional GSSURGO map unit name (formation). Omit on the first call to list all available formations for the county. Supply the exact name the user chose to retrieve Avg_sand and Avg_soil_ph for that formation.
documents

agent_skills_get_download_link

read-only idempotent open-world Get agent skills download link

Use when the user asks for the Tilley agent skills zip, how to install or update Tilley skills, or to check whether installed skills are current. Signed-in callers only. Returns a download URL for tilley-agent-skills.zip only, plus that object's S3 last_modified. No other files. Compare last_modified to each installed tilley-* skill's version stamp. If the zip is newer, download, unzip, and reinstall. The zip is not public. Do not pass the url to npx skills add.

Name Type Required Default Description
file_name string no File name to link. Only tilley-agent-skills.zip is allowed for now. Omit to get that file.

document_content_search

read-only idempotent open-world Search document content memory

Search indexed document content via RG Memory/Item and return raw payload.

Name Type Required Default Description
search_text string yes Required search phrase used for semantic content search in Documents memory.
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
memory_name string no Optional memory name override (defaults to Documents).
filter_document_id string no Optional document id filter to limit content search to one document GUID.
is_active bool no true Active rows only; default true.

document_dictionary_search

read-only idempotent open-world Search document dictionary catalog

Use this when the user wants catalog entries extracted from uploaded financial documents, not the file list from document_search. Returns dictionary rows for this producer: section, module, object, and the keys that point back at a document. Optional filters: year, section, module, and dictionary_object. There is no document_id argument. Use document_document_get_content to read one file. Read only. Does not change data.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
year int? no Crop or tax year filter (matches FinancialDocument.year and dictionary search).
section string no Optional DocumentDictionary.section filter (SMOCI-style section string).
module string no Optional DocumentDictionary.module filter (SMOCI-style module string).
dictionary_object string no Optional DocumentDictionary.object filter (SMOCI-style object name string).
is_active bool no true Active rows only; default true.

document_document_get_content

read-only idempotent open-world Get document content payload

[User Data] Return the raw text payload resolved from RG contentUrl for a financial document.

Name Type Required Default Description
id string yes Financial document id (GUID string; required). This is FinancialDocument.id — the uploaded file row.
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
is_active bool no true Active rows only; default true.

document_file_get_link

read-only idempotent open-world Get document open link

[User Data] Return a presigned document URL for viewing/downloading the original uploaded file.

Name Type Required Default Description
id string yes Financial document id (GUID string; required). This is FinancialDocument.id — the uploaded file row.
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
is_active bool no true Active rows only; default true.

document_search

read-only idempotent open-world List financial document files

List financial document file rows (file name, type, year, ids) for producer/agent scope.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
year int? no Crop or tax year filter (matches FinancialDocument.year and dictionary search).
id string no Optional FinancialDocument.id filter (GUID string).
document_type_name string no Optional document_type_name filter (DATANAC enumerated financial form type).
is_active bool no true Active rows only; default true.
emails

emails_attachment_file_get_link

read-only idempotent open-world Download ToTilley email attachment file

Get a presigned download URL for a ToTilley **email attachment** file. Pass `id` from `emails_search` (attachment row where `document_url` is set). Files are stored at S3 key `producer_token/file_document_id` by totilley-daemon — not the Document vault / RG chunk pipeline. Returns `download_url` (expires ~1 day) and `document_name` for Content-Disposition.

Name Type Required Default Description
id string yes DocumentSourceEntry id (GUID) from emails_search for an attachment row (where document_url is set). Same value as document_url / file id in ToTilley daemon uploads.
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
is_approved bool? no When true (default), return only approved inbox rows. Set false to include unapproved rows, or pass null via API to omit the filter.

emails_search

read-only idempotent open-world Search emails and attachments (ToTilley inbox)

Search **Emails** (alias: **Email Attachments**) — ToTilley inbox rows for a producer. Each row is either the email body (content-only; empty document_url) or an attachment (document_name = file name). The `content` field holds the email body text (stored as notes). When `document_url` is present, download the raw attachment with `emails_attachment_file_get_link` (ToTilley S3 path). Do not use `document_file_get_link` for these rows — that targets the RG FinancialDocument pipeline.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
dateRangeStart DateTime? no Optional inclusive start calendar date for received-date filter (matches DocumentSourceEntry.CreateDate by day; time zone / time-of-day is ignored).
dateRangeEnd DateTime? no Optional inclusive end calendar date for received-date filter (matches DocumentSourceEntry.CreateDate by day; time zone / time-of-day is ignored).
is_approved bool no true When true (default), return only approved inbox rows. Set false to include unapproved rows, or pass null via API to omit the filter.
id string no Optional DocumentSourceEntry id (GUID) to fetch a single inbox row.
document_source_id string no Optional DocumentSource id (GUID) filter for a specific ToTilley address/source.
farm

farms_producer_farm_base_acres_search

read-only idempotent open-world Search base acres & PLC yields

Use this when the user asks for Farm Bill base acres or PLC payment yield. Returns base-acre rows: farm, commodity, type, crop year, base acres, and payment yield. Optional filters: producer_farm_id, commodity_name, type_name, crop_year, and location_state_name with location_county_name. Does not return planted acres or field crops. Read only. Does not change data.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
producer_farm_id string no Farm PK filter.
commodity_name string no DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
type_name string no DATANAC type name. MUST be an exact value from get_lookup_options(lookup=type_name) or the call will fail.
crop_year int? no Crop year filter.
location_state_name string no Full US state name. MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
location_county_name string no County name for the chosen state. MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
is_active bool no true Active rows only; default true.

farms_producer_farm_field_crop_history_search

read-only idempotent open-world Search crop yield history (APH)

Use this when the user asks for historical yields or actual production history (APH). Returns crop-history rows by year, commodity, practice, and yield type. Optional filters: producer_farm_id, producer_farm_field_id, commodity_name, type_name, practice_name, crop_year, and yield_type_code. Does not return the current planted-crop row. Read only. Does not change data.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
producer_farm_id string no Farm PK filter.
producer_farm_field_id string no Field PK filter.
commodity_name string no DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
type_name string no DATANAC type name. MUST be an exact value from get_lookup_options(lookup=type_name) or the call will fail.
practice_name string no DATANAC practice name. MUST be an exact value from get_lookup_options(lookup=practice_name) or the call will fail.
crop_year int? no Crop year filter.
yield_type_code string no Yield type code (e.g. A = Actual).
is_active bool no true Active rows only; default true.

farms_producer_farm_field_crop_search

read-only idempotent open-world Search field crops

Use this when the user wants planted crops: farm, tract or field, commodity, type, practice, acres, and yield. Pass crop_year. A commodity_name or producer_farm_field_id filter with no crop_year matches nothing. Drill into one field with producer_farm_field_id from farms_producer_farm_field_search, or explore by commodity_name and location_state_name with location_county_name. type_name and practice_name are optional. An agent can omit producer_token to search every producer in their book. Does not return yield history. Read only. Does not change data.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
crop_year int? no Crop year filter.
producer_farm_id string no Farm PK filter.
producer_farm_field_id string no Field PK filter.
commodity_name string no DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
type_name string no DATANAC type name. MUST be an exact value from get_lookup_options(lookup=type_name) or the call will fail.
practice_name string no DATANAC practice name. MUST be an exact value from get_lookup_options(lookup=practice_name) or the call will fail.
location_state_name string no Full US state name. MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
location_county_name string no County name for the chosen state. MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
is_active bool no true Active rows only; default true.

farms_producer_farm_field_search

read-only idempotent open-world Search farm fields, tracts

Use this when the user wants tracts or fields on a farm: field name, tract id, acreage, and location. Pass producer_farm_id from farms_producer_farm_search. The row id is producer_farm_field_id for crop search and yield-history search. Optional crop_year makes acreage that season. Omitting the year can mix seasons. Does not return planted crops. Read only. Does not change data.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
producer_farm_id string no Farm PK from ProducerFarm search.
crop_year int? no Crop year filter.
location_state_name string no Full US state name. MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
location_county_name string no County name for the chosen state. MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
is_active bool no true Active rows only; default true.

farms_producer_farm_search

read-only idempotent open-world Search farms

Use this when the user wants the farm list: farm name, FSA farm number, location, crop year, and reported and base acre rollups. The row id is producer_farm_id. Pass it to field search and base-acre search. Agents take producer_token from client_search. Optional crop_year limits the list to farms with crops or base acres that year. Pair location_state_name with location_county_name. Does not return fields, planted crops, or base-acre rows. Read only. Does not change data.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
crop_year int? no Crop year (typical filter).
location_state_name string no Full US state name. MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
location_county_name string no County name for the chosen state. MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
is_active bool no true Active rows only; default true.
financial-interview

financial_interview_begin

open-world Begin financial interview

Start a financial interview wizard session; returns session metadata and an empty bundle template.

Name Type Required Default Description
year int no 0 Crop / statement year for the interview (defaults to current calendar year if omitted).

financial_interview_complete

open-world Complete financial interview

Finish the interview: returns the final JSON bundle for the chat and removes server-side session state.

Name Type Required Default Description
session_id string yes Interview session id returned by financial_interview_begin; required for financial_interview_save and financial_interview_complete.

financial_interview_save

open-world Save financial interview step

Saves progress for a financial interview session. Pass session_id. To replace the account rows on one step, pass step_category_key and accounts_json. That overwrites that step's prior accounts. Returns the interview bundle so far.

Name Type Required Default Description
session_id string yes Interview session id returned by financial_interview_begin; required for financial_interview_save and financial_interview_complete.
active_step_index int? no 0-based wizard step index to treat as current (optional; defaults to last explicit value or 0).
step_category_key string no Wizard step category_key to update (e.g. schedule_financial_statement_accounts_liquid). Must match a step from Begin.
accounts_json string no JSON array of account objects for the given step_category_key (replaces existing rows for that step).
generic-smoci

datanac_producer_farm_crop_with_history_search

read-only idempotent open-world Search farm crop with yield history

Search joined producer farm crop + history (DATANAC / AIP.PASS).

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
crop_year int? no Crop year filter.
producer_farm_id string no Farm PK filter.
producer_farm_field_id string no Field PK filter.
location_state_name string no Full US state name. MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
location_county_name string no County name for the chosen state. MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
commodity_name string no DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
type_name string no DATANAC type name. MUST be an exact value from get_lookup_options(lookup=type_name) or the call will fail.
practice_name string no DATANAC practice name. MUST be an exact value from get_lookup_options(lookup=practice_name) or the call will fail.
is_active bool no true Active rows only; default true.
insurance

insurance_insurance_offer_select

read-only idempotent open-world Select RMA insurance offers

[System Data — RMA actuarial] Select available insurance plans/offers for a county and commodity year.

Name Type Required Default Description
reinsurance_year int yes RMA reinsurance year (crop year for insurance offers; required).
commodity_name string yes DATANAC commodity name (required). MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
type_name string no DATANAC type name. MUST be an exact value from get_lookup_options(lookup=type_name) or the call will fail.
practice_name string no DATANAC practice name. MUST be an exact value from get_lookup_options(lookup=practice_name) or the call will fail.
state_name string no Full US state name. MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
county_name string no "" County name for the chosen state. MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.

insurance_insurance_plan_claim_search

read-only idempotent open-world Search insurance plan claims

Claim / indemnity rows keyed by `insurance_plan_id` (from `insurance_insurance_plan_search`). Pin with `reinsurance_year`; optional `commodity_name`, `location_state_name`, `location_county_name`. Avoid stacking filters unless the user wants a tight slice.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
insurance_plan_id string no Insurance plan id (GUID string; optional filter on claims).
reinsurance_year int? no Reinsurance year filter on plans or claims (int).
commodity_name string no DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
location_state_name string no Full US state name. MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
location_county_name string no County name for the chosen state. MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
is_active bool no true Active rows only; default true.

insurance_insurance_plan_search

read-only idempotent open-world Search insurance plans

One producer's insurance plan rows (plan, coverage, location, commodity, type, practice, `insurance_scenario_id`). Needs `producer_token` plus `crop_year` or `insurance_scenario_id` (from `insurance_insurance_scenario_select`). Location filters: all five of state/county/commodity/type/practice, or none. Without scenario id, use `status`=active for coverage in force (else drafts mix in). Only Active Enterprise Budget practices that year.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
insurance_scenario_id string no Insurance scenario id from `insurance_insurance_scenario_select` (GUID). Limits to that scenario's plans; `crop_year` optional then.
crop_year int? no Crop year. Required unless `insurance_scenario_id` is passed.
state_name string no Full US state name (budget county-practice). MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
county_name string no County name (budget county-practice). MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
commodity_name string no DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
type_name string no DATANAC type name. MUST be an exact value from get_lookup_options(lookup=type_name) or the call will fail.
practice_name string no DATANAC practice name. MUST be an exact value from get_lookup_options(lookup=practice_name) or the call will fail.
status BudgetStatus? no Plan status filter (string).
is_active bool no true Active rows only; default true.

insurance_insurance_scenario_select

read-only idempotent open-world Select insurance scenarios

[User Data] Select insurance scenario headers (name, crop year, status) via SMOCI SelectObject.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
id string no Insurance scenario row id (GUID string; optional filter).
crop_year int? no Crop year (typical filter).
status BudgetStatus? no Insurance scenario status filter (string).
is_active bool no true Active rows only; default true.

insurance_stress_test_result_search

read-only idempotent open-world Search stress test results

Returns pre-computed stress-test grid cells (yield/price scenarios) for an insurance scenario. Always pass `insurance_scenario_id` first to scope the grid. Optionally add `commodity_name`, `state_name`, and `county_name` only if the result volume is noisy.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
insurance_scenario_id string no "" Insurance scenario id (GUID string; required) — scopes stress-test grid results.
commodity_name string no DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
state_name string no Full US state name (budget county-practice). MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
county_name string no County name (budget county-practice). MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
is_active bool no true Active rows only; default true.
Lookups

get_lookup_options

read-only idempotent DATANAC lookup option values

Returns the exact allowed string values for DATANAC filters that used to be large JSON-schema enums. Call this BEFORE any tool that takes commodity_name, type_name, practice_name, state_name, or county_name. Those tools WILL NOT work with informal/guessed labels — pass a value from this list verbatim. lookup: commodity_name | type_name | practice_name | state_name | county_name. county_name requires state_name (full state name from lookup=state_name).

Name Type Required Default Description
lookup string yes Which list: commodity_name, type_name, practice_name, state_name, or county_name.
state_name string no Required when lookup=county_name: full US state name from get_lookup_options(lookup=state_name).
marketing

marketing_buyer_search

read-only idempotent open-world Search grain buyers

Search the producer's grain buyers (elevators, merchants, processors).

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
is_active bool no true Active rows only; default true.

marketing_crop_profile_search

read-only idempotent open-world Search marketing crop profiles

Search CropProfile (marketing crop profiles).

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
commodity_name string no DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
year int? no Profile year.
is_active bool no true Active rows only; default true.

marketing_crop_profile_select

read-only idempotent open-world Select crop profiles (full rows)

Use this when the user needs every stored column of a marketing crop profile, not the shorter list from marketing_crop_profile_search. Returns full crop-profile rows: commodity, year, production, and marketing-goal units. Optional filters: commodity_name and year. Does not return grain sales or contracts. Read only. Does not change data.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
commodity_name string no DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
year int? no Profile year.
is_active bool no true Active rows only; default true.

marketing_market_transaction_history_search

read-only idempotent open-world Search market transaction history

[User Data] Imported brokerage trades with producer names. `is_posted` omitted/false: Transaction Import queue; true: posted. Agent whole book: omit `producer_token`.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
year int? no Marketing / transaction history year filter (int).
is_posted bool? no Whether brokerage transactions are posted (optional).
commodity_name string no DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
is_active bool no true Active rows only; default true.

marketing_position_summary_sales_by_category_search

read-only idempotent open-world Search sales by category

[User Data] One producer's sales totals by year, commodity, and category for `year`. Needs `producer_token`. Agent whole book: `marketing_position_summary_search` (`amount_cash`, `amount_basis_only`, `amount_hta`).

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
year int no 0 Marketing / position-summary year (required, int).
commodity_name string no DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
is_active bool no true Active rows only; default true.

marketing_position_summary_search

read-only idempotent open-world Search position summary

Position per producer and commodity for marketing `year` (required): Active Enterprise Budget production, marketing goal, sold by category (cash/basis/HTA), posted hedges (futures/options/OTC), insured guarantee. One producer: pass `producer_token`. Agent whole book: omit it (includes agency mates; broker Risk Summary).

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
year int no 0 Marketing / position-summary year (required, int).
commodity_name string no DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
is_active bool no true Active rows only; default true.

marketing_sale_search

read-only idempotent open-world Search grain sales (one producer or whole book)

[User Data] Grain sales/contracts with producer name and brokerage account, oldest first. One producer: pass `producer_token`. Agent whole book: omit it (your UserGrant clients only, not agency mates); add `crop_year`. Optional `contract_number`.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
crop_year int? no Crop year filter.
contract_number string no Exact contract number filter (optional).
is_active bool no true Active rows only; default true.

marketing_sale_select

read-only idempotent open-world Select grain sales

[User Data] One producer's grain sales/contracts (cash, HTA, basis, futures, OTC); filter by `crop_year`, `commodity_name`, `category`, or `id`. Needs `producer_token`. Agent whole book: `marketing_sale_search`.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
crop_year int? no Crop year filter.
commodity_name string no DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
category string no Sale contract category filter (e.g. cash, HTA, basis, futures, OTC).
is_active bool no true Active rows only; default true.
id string no Sale row id (GUID string; optional filter).

marketing_user_transaction_history_search

read-only idempotent open-world Search user transaction history

One producer's brokerage futures/options ledger (posted by default). Needs `producer_token`.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
year int? no Marketing / transaction history year filter (int).
is_posted bool? no Whether brokerage transactions are posted (optional).
commodity_name string no DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
is_active bool no true Active rows only; default true.
Markets

futures

read-only idempotent open-world Futures & options quotes

Futures / options reference data via DATANAC Markets stored proc Futures_Search (symbol_year maps to reinsurance_year).

Name Type Required Default Description
symbol_year int yes Calendar year for contract / reinsurance year (nonce: symbol_year).
commodity_name string yes DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
location_state_name string yes Full US state name. MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
location_county_name string yes County name for the chosen state. MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
type_name string no DATANAC type name. MUST be an exact value from get_lookup_options(lookup=type_name) or the call will fail.
practice_name string no DATANAC practice name. MUST be an exact value from get_lookup_options(lookup=practice_name) or the call will fail.
member

admin_member_search

read-only idempotent open-world Search members / billing (admin)

Admin-only: search member / billing profile rows via Users API MemberController. Requires a real filter: `last_name`, `business_name`, `id`, `producer_token`, or `agent_token`. `is_active` alone is REJECTED (wildcard dump takes down the site). Phonetic/soundex on name fields. No `first_name` filter — for two-part names try both orderings as `last_name`, or use AdHoc.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
id string no Member id (GUID string); optional real filter when searching member rows.
last_name string no Member last_name filter (min 2 chars). Phonetic/soundex search. Use for name lookups (e.g. Williams). Do not call with only is_active.
business_name string no Member business_name / agency filter (min 2 chars). Phonetic/soundex search. Do not call with only is_active.
is_active bool no true Active rows only; default true.

client_search

read-only idempotent open-world Search agent clients (UserGrant)

Lists an agent/broker's clients: producers linked by UserGrant (`producer_description`, `producer_token`, account number). Signed-in agent: call with no args. Pass a row's `producer_token` into producer-scoped tools. Error asking for `agent_token` means you are not signed in as an agent (admins must pass it).

Name Type Required Default Description
agent_token string no Leave unset when signed in as an agent or broker: your own agent GUID is used and any other value is rejected. Admins must pass the agent's GUID. Never send "".

member_select

read-only idempotent open-world Select member (full row; current user context)

Select a Member row via SelectObject (DATANAC/Users/Member). Required: `id` (member GUID). Optional: `producer_token` / `agent_token` / `is_active`. Broad / is_active-only searches are rejected. SQL command timeout: 30s (admin) / 10s (otherwise).

Name Type Required Default Description
id string yes Member id (GUID). Required for member_select — pass the member GUID. Do not call with only is_active.
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
is_active bool no true Active rows only; default true.

member_subscription_search

read-only idempotent open-world Search member subscription status

[User Data] Look up subscription / customer status in Central Payments for a member id.

Name Type Required Default Description
producer_token string no Producer GUID that scopes the rows. Signed-in producer: omit (session supplies it). Agent/broker: pass a producer's `producer_token` from `client_search` (UserGrant client); omit only on whole-book tools. Admin: pass explicitly. Omit or JSON null; never "".
agent_token string no Leave unset. A signed-in agent's own agent GUID comes from their sign-in. Admins acting for an agent pass that agent's GUID. Never send "".
id string no "" Member / customer id (GUID string) used by Central Payments subscription lookup (maps to API body field id).
is_active bool no true Active rows only; default true.
RMA Actuarial Data

insurance_dates

read-only idempotent open-world RMA insurance dates graph

Date_ExportObjectGraph on DATANAC-RMA — sales closing / planting dates JSON for county and crop. The stored procedure uses reinsurance year, commodity, state, and county only. Optional type/practice/plan arguments are forwarded for vault authorization metadata only—they do not change the proc inputs.

Name Type Required Default Description
reinsurance_year JsonElement yes Reinsurance / commodity year (JSON number or numeric string, e.g. 2024 or "2024").
commodity_name string yes DATANAC commodity name (required). MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
state_name string yes Full US state name. MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
county_name string yes County name for the chosen state. MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
type_name string no Optional plain-text filter label for vault authorization only (not passed to Date_ExportObjectGraph).
practice_name string no Optional plain-text filter label for vault authorization only (not passed to Date_ExportObjectGraph).
insurance_plan_name string no Optional plain-text filter label for vault authorization only (not passed to Date_ExportObjectGraph).

rma_adm_insurance_coverage_levels

read-only idempotent open-world RMA ADM coverage levels

Area coverage levels by insurance offer (uvw_ix_AreaCoverageLevelByInsuranceOffer). Filters by year, commodity, location, and optional type/practice/plan match LINQ predicates on the view.

Name Type Required Default Description
reinsurance_year JsonElement yes Reinsurance year (JSON number or numeric string).
commodity_name string yes DATANAC commodity name (required). MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
state_name string yes Full US state name. MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
county_name string yes County name for the chosen state. MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
type_name string no DATANAC type name. MUST be an exact value from get_lookup_options(lookup=type_name) or the call will fail.
practice_name string no DATANAC practice name. MUST be an exact value from get_lookup_options(lookup=practice_name) or the call will fail.
insurance_plan_name string no Insurance plan name (optional exact match).

rma_adm_insurance_offers

read-only idempotent open-world RMA ADM insurance offers

InsuranceOffer_Search — commodity / type / practice / plan rows for county and year.

Name Type Required Default Description
reinsurance_year JsonElement yes Reinsurance year (JSON number or numeric string).
commodity_name string yes DATANAC commodity name (required). MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
state_name string yes Full US state name. MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
county_name string yes County name for the chosen state. MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
practice_name string no DATANAC practice name. MUST be an exact value from get_lookup_options(lookup=practice_name) or the call will fail.
insurance_plan_name string no Insurance plan name (optional exact match).
RMA Summary of Business

rma_summary_of_business

read-only idempotent open-world RMA SOB all years

SummaryOfBusinessByInsurancePlan_Search — SOB across years (commodity_year null) by county / crop / practice.

Name Type Required Default Description
state_name string yes Full US state name. MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
county_name string yes County name for the chosen state. MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
commodity_name string yes DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
type_name string yes DATANAC type name. MUST be an exact value from get_lookup_options(lookup=type_name) or the call will fail.
practice_name string yes DATANAC practice name. MUST be an exact value from get_lookup_options(lookup=practice_name) or the call will fail.

rma_summary_of_business_by_year

read-only idempotent open-world RMA SOB by year

SummaryOfBusiness_Search — SOB for one commodity year (crop / county / practice filters).

Name Type Required Default Description
commodity_year int yes Commodity (crop) year.
state_name string yes Full US state name. MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
county_name string yes County name for the chosen state. MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
commodity_name string yes DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
type_name string yes DATANAC type name. MUST be an exact value from get_lookup_options(lookup=type_name) or the call will fail.
practice_name string yes DATANAC practice name. MUST be an exact value from get_lookup_options(lookup=practice_name) or the call will fail.

rma_summary_of_business_cause_of_loss

read-only idempotent open-world RMA cause of loss all years

Returns USDA RMA Summary of Business cause-of-loss rows across all years, filtered by state, county, and commodity. Optional filters: insurance plan name and cause of loss.

Name Type Required Default Description
state_name string yes Full US state name. MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
county_name string yes County name for the chosen state. MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
commodity_name string yes DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
insurance_plan_name string no "" RMA insurance plan name filter (optional).
cause_of_loss_description string no "" Cause of loss description filter (optional).

rma_summary_of_business_cause_of_loss_by_year

read-only idempotent open-world RMA cause of loss for one year

Returns USDA RMA Summary of Business cause-of-loss rows for one crop year, filtered by state, county, and commodity. Optional filters: insurance plan name and cause of loss.

Name Type Required Default Description
commodity_year int yes Commodity (crop) year.
state_name string yes Full US state name. MUST be an exact value from get_lookup_options(lookup=state_name) or the call will fail.
county_name string yes County name for the chosen state. MUST be an exact value from get_lookup_options(lookup=county_name, state_name=...) or the call will fail.
commodity_name string yes DATANAC commodity name. MUST be an exact value from get_lookup_options(lookup=commodity_name) or the call will fail.
insurance_plan_name string no "" RMA insurance plan name filter (optional).
cause_of_loss_description string no "" Cause of loss description filter (optional).
send-email

send_email_get_my_address

read-only idempotent Get my Member email address

Return **your** Member.email from the signed-in JWT identity (producer / agent / admin). This is the only address send_email_send will deliver to. No producer_token or To address arguments — always resolves from your Member row.

No parameters.

send_email_send

Send email to myself (AWS SES)

Sends an email to the signed-in member's own address only. Cannot send to anyone else. There is no To, CC, or BCC argument. Optional file attachments for reports or CSV.

Name Type Required Default Description
subject string yes Email subject line.
body string yes Short plain-text note (1 to 3 sentences). Put CSV or report tables in attachments, not in the body.
is_html bool no false When true, treat body as HTML. Default false (plain text). Keep body a short note either way.
attachments List`1 no For reports/CSV/Excel: list of { file_name, mime_type, content }. `content` may be a base64 string OR plain UTF-8 text (small CSV / .txt / .url). Example: file_name=report.csv, mime_type=text/csv, content=<csv text or base64>. Never put report tables in the body. Attach them.
utility

util_new_guid

read-only Generate a new UUID v4

Generate one fresh RFC 4122 v4 UUID and return it as a lowercased dashed string (e.g. "a4a37083-d069-408e-87ec-822832d78fbe"). Call this whenever you need a new `id` value for an Update tool's insert path (e.g. inserting a new Enterprise Budget, Cost of Production, Budget Line Item, or Budget Line Item Detail row). Each call returns a different value — do not cache the result across rows; for batch inserts, call once per new row.

No parameters.
web-search

extract_web_excel

read-only idempotent open-world Extract Excel from URL

Download xlsx and extract text (rg toolkit extract_web_excel). Optional regex returns named capture groups.

Name Type Required Default Description
url string yes Absolute URL to xlsx.
regex string no Optional .NET regex on extracted workbook text.
ignore_case bool no false Case-insensitive regex when regex is set.
max_text_chars int? no Optional max extracted text chars.

extract_web_pdf

read-only idempotent open-world Extract PDF text from URL

Download PDF and extract text (rg toolkit extract_web_pdf). Do not guess or invent a regex — omit `regex` unless a skill, system instructions, or the user explicitly supplies or clearly describes a pattern. When regex is provided, use named capture groups (?<name>...).

Name Type Required Default Description
url string yes Absolute URL to PDF.
regex string no Optional .NET regex on extracted text (named groups). Only pass when explicitly given or described — never invent a pattern.
ignore_case bool no false Case-insensitive regex when regex is set.
max_text_chars int? no Optional max extracted text chars in JSON output.

extract_web_text

read-only idempotent open-world Fetch URL and regex extract

Download URL as text and apply named-group regex (rg toolkit extract_web_text).

Name Type Required Default Description
url string yes Absolute URL.
pattern string yes .NET regex with (?<name>...) groups.
max_bytes int? no Optional max bytes.
ignore_case bool no false Case-insensitive regex.

get_web_text

read-only idempotent open-world HTTP GET URL as text

HTTP GET a URL and return body text with metadata (rg toolkit get_web_text).

Name Type Required Default Description
url string yes Absolute http(s) URL.
max_bytes int? no Optional max bytes.

search_web

read-only idempotent open-world Web search

Search the web via Perplexity Search API (ranked URLs with snippets). Same intent as RG toolkit locate_web. Domain scope is fixed in server configuration (Perplexity:DomainFilter), not a tool parameter.

Name Type Required Default Description
text string yes Search query text.
max_results int? no Max results 1–20 (default 8).