Allow another schema than « public » for Langchain SQL Agent with PostgreSQL

Feature Requests
1

The idea is:

Add the ability in AI node for SQL Agent to allow for another schema than “public” for postgreSQL. The feature list-tables-sql returns only public tables. Langchain standard feature enables to select another schema.
Can you please add this feature ?

My use case:

Interact with LLM and sql DB where the data is not stored in “public” schema.

I think it would be beneficial to add this because:

One often does not use the public schema by default

Any resources to support this?

Just a schéma argument in Langchain

Are you willing to work on this?

No

2

You can simply define the schema name followed by the default table name that n8n creates to save chat histories.

Like in this example:

image
image526×563 28.3 KB