text_to_sql_pipeline: How to make it work

[tdiprima]

At first, I had trouble installing the Text-to-SQL Pipeline. For example, when I clicked the "Save" button, an error message said "No valves to update." The Docker logs said: "No Pipeline class found in text_to_sql_pipeline".

I noticed that others in this Discussion group are also interested in addressing this issue.

I ended up fixing it, and hopefully they will accept my pull request #346

How does it work? Update the code with your environment variable defaults. This setup assumes you have a PostgreSQL database, but you can change it to whatever you have. Then import the code. Start a new chat, choosing "Database RAG Pipeline" as your model. Then ask a question, and it works. It converts text to sql, queries the database, and gives you your answer.