Read-only queries

[maelp]

Would it be easy to add a small query-analysis tool to ensure that the LLM only builds read-only queries, and let it run any queries?
Or possibly have a small "temporary schema" where it can creates tables in isolation for temporary work, that are deleted at the end?

[maelp]

Those might be useful: https://neon.tech/postgresql/postgresql-tutorial/postgresql-temporary-table and https://chatgpt.com/share/67dbf1b6-915c-800b-803c-52c3824bb444

[jasonmccallister]

Would it be easy to add a small query-analysis tool to ensure that the LLM only builds read-only queries, and let it run any queries?

I suppose we could update the prompt to tell it to only write read queries - but that its not really enforcing that it does. Maybe it's a better option to give the agent a connection with read-only permissions?

Also, temp schemas are awesome, feels like it's one more step the agent needs to perform? Will definitely look into it though, thank you!