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

[GH-ISSUE #2574] [FEAT]: Support postgres as a backend storage provider #1668

New Issue
Closed
opened 2026-02-22 18:25:58 -05:00 by yindo · 3 comments
yindo commented 2026-02-22 18:25:58 -05:00
Owner
Copy Link
Copy Source

Originally created by @Stono on GitHub (Nov 3, 2024).
Original GitHub issue: https://github.com/Mintplex-Labs/anything-llm/issues/2574

What would you like to see?

sqllite is great for getting up and running quickly but isn't really fault tolerant - it'd be great to be able to post at postgres or mysql.

Originally created by @Stono on GitHub (Nov 3, 2024). Original GitHub issue: https://github.com/Mintplex-Labs/anything-llm/issues/2574 ### What would you like to see? sqllite is great for getting up and running quickly but isn't really fault tolerant - it'd be great to be able to post at postgres or mysql.
yindo added the enhancementfeature request labels 2026-02-22 18:25:58 -05:00
yindo closed this issue 2026-02-22 18:25:58 -05:00
yindo commented 2026-02-22 18:25:58 -05:00
Author
Owner
Copy Link
Copy Source

@anilgulecha commented on GitHub (Mar 25, 2025):

Hi, I see here that postgres may already be supported, only not exposed via Env variables? In which case can we expose these as DB and DB_URL, so as to allow for easy configuration?

@anilgulecha commented on GitHub (Mar 25, 2025): Hi, I see [here](https://github.com/Mintplex-Labs/anything-llm/blob/master/server/prisma/schema.prisma) that postgres may already be supported, only not exposed via Env variables? In which case can we expose these as DB and DB_URL, so as to allow for easy configuration?
yindo commented 2026-02-22 18:25:58 -05:00
Author
Owner
Copy Link
Copy Source

@timothycarambat commented on GitHub (Mar 25, 2025):

In theory, this can be supported by modification of the schema.prisma file - it is not something in Docker directly or an easy to config ENV setting.

Where you can change this - the migrations should be compatible since we are using SQLlite as the base, which should be compatible to PG, but not the other way around.

https://github.com/Mintplex-Labs/anything-llm/blob/dd701f9aa434d1ac03fb9cb7b62a24e7a2d28e22/server/prisma/schema.prisma#L9-L16

@timothycarambat commented on GitHub (Mar 25, 2025): In theory, this can be supported by modification of the [schema.prisma](https://github.com/Mintplex-Labs/anything-llm/blob/master/server/prisma/schema.prisma) file - it is not something in Docker directly or an easy to config ENV setting. Where you can change this - the migrations should be compatible since we are using SQLlite as the base, which should be compatible to PG, but not the other way around. https://github.com/Mintplex-Labs/anything-llm/blob/dd701f9aa434d1ac03fb9cb7b62a24e7a2d28e22/server/prisma/schema.prisma#L9-L16
yindo commented 2026-02-22 18:25:58 -05:00
Author
Owner
Copy Link
Copy Source

@timothycarambat commented on GitHub (May 9, 2025):

https://docs.anythingllm.com/installation-docker/available-images#pg

@timothycarambat commented on GitHub (May 9, 2025): https://docs.anythingllm.com/installation-docker/available-images#pg
yindo changed title from [FEAT]: Support postgres as a backend storage provider to [GH-ISSUE #2574] [FEAT]: Support postgres as a backend storage provider 2026-06-05 14:42:02 -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 enhancement feature 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#1668
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?