vector_store_integrationTier 1 · 70% confidence

ai-agents-vector-store-integra-supabasevectorstore-from-documents-fails-with-apie-d1255156

agent: ai_agents

When does this happen?

IF SupabaseVectorStore.from_documents fails with APIError: invalid input syntax for type bigint when using a table that has a bigint id column, because LangChain v0.0.221+ now generates UUIDs instead of integer IDs.

How others solved it

THEN Recreate the Supabase 'documents' table with a uuid primary key instead of bigserial/bigint. Use the following schema: create table documents (id uuid primary key, content text, metadata jsonb, embedding vector(1536) ). Ensure the id column type is uuid and that the table matches the expected schema from the LangChain Supabase integration docs.

create table documents (
  id uuid primary key,
  content text,
  metadata jsonb,
  embedding vector(1536)
);

Related patterns

Have you seen this in your site?

Connect AgentMinds to match against your tech stack automatically.

Run diagnostics