jasmeet
jasmeetβ€’2mo ago

jasmeet22 - Hi, I am chatting with supabase. Bu...

Hi, I am chatting with supabase. But it returns below response:
It seems that you've uploaded a file, but you haven't provided any instructions or a specific question regarding the file. Could you please let me know how you would like me to assist you with this file?
It seems that you've uploaded a file, but you haven't provided any instructions or a specific question regarding the file. Could you please let me know how you would like me to assist you with this file?
can someone please help me what wrong I am doing.
Solution:
@jasmeet22 as mentioned earlier in discord message and email support, you need to just disable the RLS in your table to make this workflow work, did you refer to the shared documentation and video tutorial in email?
BuildShip
YouTube
AI Assistant to Chat with Supabase Database
AI Assistant to Chat with Supabase Database - Learn how to build chatbot or API on OpenAI Assistant with Function callin with no code. Use the AI Assistant as a chatwidget or API. Remix template: https://buildship.app/remix?template=assistant-chat-with-supabase Query a Supabase database using natural language by integrating BuildShip with Ope...
No description
Jump to solution
20 Replies
Gaurav Chadha
Gaurav Chadhaβ€’2mo ago
Hi @jasmeet22, if you have uploaded any files to your Assistant on the openAI dashboard, you'll require to enable file search/document retrieval in Assistant node and your openai dashboard. For chat with Supabase file search isn't required you can refer to this video tutorial - https://www.youtube.com/watch?v=uM5YP43SikU
BuildShip
YouTube
AI Assistant on Supabase - Query Multiple Tables, Insert, Update, D...
How to Build a Powerful Supabase Database Assistant with BuildShip and OpenAI to interact with multiple tables, execute SQL queries, and even perform operations like inserting, updating, and deleting records. Remix Link πŸ‘‰ https://buildship.app/remix?template=db-query-assistant BuildShip is a low-code Visual Backend and AI Workflow Builder. Get ...
No description
jasmeet
jasmeetβ€’5w ago
I set "File Search". But still same problem.
jasmeet
jasmeetβ€’5w ago
No description
jasmeet
jasmeetβ€’5w ago
please check this and tell me what's wrong. here I am using table named "Documents". There are columns: "name", "description". I want to retrieve only name of anyone document.
Gaurav Chadha
Gaurav Chadhaβ€’5w ago
from this screenshot your it shows that the prompt is not getting passed with the query, change it to query.prompt
No description
jasmeet
jasmeetβ€’5w ago
still same problem. can we please connect via gmeet so that you can check all provided values, if anything wrong with them?
Gaurav Chadha
Gaurav Chadhaβ€’5w ago
you can submit your workflow via app - https://docs.buildship.com/support-messages we'll check your workflow and reply via email.
Support Messages – BuildShip
A unified resource to start building your backend with low-code. Dive into triggers, nodes, and step-by-step guidance to jumpstart your workflow creation.
jasmeet
jasmeetβ€’5w ago
Thanks a lot for your help. I submitted.
jasmeet
jasmeetβ€’5w ago
what's wrong here. I used proper API key and URL also. I have data in document table also.
No description
No description
Gaurav Chadha
Gaurav Chadhaβ€’5w ago
as mentioned in the email, you'll require to test your supabse node to ensure it is successfully connected or not, form your above screenshot is shows that RLS is enabled on your table, you'll need to disable RLS or create custom policy to make it accessbile to the Assistant, you can disable it for easy step, please refer to this docs - https://docs.buildship.com/tutorials/supabase-crud#supabase-row-level-security-rls
Integrate Supabase DB with BuildShip – BuildShip
A unified resource to start building your backend with low-code. Dive into triggers, nodes, and step-by-step guidance to jumpstart your workflow creation.
jasmeet
jasmeetβ€’5w ago
now this response shows :
No description
jasmeet
jasmeetβ€’5w ago
please check here in screenshot.
Sebastian AE
Sebastian AEβ€’5w ago
@jasmeet22 are you trying to get the entries of that table? I can't fully see your prompt But if you are, it makes more sense to use the node Supabase - Get Row Then let Ai fill in the value of filter
No description
jasmeet
jasmeetβ€’5w ago
prompt is :
You are an AI assistant named MYAI, designed to provide information about a set of documents. Your knowledge base contains detailed information about each document, including name, description and other relevant details. When asked about a specific document or entire document base, you can quickly retrieve and provide accurate information to assist the human who is interacting with you. Your primary function is to serve as a reliable and efficient tool for managing and accessing document data whenever needed.
jasmeet
jasmeetβ€’5w ago
this is table :
No description
Sebastian AE
Sebastian AEβ€’5w ago
Yeah, you should change the node for the one i suggested Also in the instructions field of the assistant node, you could add that prompt and add something like: 'Use Get Row action to retrieve the new information'
Solution
Gaurav Chadha
Gaurav Chadhaβ€’5w ago
@jasmeet22 as mentioned earlier in discord message and email support, you need to just disable the RLS in your table to make this workflow work, did you refer to the shared documentation and video tutorial in email?
BuildShip
YouTube
AI Assistant to Chat with Supabase Database
AI Assistant to Chat with Supabase Database - Learn how to build chatbot or API on OpenAI Assistant with Function callin with no code. Use the AI Assistant as a chatwidget or API. Remix template: https://buildship.app/remix?template=assistant-chat-with-supabase Query a Supabase database using natural language by integrating BuildShip with Ope...
No description
jasmeet
jasmeetβ€’5w ago
@Gaurav Chadha I did that already. but its unable to find table.
Gaurav Chadha
Gaurav Chadhaβ€’5w ago
from your screenshot it doesn't show rls disabled, please check again
jasmeet
jasmeetβ€’5w ago
@Gaurav Chadha Oh yes, I checked that table has enabled RLS. I disabled it by editing table. Now all works fine. Thanks a lot for helping me at every step by providing the proper resources. I appreciate it. πŸ™‚