SQL Agent execution time

Questions
1

So the SQL Agent takes quite a bit of time for even simple stuff, this is mainly because most of the time it does around 6 steps. I was wondering if there is a way to save on steps like getting all tables and getting schema of said tables, sort of caching them

Or at least a more efficient way of providing it in the system prompt

Information on your n8n setup

  • n8n version: 1.65.2
  • Database (default: SQLite): Postgres
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
1 Like
2

Hey @Jannispkz,

At the moment because of all of the other actions it needs to do it is currently as good as it will be for a while but I suspect we will start looking into more optimisations next year.

1 Like
3

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