34-database-tools.halo

examples/34-database-tools.halo

Open in the playground →

tool UsersDB : PostgreSQL("postgres://user:pass@localhost:5432/mydb")
tool KnowledgeBase : VectorStore("index-123")

agent Analyst [openai/gpt-4]
  equips UsersDB, KnowledgeBase

pipeline AnalyzeUser(userId: String) -> Result:
  userId
    |> UsersDB.execute(query: "SELECT * FROM users WHERE id = '{{context.input.userId}}'")
    |> KnowledgeBase.execute(method: "search", query: "Policies for user type: {{context.current.type}}")
    |> Analyst.prompt("Summarize the user profile and relevant policies. User: {{context.data.UsersDB.execute}}, Policies: {{context.current}}")