Mintplex-Labs/anything-llm
1
0
Fork 0
mirror of https://github.com/Mintplex-Labs/anything-llm.git synced 2026-07-19 14:13:35 -04:00
Code Issues 328 Packages Projects Releases 10 Wiki Activity

[PR #3788] [MERGED] PGvector vector database support #4405

New Issue
Closed
opened 2026-02-22 18:35:46 -05:00 by yindo · 0 comments
yindo commented 2026-02-22 18:35:46 -05:00
Owner
Copy Link
Copy Source

📋 Pull Request Information

Original PR: https://github.com/Mintplex-Labs/anything-llm/pull/3788
Author: @timothycarambat
Created: 5/8/2025
Status: ✅ Merged
Merged: 5/9/2025
Merged by: @timothycarambat

Base: master ← Head: 873-pgvector-support

📝 Commits (10+)

  • 1790c84 PGVector support for vector db storage
  • 3cf4a8b forgot files
  • f98d67a comments
  • 62c5b70 dev build
  • 7b53323 Merge branch 'master' into 873-pgvector-support
  • 0b38032 Add ENV connection and table schema validations for vector table
  • cfb1475 update setup
  • 151803f update README
  • e6951e8 update doc
  • 8f4677f Merge branch 'master' into 873-pgvector-support

📊 Changes

18 files changed (+1164 additions, -24 deletions)

View changed files

📝 .github/workflows/dev-build.yaml (+1 -1)
📝 README.md (+1 -0)
📝 docker/.env.example (+8 -3)
➕ frontend/src/components/VectorDBSelection/PGVectorOptions/index.jsx (+103 -0)
➕ frontend/src/media/vectordbs/pgvector.png (+0 -0)
📝 frontend/src/pages/GeneralSettings/VectorDatabase/index.jsx (+21 -10)
📝 frontend/src/pages/OnboardingFlow/Steps/DataHandling/index.jsx (+9 -1)
📝 locales/README.fa-IR.md (+1 -0)
📝 locales/README.ja-JP.md (+1 -0)
📝 locales/README.tr-TR.md (+1 -0)
📝 locales/README.zh-CN.md (+1 -0)
📝 server/.env.example (+5 -0)
📝 server/models/systemSettings.js (+5 -0)
📝 server/utils/helpers/index.js (+3 -0)
📝 server/utils/helpers/updateENV.js (+98 -4)
➕ server/utils/vectorDbProviders/pgvector/SETUP.md (+106 -0)
➕ server/utils/vectorDbProviders/pgvector/index.js (+784 -0)
📝 server/utils/vectorStore/resetAllVectorStores.js (+16 -5)

📄 Description

Pull Request Type

  • ✨ feat
  • 🐛 fix
  • ♻️ refactor
  • 💄 style
  • 🔨 chore
  • 📝 docs

Relevant Issues

resolves #873

What is in this change?

  • Support for AnythingLLM managed pgvector support for PostgreSQL v12+
  • Handle table creation, management, and search with user defined or default table name

Additional Information

does not work with existing pg table!! We will not support this because we require specific schema to store, write, and access vectors

Developer Validations

🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/Mintplex-Labs/anything-llm/pull/3788 **Author:** [@timothycarambat](https://github.com/timothycarambat) **Created:** 5/8/2025 **Status:** ✅ Merged **Merged:** 5/9/2025 **Merged by:** [@timothycarambat](https://github.com/timothycarambat) **Base:** `master` ← **Head:** `873-pgvector-support` --- ### 📝 Commits (10+) - [`1790c84`](https://github.com/Mintplex-Labs/anything-llm/commit/1790c84f63c7ad93c589e6e018eb65b51a1983aa) PGVector support for vector db storage - [`3cf4a8b`](https://github.com/Mintplex-Labs/anything-llm/commit/3cf4a8be5aef5a8cecee9df023753f35ffe1a37b) forgot files - [`f98d67a`](https://github.com/Mintplex-Labs/anything-llm/commit/f98d67a04258d9b85335a7f211d91cc221f5fcb3) comments - [`62c5b70`](https://github.com/Mintplex-Labs/anything-llm/commit/62c5b7092db17a3a35bb2bf2177272a266e3f113) dev build - [`7b53323`](https://github.com/Mintplex-Labs/anything-llm/commit/7b53323b939da5d661e925fd341f079ee21b11d9) Merge branch 'master' into 873-pgvector-support - [`0b38032`](https://github.com/Mintplex-Labs/anything-llm/commit/0b380327bfd0a01c36d8fe140ed8f7d74dd684fd) Add ENV connection and table schema validations for vector table - [`cfb1475`](https://github.com/Mintplex-Labs/anything-llm/commit/cfb14755f467d0b58e4b99d1b7d75817369f5f31) update setup - [`151803f`](https://github.com/Mintplex-Labs/anything-llm/commit/151803f43b2fd058254abedf3f562382c48971f5) update README - [`e6951e8`](https://github.com/Mintplex-Labs/anything-llm/commit/e6951e8cfd8b20680a777463305f3fa99652b1d0) update doc - [`8f4677f`](https://github.com/Mintplex-Labs/anything-llm/commit/8f4677fb2c42b733aff966da139d64c6b8f6fa4b) Merge branch 'master' into 873-pgvector-support ### 📊 Changes **18 files changed** (+1164 additions, -24 deletions) <details> <summary>View changed files</summary> 📝 `.github/workflows/dev-build.yaml` (+1 -1) 📝 `README.md` (+1 -0) 📝 `docker/.env.example` (+8 -3) ➕ `frontend/src/components/VectorDBSelection/PGVectorOptions/index.jsx` (+103 -0) ➕ `frontend/src/media/vectordbs/pgvector.png` (+0 -0) 📝 `frontend/src/pages/GeneralSettings/VectorDatabase/index.jsx` (+21 -10) 📝 `frontend/src/pages/OnboardingFlow/Steps/DataHandling/index.jsx` (+9 -1) 📝 `locales/README.fa-IR.md` (+1 -0) 📝 `locales/README.ja-JP.md` (+1 -0) 📝 `locales/README.tr-TR.md` (+1 -0) 📝 `locales/README.zh-CN.md` (+1 -0) 📝 `server/.env.example` (+5 -0) 📝 `server/models/systemSettings.js` (+5 -0) 📝 `server/utils/helpers/index.js` (+3 -0) 📝 `server/utils/helpers/updateENV.js` (+98 -4) ➕ `server/utils/vectorDbProviders/pgvector/SETUP.md` (+106 -0) ➕ `server/utils/vectorDbProviders/pgvector/index.js` (+784 -0) 📝 `server/utils/vectorStore/resetAllVectorStores.js` (+16 -5) </details> ### 📄 Description ### Pull Request Type <!-- For change type, change [ ] to [x]. --> - [x] ✨ feat - [ ] 🐛 fix - [ ] ♻️ refactor - [ ] 💄 style - [ ] 🔨 chore - [x] 📝 docs ### Relevant Issues <!-- Use "resolves #xxx" to auto resolve on merge. Otherwise, please use "connect #xxx" --> resolves #873 ### What is in this change? - Support for AnythingLLM managed `pgvector` support for PostgreSQL v12+ - Handle table creation, management, and search with user defined or default table name <!-- Describe the changes in this PR that are impactful to the repo. --> ### Additional Information **does not work with existing pg table!!** We will not support this because we _require_ specific schema to store, write, and access vectors <!-- Add any other context about the Pull Request here that was not captured above. --> ### Developer Validations <!-- All of the applicable items should be checked. --> - [x] I ran `yarn lint` from the root of the repo & committed changes - [x] Relevant documentation has been updated https://github.com/Mintplex-Labs/anythingllm-docs/issues/165 - [x] I have tested my code functionality - [x] Docker build succeeds locally --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
yindo added the pull-request label 2026-02-22 18:35:46 -05:00
yindo closed this issue 2026-02-22 18:35:46 -05:00
yindo changed title from [PR #3788] PGvector vector database support to [PR #3788] [MERGED] PGvector vector database support 2026-06-05 15:18:24 -04:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
Desktop
Docker
Integration Request
Integration Request
OS: Linux
OS: Mobile
OS: Windows
UI/UX
blocked
bug
bug
core-team-only
documentation
duplicate
embed-widget
enhancement
feature request
github_actions
good first issue
investigating
needs info / can't replicate
possible bug
pull-request
Mirrored from GitHub Pull Request
 question
stage: specifications
wontfix
No Label pull-request
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
yindo
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: Mintplex-Labs/anything-llm#4405
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?