Troubleshooting Langchain SQL Agent Errors

Hi, thanks a lot for the explanation.

May I ask what the auto-generated field refers to? I would assume it's the auto-increment field (e.g., an ID field that automatically increases by 1 for every new record inserted).

Here is the structure of my table columns:

image1341×817 50.1 KB

But after changing from “Map automatically” to “Map manually”, it is still unable to detect the columns within the postgres table.

image1916×829 111 KB

Hello,

This would apply to any field where Postgres is assigning the value, rather than you manually entering it. Could you please export the schema for that table? I'd like to examine it, as I suspect the issue arises because we might anticipate a primary key, which could indicate a bug within the Postgres node.

I suggest utilizing the 'execute query' option, which should resolve this and allow you to proceed with that segment of your workflow.

I understand. Thank you for the update.

Here's the schema for the table:

-- Table: public.callin_io_analytics

-- DROP TABLE IF EXISTS public.callin_io_analytics;

CREATE TABLE IF NOT EXISTS public.callin_io_analytics
(
    "Platform" character varying(40) COLLATE pg_catalog."default",
    "Campaign" character varying(400) COLLATE pg_catalog."default",
    "Click" integer,
    "Conversion" integer,
    "Feedback" text COLLATE pg_catalog."default"
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.callin_io_analytics
    OWNER to postgres;

It seems I could utilize this SQL Agent with Postgres...

Currently, I'm attempting to configure it for similarity searches of blog articles within my database when users express interest in specific topics.

However, it appears to be hallucinating and providing article lists that are not present in my Postgres database. Perhaps I need more time for investigation, but I'll post this here first to see if anyone has insights.

I would appreciate any suggestions on more effective methods for implementing similarity search for article recommendations using callin.io.

Please let me know if there's a better approach to achieve this similarity search for article suggestions via callin.io.

This thread was automatically closed 90 days following the last response. New replies are no longer permitted.