How to send pgvector embedding from Make.com to Supabase

Questions
, , ,
1

:bullseye: What is your goal?

Insert a pgvector embedding (1024 dimensions) from Make.com into a Supabase vector(1024) column

:thinking: What is the problem & what have you tried?

The embedding comes from Voyage AI as an array of 1024 numbers. I use a Text Aggregator to convert it to a comma-separated string, then try to send it to Supabase.

Tried:

  • Upsert Records module with [{{13.text}}] → brackets get stripped, error: “Vector contents must start with [”
  • Make an API Call to RPC function with “p_embedding”: “{{13.text}}” → error: “invalid input syntax for type vector”
  • Make an API Call with “p_embedding”: [{{13.text}}] → error: “Empty or invalid json”

How do I correctly format and send a vector embedding array to Supabase from Make.com?

:clipboard: Error messages or input/output bundles

[400] Vector contents must start with “[”. invalid input syntax for type vector: “-0.024675341, 0.003345289…”
[400] invalid input syntax for type vector: “[-0.024675341, 0.003345289…]”
[400] Empty or invalid json

3

The main issue is probably the format you are sending to Supabase.

pgvector expects the embedding as a vector string with square brackets, like:

[0.12,0.34,0.56]

If Make strips the brackets or sends it as plain text/JSON in the wrong way, Supabase will reject it with the errors you are seeing.

So the simple fix is:

  • keep the full array with the [ and ]

  • send it as one plain string value

  • make sure it is inserted into the vector(1024) column, not as normal JSON

So this looks more like a formatting issue in Make than a Supabase problem.