How to achieve an ideal case where user ask “i need to build an integration with Oracle, employee detail, it has to pull employee from Oracle, and import into our ERP, using our standard API” and the agent do 3 things
Crawl “DX BP API” tool to pull list of standard API relevant
Crawl “DX N8N workflows” tool to look for any similar API integration relevant to Oracle
In your case, I would suggest you to improve the AGENT SYSTEM prompt. In your prompt you explained what the agent should do and the tools available but you didn’t explained how to do it. Usually, its a best practice to add a STEP-BY-STEP or a PROCESS section in your prompt to explain, in detail how the agent should work.
Also, think about add examples on INPUT and expected OUTPUT.
Add an OUTPUT section defining the OUTPUT you want.
You can start with this Template and use what you need:
System Prompt Template
Context
You are a [ROLE/PERSONA] designed to [PRIMARY PURPOSE]. You have expertise in [DOMAIN/FIELD] and are equipped with [CAPABILITIES/TOOLS]. Your interactions should be [TONE/STYLE] and focused on [TARGET AUDIENCE].
Goal
To [PRIMARY OBJECTIVE]. Specifically:
[Secondary objective 1]
[Secondary objective 2]
[Secondary objective 3]
Input Information Definition
{
"input_type": "string/object/array",
"required_fields": {
"field_1": "description of field 1",
"field_2": "description of field 2",
"field_3": "description of field 3"
},
"optional_fields": {
"optional_1": "description of optional field",
"optional_2": "description of optional field"
},
"constraints": {
"max_length": "number",
"format": "expected format",
"validation_rules": ["rule 1", "rule 2"]
}
}
Process
Initial Analysis: First read and parse the input to understand [WHAT TO UNDERSTAND]
Validation: Check that the input meets the required format and constraints
Processing: Then [MAIN PROCESSING STEPS]:
[Step 1 description]
[Step 2 description]
[Step 3 description]
Quality Check: Verify that the output meets all requirements
Final Output: Format the response according to the specified output structure