get_risk_assessments

Retrieve quantitative safety assessments including ADI, TDI, and safety limit values for food substances from EFSA's OpenFoodTox database by hazard ID.

Instructions

Get risk assessment data from CHEM_ASSESS table by HAZARD_ID. Retrieves comprehensive risk assessment records including ADI (Acceptable Daily Intake), TDI (Tolerable Daily Intake), and other safety limit values. This tool provides the quantitative safety assessments used by EFSA to establish safe intake levels for food substances. Args: hazard_id: Single HAZARD_ID (int) or list of HAZARD_IDs (list[int]) to query. Use search_substance tool first to find HAZARD_IDs through the STUDY table. Returns: JSON string containing a DataFrame with risk assessment records. Each record includes assessment type, risk values, units, safety factors, and population information. The returned data includes: - Assessment type: ASSESSMENTTYPE (e.g., ADI, TDI, ARfD) - Risk values: RISKVALUE, RISKVALUE_MILLI, RISKUNIT, RISKUNIT_MILLI - Risk qualifier: RISKQUALIFIER (e.g., "not specified", "group") - Safety factors: SAFETY_FACTOR - Population: ID_POPULATION, POPULATIONTEXT - Assessment details: ASSESS, REMARKS - Group assessments: COM_GROUP_ID, GROUP_UNIT, GROUP_REMARKS Note: Multiple records may be returned if multiple HAZARD_IDs are provided or if a single hazard has multiple assessment types (e.g., both ADI and TDI). <dictionary_descriptions> <name>RISKQUALIFIER</name> <description>Description of the qualifier for the reference value</description> <name>RISKVALUE</name> <description>Quantification of the reference value</description> <name>RISKUNIT</name> <description>Short description of the units of the reference value</description> <name>RISKUNITFULLTEXT</name> <description>Full description of the units of the reference value</description> <name>RISKVALUE_MILLI</name> <description>Full description of the units of the reference value when converted to milligrams</description> <name>RISKUNIT_MILLI</name> <description>Quantification of the reference value when converted to milligrams</description> <name>SAFETY_FACTOR</name> <description>Safety factor/Uncertainty factor used to derive the reference value</description> <name>POPULATIONTEXT</name> <description>Description of the population the reference value applies to</description> <name>REMARKS</name> <description>General comments</description> <name>ASSESS</name> <description>Assessment summarised where no reference value is set</description> </dictionary_descriptions>

Input Schema

TableJSON Schema

Name	Required	Description	Default
`hazard_id`	Yes

Implementation Reference

src/mcp_openfoodtox/tools/get_risk_assessments.py:5-59 (handler)
The handler function that implements the get_risk_assessments tool. It queries the CHEM_ASSESS table using the provided hazard_id(s) and returns the risk assessment data as a JSON string.
def get_risk_assessments(hazard_id: Union[int, list[int]]): """ Get risk assessment data from CHEM_ASSESS table by HAZARD_ID. Retrieves comprehensive risk assessment records including ADI (Acceptable Daily Intake), TDI (Tolerable Daily Intake), and other safety limit values. This tool provides the quantitative safety assessments used by EFSA to establish safe intake levels for food substances. Args: hazard_id: Single HAZARD_ID (int) or list of HAZARD_IDs (list[int]) to query. Use search_substance tool first to find HAZARD_IDs through the STUDY table. Returns: JSON string containing a DataFrame with risk assessment records. Each record includes assessment type, risk values, units, safety factors, and population information. The returned data includes: - Assessment type: ASSESSMENTTYPE (e.g., ADI, TDI, ARfD) - Risk values: RISKVALUE, RISKVALUE_MILLI, RISKUNIT, RISKUNIT_MILLI - Risk qualifier: RISKQUALIFIER (e.g., "not specified", "group") - Safety factors: SAFETY_FACTOR - Population: ID_POPULATION, POPULATIONTEXT - Assessment details: ASSESS, REMARKS - Group assessments: COM_GROUP_ID, GROUP_UNIT, GROUP_REMARKS Note: Multiple records may be returned if multiple HAZARD_IDs are provided or if a single hazard has multiple assessment types (e.g., both ADI and TDI). <dictionary_descriptions> <name>RISKQUALIFIER</name> <description>Description of the qualifier for the reference value</description> <name>RISKVALUE</name> <description>Quantification of the reference value</description> <name>RISKUNIT</name> <description>Short description of the units of the reference value</description> <name>RISKUNITFULLTEXT</name> <description>Full description of the units of the reference value</description> <name>RISKVALUE_MILLI</name> <description>Full description of the units of the reference value when converted to milligrams</description> <name>RISKUNIT_MILLI</name> <description>Quantification of the reference value when converted to milligrams</description> <name>SAFETY_FACTOR</name> <description>Safety factor/Uncertainty factor used to derive the reference value</description> <name>POPULATIONTEXT</name> <description>Description of the population the reference value applies to</description> <name>REMARKS</name> <description>General comments</description> <name>ASSESS</name> <description>Assessment summarised where no reference value is set</description> </dictionary_descriptions> """ df = query_by_id(hazard_id, "chem_assess") return df.to_json()
main.py:19-19 (registration)
Registers the get_risk_assessments tool with the FastMCP server instance.
mcp.add_tool(get_risk_assessments)
main.py:3-3 (registration)
Imports the get_risk_assessments handler function for registration.
from src.mcp_openfoodtox.tools.get_risk_assessments import get_risk_assessments

MCP OpenFoodTox