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 #4202] [MERGED] Modify the PostgreSQL SQL connector to support querying tables from schemas other than the default public schema. #4552

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

📋 Pull Request Information

Original PR: https://github.com/Mintplex-Labs/anything-llm/pull/4202
Author: @roman-y-wu
Created: 7/25/2025
Status: ✅ Merged
Merged: 7/28/2025
Merged by: @timothycarambat

Base: master ← Head: master

📝 Commits (6)

  • ac94432 Add PostgreSQL schema support to SQL connector
  • 994d2ee Fix code formatting after linting
  • 0dc0dc0 Update Postgresql.js
  • 6c957cf add back removal of ending curly brace
  • a2febbb Update Postgresql.js
  • f45f0d1 add back removal of ending curly brace (again?)

📊 Changes

2 files changed (+22 additions, -2 deletions)

View changed files

📝 frontend/src/pages/Admin/Agents/SQLConnectorSelection/NewConnectionModal.jsx (+18 -0)
📝 server/utils/agents/aibitat/plugins/sql-agent/SQLConnectors/Postgresql.js (+4 -2)

📄 Description

Pull Request Type

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

Relevant Issues

resolves #4196

What is in this change?

Modify the PostgreSQL SQL connector to support querying tables from schemas other than the default public schema. The connector should dynamically include the schema name when generating SQL queries, using the schema.table format.

Additional Information

Developer Validations

  • I ran yarn lint from the root of the repo & committed changes
  • Relevant documentation has been updated
  • I have tested my code functionality
  • Docker build succeeds locally

🔄 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/4202 **Author:** [@roman-y-wu](https://github.com/roman-y-wu) **Created:** 7/25/2025 **Status:** ✅ Merged **Merged:** 7/28/2025 **Merged by:** [@timothycarambat](https://github.com/timothycarambat) **Base:** `master` ← **Head:** `master` --- ### 📝 Commits (6) - [`ac94432`](https://github.com/Mintplex-Labs/anything-llm/commit/ac94432bab8c9abaf3af0026eb9b0709148b3881) Add PostgreSQL schema support to SQL connector - [`994d2ee`](https://github.com/Mintplex-Labs/anything-llm/commit/994d2eedae1c01bd23ad8ea82c9e8d7288e2a173) Fix code formatting after linting - [`0dc0dc0`](https://github.com/Mintplex-Labs/anything-llm/commit/0dc0dc08e2fd5f12c38e32580a19a2ffe6afca1b) Update Postgresql.js - [`6c957cf`](https://github.com/Mintplex-Labs/anything-llm/commit/6c957cf756635bd69b35e0f93482d015f15da7bd) add back removal of ending curly brace - [`a2febbb`](https://github.com/Mintplex-Labs/anything-llm/commit/a2febbb81da3b23dda34765e8573799f7dfd8fbb) Update Postgresql.js - [`f45f0d1`](https://github.com/Mintplex-Labs/anything-llm/commit/f45f0d1742c418bb6f8f3a7a3ddd52658f25bc2e) add back removal of ending curly brace (again?) ### 📊 Changes **2 files changed** (+22 additions, -2 deletions) <details> <summary>View changed files</summary> 📝 `frontend/src/pages/Admin/Agents/SQLConnectorSelection/NewConnectionModal.jsx` (+18 -0) 📝 `server/utils/agents/aibitat/plugins/sql-agent/SQLConnectors/Postgresql.js` (+4 -2) </details> ### 📄 Description ### Pull Request Type <!-- For change type, change [ ] to [x]. --> - [x] ✨ feat - [ ] 🐛 fix - [ ] ♻️ refactor - [ ] 💄 style - [ ] 🔨 chore - [ ] 📝 docs ### Relevant Issues <!-- Use "resolves #xxx" to auto resolve on merge. Otherwise, please use "connect #xxx" --> resolves #4196 ### What is in this change? Modify the PostgreSQL SQL connector to support querying tables from schemas other than the default public schema. The connector should dynamically include the schema name when generating SQL queries, using the schema.table format. <!-- Describe the changes in this PR that are impactful to the repo. --> ### Additional Information <!-- 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 - [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:36:03 -05:00
yindo closed this issue 2026-02-22 18:36:03 -05:00
yindo changed title from [PR #4202] Modify the PostgreSQL SQL connector to support querying tables from schemas other than the default public schema. to [PR #4202] [MERGED] Modify the PostgreSQL SQL connector to support querying tables from schemas other than the default public schema. 2026-06-05 15:19:09 -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#4552
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?