SQL Agent for AI - User Specific Request

Questions
1

Information on your n8n setup

  • n8n version: 1.64.3
  • Database (default: SQLite): Postgres
  • n8n EXECUTIONS_PROCESS setting (default: own, main): main
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Window 11

i was able to chat and query whole DB without restriction using flow below. But what if my goal is to deploy the bot to each Employee, each of them can only query their own claim/leave transaction, how could we slot in the filter of EmployeeCode?
also to introduce hierarchy, Employee < Direct Report < Dept Head < Superadmin? Each can only query level below them

2

You could try using workflow as tool.

1 Like
3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.