Error in sub-node ‘Xata‘ this endpoint works only with non postgres enabled branches

Hey folks, I added the Xata memory node in the AI agent, and i get the error

Error cause: Erron in sub-node ‘Xata’ this endpoint works only with non postgres enabled branches.


Blockquote

{ "status": 400, "errors": [ { "message": "this endpoint works only with non postgres enabled branches", "status": 400 } ], "requestId": "29840bd0-7558-9afb-a569-deba09cd4c8e" }

while my branch is not postgres enabled

My branch in Xata is not enabled, done already 5 times, checked and rechecked


{
“nodes”: [
{
“parameters”: {
“options”: {}
},
“type”: “@n8n/n8n-nodes-langchain.chatTrigger”,
“typeVersion”: 1.1,
“position”: [
0,
0
],
“id”: “61b20dca-7349-49a6-8773-34ce47b8cbfa”,
“name”: “When chat message received”,
“webhookId”: “031fca73-a51f-477b-b120-548da5b84181”
},
{
“parameters”: {
“options”: {}
},
“type”: “@n8n/n8n-nodes-langchain.agent”,
“typeVersion”: 1.7,
“position”: [
220,
0
],
“id”: “40e8168e-d0b8-40e2-91ff-58218164b572”,
“name”: “AI Agent”
},
{
“parameters”: {
“model”: {
“__rl”: true,
“mode”: “list”,
“value”: “gpt-4o-mini”
},
“options”: {}
},
“type”: “@n8n/n8n-nodes-langchain.lmChatOpenAi”,
“typeVersion”: 1.2,
“position”: [
200,
180
],
“id”: “ccfa9afa-88ae-4eb6-a53a-18d601377f4b”,
“name”: “OpenAI Chat Model”,
“credentials”: {
“openAiApi”: {
“id”: “mj6IFsFGVVhmoSqD”,
“name”: “OpenAi account”
}
}
},
{
“parameters”: {
“contextWindowLength”: 10
},
“type”: “@n8n/n8n-nodes-langchain.memoryXata”,
“typeVersion”: 1.4,
“position”: [
320,
300
],
“id”: “b1798822-0d26-4107-a394-7d30da177345”,
“name”: “Xata”,
“credentials”: {
“xataApi”: {
“id”: “m2MFxeFkxx9QSrVD”,
“name”: “Xata Ai_waiter True non Postgres”
}
}
}
],
“connections”: {
“When chat message received”: {
“main”: [
[
{
“node”: “AI Agent”,
“type”: “main”,
“index”: 0
}
]
]
},
“OpenAI Chat Model”: {
“ai_languageModel”: [
[
{
“node”: “AI Agent”,
“type”: “ai_languageModel”,
“index”: 0
}
]
]
},
“Xata”: {
“ai_memory”: [
[
{
“node”: “AI Agent”,
“type”: “ai_memory”,
“index”: 0
}
]
]
}
},
“pinData”: {},
“meta”: {
“instanceId”: “0c4b896834106a7e1ebd99186e265e8c21363877ca7bc33b6990960b9275158e”
}
}

Information on your n8n setup

  • **n8n version:
    1.78.0 (Cloud)
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • **Running n8n via n8n cloud- **Operating system:windows 11

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:

I was having the same issue, you need to unmark the “Enable direct access to Postgres” when creating the DB. What I did was create a new database and change the “Database Endpoint” in my Xata credentials and it worked!

1 Like

thank u alvaro!!! i am gonna try it and gonna return back to u

hey alvaro it worked <3
:sweat_smile:

This is happening to me as well but the option to Enable direct access to Postgres is now missing. It looks like it was enable by default now.

I’ve got the same issue, looks like Xata updated this a few days ago. Has anyone found a workaround?

Having the same problem. Does anyone have the answer?

1 Like