Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. LibreChat
  3. First try app packaging : librechat - issue with postgresql extention (pgvector)

First try app packaging : librechat - issue with postgresql extention (pgvector)

Scheduled Pinned Locked Moved LibreChat
40 Posts 10 Posters 2.1k Views 10 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • nebulonN Away
    nebulonN Away
    nebulon
    Staff
    wrote last edited by
    #25

    I see, so this is actually another project which needs to be bundled together with librechat or as a separate app.

    This one is using pgvector, not librechat itself!

    (will also move the thread here to the librechat category)

    1 Reply Last reply
    2
    • nebulonN nebulon moved this topic from App Packaging & Development
    • V Valexico

      Hi

      I wanted to learn cloudron app packaging, and I am actually working on an AI assistant to generate Clourdon packages bases on source repository. Ibuilt a bunch of nested prompts (with Zed editor which is really cool for this) and had encouraging result so far.

      I could generate a working package for Librechat which is requested here.

      Sources are here : https://gitlab.com/vlebert/librechat-cloudron

      The app can start in Cloudron but I have 2 issues

      • SSO with OIDC don't work. It is documented here but I can't make it work.
      • There is a sub-app called RAG-API used to interact with uploaded document and which require pgvector extention. How to use this extension in a cloudron package ?
        Documentation says vector extension is "whitelisted" : https://docs.cloudron.io/packaging/addons/#postgresql
        But I can't create this extention in postgres :
        bd1f68e9-abfa-46b4-9a83-5ecfc2925ba8-digi-studio 2024-11-25 at 10.52.00.png
        Should it be installed with apt in the Dockerfile ? I made a few attempts but no success...

      Any help would be greatly appreciated 🙂

      L Offline
      L Offline
      LoudLemur
      wrote last edited by
      #26

      @Valexico hey there! Trying this is awesome and thank you so much for putting your ai skills towards packaging.

      I came here to offer congratulations on having LibreChat packaged, but to hear you have stated an ai cloudron packaging initiative is just fantastic. I am very glad you are here and thanks for your efforts.

      1 Reply Last reply
      1
      • V Offline
        V Offline
        Valexico
        wrote last edited by
        #27
        This post is deleted!
        1 Reply Last reply
        0
        • V Offline
          V Offline
          Valexico
          wrote last edited by
          #28

          Hi @LoudLemur
          Thanks

          For those who want to dig "AI assisted packaging", here is how I proceeded

          • I use Zed Editor which has a nice prompt library tool allowing prompt nesting (prompts in prompts. Sins Zed last "agentic" update, you need to use what they call "text thread" to have this feature/behaviour
          • I have a main big prompt with all main specificities of packaging (Cloudron documentation mainly)
          • I have smaller prompts about addon to be loaded only when needed
          • And then I made specific prompts loading target app source files, and the same for example of packaged apps to guide the AI

          I did this in 2024. This could be largely improved in 2025 with more agentic behaviour to let the AI fetch the context it needs 🙂

          dbbfa877-1653-4bde-a4e5-81131168daf1-digi-studio 2025-07-08 at 09.12.31.png

          1851dda3-585f-4c90-9535-6b299fb8c808-digi-studio 2025-07-08 at 09.13.39.png

          22c5517a-f79b-477d-aa18-fa820472b819-digi-studio 2025-07-08 at 09.13.50.png

          b7816f6c-ffeb-4b26-b9ea-be74684179ef-digi-studio 2025-07-08 at 09.13.17.png

          1 Reply Last reply
          5
          • jdaviescoatesJ Online
            jdaviescoatesJ Online
            jdaviescoates
            wrote last edited by
            #29

            See also the prompt put together by @canadaduane here https://git.knownelement.com/KNEL/KNELProductionContainers/src/commit/9f74e0fc3977d368f1ca4846843607c75cd05b1c/Techops/CloudronPackagePrompt.md

            I use Cloudron with Gandi & Hetzner

            1 Reply Last reply
            4
            • robiR Offline
              robiR Offline
              robi
              wrote last edited by robi
              #30

              With an MCP server if you install context7.com it has the ability to ingest all the relevant docs for the agent task. https://github.com/upstash/context7

              There are other nice combos of MCPs, perhaps for another thread. Start and share.

              Conscious tech

              L 1 Reply Last reply
              1
              • robiR robi

                With an MCP server if you install context7.com it has the ability to ingest all the relevant docs for the agent task. https://github.com/upstash/context7

                There are other nice combos of MCPs, perhaps for another thread. Start and share.

                L Offline
                L Offline
                LoudLemur
                wrote last edited by
                #31

                @robi @girish there is an option to add cloudron's docs here, if they are on github

                https://context7.com/add-library?tab=github

                marcusquinnM 1 Reply Last reply
                2
                • V Offline
                  V Offline
                  Valexico
                  wrote last edited by Valexico
                  #32

                  I think building a RAG-like knowledge base is not the best approach for this use case.
                  It would be much mode efficient an agent with

                  • General knowledge about cloudron packaging
                  • Toolset (sub agent) to retrieve relevant files from repositories (dockerfile, docker-compose...)
                  • Toolset to retrieve additional context for each addon needed
                  • Toolset to retrieve relevant example (existing cloudron packaged apps)

                  The process is complex but quite straightforward and I see no need for a RAG knowledge base

                  1 Reply Last reply
                  0
                  • firmansiF Offline
                    firmansiF Offline
                    firmansi
                    wrote last edited by firmansi
                    #33

                    But without RAG API, somehow we can nor "chat" with files, that's from understanding about how important to have RAG API packaged with core Librechat. Pleaset let us know if we can upload files to Librechat without RAG API, maybe I miss something

                    1 Reply Last reply
                    1
                    • V Offline
                      V Offline
                      Valexico
                      wrote last edited by Valexico
                      #34

                      We should split in 2 different thread
                      Yes Librechat needs RAG API to have all its feature

                      No a cloudron packaging agent does not need a RAG knowledge bases to be efficient (I think)

                      Those are 2 totally different subjects

                      firmansiF 1 Reply Last reply
                      1
                      • V Valexico

                        We should split in 2 different thread
                        Yes Librechat needs RAG API to have all its feature

                        No a cloudron packaging agent does not need a RAG knowledge bases to be efficient (I think)

                        Those are 2 totally different subjects

                        firmansiF Offline
                        firmansiF Offline
                        firmansi
                        wrote last edited by
                        #35

                        @Valexico Sure, to make it more efficient,but somehow RAG knowledgebase deem necessary for business usage as RAG can enhance model to understand the business context of the company using tool like librechat, without RAG knowledgebase, the model will only have vast general knowledge

                        1 Reply Last reply
                        1
                        • V Offline
                          V Offline
                          Valexico
                          wrote last edited by Valexico
                          #36

                          I agree with you @firmansi
                          the problem is there are 2 topics discussed in this thread :

                          • Topic #1: Packaging of librechat
                          • Topic #2: How to build an AI agent to automate the process of packaging Cloudron app

                          I think that lead to our misunderstanding

                          1 Reply Last reply
                          1
                          • L LoudLemur

                            @robi @girish there is an option to add cloudron's docs here, if they are on github

                            https://context7.com/add-library?tab=github

                            marcusquinnM Offline
                            marcusquinnM Offline
                            marcusquinn
                            wrote last edited by
                            #37

                            @LoudLemur said in First try app packaging : librechat - issue with postgresql extention (pgvector):

                            @robi @girish there is an option to add cloudron's docs here, if they are on github

                            https://context7.com/add-library?tab=github

                            Great suggestion! Might need it's own post to make sure it doesn't get lost in this thread.

                            Web Design https://www.evergreen.je
                            Development https://brandlight.org
                            Life https://marcusquinn.com

                            L 1 Reply Last reply
                            2
                            • marcusquinnM marcusquinn

                              @LoudLemur said in First try app packaging : librechat - issue with postgresql extention (pgvector):

                              @robi @girish there is an option to add cloudron's docs here, if they are on github

                              https://context7.com/add-library?tab=github

                              Great suggestion! Might need it's own post to make sure it doesn't get lost in this thread.

                              L Offline
                              L Offline
                              LoudLemur
                              wrote last edited by LoudLemur
                              #38

                              @marcusquinn Thanks! I have checked and context7 can also ingest from websites, which I shall try instead. That website is very busy ingesting and it keeps saying, "Try again in a few minutes..." Eventually it said "failed to find project name" from cloudron's:
                              https://docs.cloudron.io/

                              so it is still not working and now it is rate limiting me. perhaps somebody else could try?

                              1 Reply Last reply
                              1
                              • L Offline
                                L Offline
                                LoudLemur
                                wrote last edited by LoudLemur
                                #39

                                We have Cloudron docs in context7, now.
                                Thanks to whomever sorted that!

                                https://context7.com/context7/cloudron_io

                                marcusquinnM 1 Reply Last reply
                                2
                                • L LoudLemur

                                  We have Cloudron docs in context7, now.
                                  Thanks to whomever sorted that!

                                  https://context7.com/context7/cloudron_io

                                  marcusquinnM Offline
                                  marcusquinnM Offline
                                  marcusquinn
                                  wrote last edited by
                                  #40

                                  @LoudLemur Awesome!

                                  Web Design https://www.evergreen.je
                                  Development https://brandlight.org
                                  Life https://marcusquinn.com

                                  1 Reply Last reply
                                  0
                                  Reply
                                  • Reply as topic
                                  Log in to reply
                                  • Oldest to Newest
                                  • Newest to Oldest
                                  • Most Votes


                                  • Login

                                  • Don't have an account? Register

                                  • Login or register to search.
                                  • First post
                                    Last post
                                  0
                                  • Categories
                                  • Recent
                                  • Tags
                                  • Popular
                                  • Bookmarks
                                  • Search