Icon

chembl_​query

<p>Tool name: <strong>chembl_query</strong></p><p>Description: This tool translates a natural language question into a SQL query, runs it against the ChEMBL database, and returns the results. It is a one-shot tool, only use for simple data lookup, not for reasoning.</p><p>It accepts one parameter:</p><p>- prompt_input: the natural language question to answer using ChEMBL data.</p><p>Examples: "What are the most potent IC50 compounds against EGFR?",</p><p>"Give me approved small molecule drugs for type 2 diabetes with their SMILES",</p><p>"What targets has aspirin been tested against?"</p><p>The tool returns:</p><p>- chembl_results: a data table where each row corresponds to one database record matching the query.</p><p>- A summary message describing the number of rows returned, key patterns or values in the data, and whether the 50-row limit was likely hit.</p><p>Use this tool when the user asks any question that requires looking up compounds, targets, activities, assays, drug indications, or physicochemical properties from the ChEMBL database. If the summary indicates an empty result or a likely query error, call this tool again with a rephrased or simplified prompt_input.</p>

Tool name: chembl_query

Description: This tool translates a natural language question into a SQL query, runs it against the ChEMBL database, and returns the results. It is a one-shot tool, only use for simple data lookup, not for reasoning.

It accepts one parameter:

- prompt_input: the natural language question to answer using ChEMBL data.

Examples: "What are the most potent IC50 compounds against EGFR?",

"Give me approved small molecule drugs for type 2 diabetes with their SMILES",

"What targets has aspirin been tested against?"

The tool returns:

- chembl_results: a data table where each row corresponds to one database record matching the query.

- A summary message describing the number of rows returned, key patterns or values in the data, and whether the 50-row limit was likely hit.

Use this tool when the user asks any question that requires looking up compounds, targets, activities, assays, drug indications, or physicochemical properties from the ChEMBL database. If the summary indicates an empty result or a likely query error, call this tool again with a rephrased or simplified prompt_input.

Adjust for connection to your ChEMBL PostgreSQL database.

Adjust for connection to your LLM

Variable to Table Row
connect toChEMBL
PostgreSQL Connector
put example prompt
String Widget
Secrets Retriever
Secrets Retriever
Column Filter
OpenAI Authenticator
Table to JSON
LLM Prompter
OpenAI LLM Selector
DB Query Reader
Table Row to Variable
DB Connection Closer
LLM Prompter
String Manipulation
KNIME Hub Authenticator
Workflow Output
prompt
String Configuration
Tool Message Output

Nodes

Extensions

Links