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 #1411] [MERGED] Support SQL Agent skill #3673

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

📋 Pull Request Information

Original PR: https://github.com/Mintplex-Labs/anything-llm/pull/1411
Author: @timothycarambat
Created: 5/15/2024
Status: ✅ Merged
Merged: 5/16/2024
Merged by: @timothycarambat

Base: master ← Head: 1298-sql-agent-skill

📝 Commits (7)

  • 546d796 Support SQL Agent skill
  • 6a823fa add MSSQL agent connector
  • d9c31b7 Add frontend to agent skills
  • 3de338b add prompt examples for tools on untooled
  • c404f84 add better logging on SQL agents
  • a184be9 Wipe toolruns on each chat relay so tools can be used within the same session
  • 607d4b4 update comments

📊 Changes

40 files changed (+1745 additions, -59 deletions)

View changed files

➕ frontend/src/pages/WorkspaceSettings/AgentConfig/SQLConnectorSelection/DBConnection.jsx (+47 -0)
➕ frontend/src/pages/WorkspaceSettings/AgentConfig/SQLConnectorSelection/NewConnectionModal.jsx (+271 -0)
➕ frontend/src/pages/WorkspaceSettings/AgentConfig/SQLConnectorSelection/icons/mssql.png (+0 -0)
➕ frontend/src/pages/WorkspaceSettings/AgentConfig/SQLConnectorSelection/icons/mysql.png (+0 -0)
➕ frontend/src/pages/WorkspaceSettings/AgentConfig/SQLConnectorSelection/icons/postgresql.png (+0 -0)
➕ frontend/src/pages/WorkspaceSettings/AgentConfig/SQLConnectorSelection/index.jsx (+109 -0)
📝 frontend/src/pages/WorkspaceSettings/AgentConfig/index.jsx (+7 -0)
📝 server/endpoints/admin.js (+2 -0)
📝 server/models/systemSettings.js (+97 -17)
📝 server/package.json (+4 -0)
📝 server/utils/agents/aibitat/index.js (+12 -1)
📝 server/utils/agents/aibitat/plugins/index.js (+3 -0)
➕ server/utils/agents/aibitat/plugins/sql-agent/SQLConnectors/MSSQL.js (+89 -0)
➕ server/utils/agents/aibitat/plugins/sql-agent/SQLConnectors/MySQL.js (+59 -0)
➕ server/utils/agents/aibitat/plugins/sql-agent/SQLConnectors/Postgresql.js (+52 -0)
➕ server/utils/agents/aibitat/plugins/sql-agent/SQLConnectors/index.js (+60 -0)
➕ server/utils/agents/aibitat/plugins/sql-agent/get-table-schema.js (+98 -0)
➕ server/utils/agents/aibitat/plugins/sql-agent/index.js (+21 -0)
➕ server/utils/agents/aibitat/plugins/sql-agent/list-database.js (+49 -0)
➕ server/utils/agents/aibitat/plugins/sql-agent/list-table.js (+85 -0)

...and 20 more files

📄 Description

Pull Request Type

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

Relevant Issues

resolves #1298

What is in this change?

Support sql-agent skill for :
PostgreSQL
MySQL

Can list, discover, and run SQL commands. Users should not use a URI that can modify data unless they really want to risk that.

This PR also adds support for skill collections where one parent skill (eg sql-agent) can have many child-plugins that can be managed separately instead of one giant parameters call for a function.

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/1411 **Author:** [@timothycarambat](https://github.com/timothycarambat) **Created:** 5/15/2024 **Status:** ✅ Merged **Merged:** 5/16/2024 **Merged by:** [@timothycarambat](https://github.com/timothycarambat) **Base:** `master` ← **Head:** `1298-sql-agent-skill` --- ### 📝 Commits (7) - [`546d796`](https://github.com/Mintplex-Labs/anything-llm/commit/546d796ab7d24933b37dbf13d1c9487bed18ad03) Support SQL Agent skill - [`6a823fa`](https://github.com/Mintplex-Labs/anything-llm/commit/6a823fabb156c0fa3351848453e2b448213b85f9) add MSSQL agent connector - [`d9c31b7`](https://github.com/Mintplex-Labs/anything-llm/commit/d9c31b78f2eee4aa43ae07c76abf40904b5b133b) Add frontend to agent skills - [`3de338b`](https://github.com/Mintplex-Labs/anything-llm/commit/3de338b924d99bc5d3d7ca7de0c1f80f44a040f1) add prompt examples for tools on untooled - [`c404f84`](https://github.com/Mintplex-Labs/anything-llm/commit/c404f846f5ee8d9d7191f2e92323c48be6c3f2e0) add better logging on SQL agents - [`a184be9`](https://github.com/Mintplex-Labs/anything-llm/commit/a184be93c4cbe78e09c62a59f382982554535a72) Wipe toolruns on each chat relay so tools can be used within the same session - [`607d4b4`](https://github.com/Mintplex-Labs/anything-llm/commit/607d4b4417c133a74d54b02215793a2858be081f) update comments ### 📊 Changes **40 files changed** (+1745 additions, -59 deletions) <details> <summary>View changed files</summary> ➕ `frontend/src/pages/WorkspaceSettings/AgentConfig/SQLConnectorSelection/DBConnection.jsx` (+47 -0) ➕ `frontend/src/pages/WorkspaceSettings/AgentConfig/SQLConnectorSelection/NewConnectionModal.jsx` (+271 -0) ➕ `frontend/src/pages/WorkspaceSettings/AgentConfig/SQLConnectorSelection/icons/mssql.png` (+0 -0) ➕ `frontend/src/pages/WorkspaceSettings/AgentConfig/SQLConnectorSelection/icons/mysql.png` (+0 -0) ➕ `frontend/src/pages/WorkspaceSettings/AgentConfig/SQLConnectorSelection/icons/postgresql.png` (+0 -0) ➕ `frontend/src/pages/WorkspaceSettings/AgentConfig/SQLConnectorSelection/index.jsx` (+109 -0) 📝 `frontend/src/pages/WorkspaceSettings/AgentConfig/index.jsx` (+7 -0) 📝 `server/endpoints/admin.js` (+2 -0) 📝 `server/models/systemSettings.js` (+97 -17) 📝 `server/package.json` (+4 -0) 📝 `server/utils/agents/aibitat/index.js` (+12 -1) 📝 `server/utils/agents/aibitat/plugins/index.js` (+3 -0) ➕ `server/utils/agents/aibitat/plugins/sql-agent/SQLConnectors/MSSQL.js` (+89 -0) ➕ `server/utils/agents/aibitat/plugins/sql-agent/SQLConnectors/MySQL.js` (+59 -0) ➕ `server/utils/agents/aibitat/plugins/sql-agent/SQLConnectors/Postgresql.js` (+52 -0) ➕ `server/utils/agents/aibitat/plugins/sql-agent/SQLConnectors/index.js` (+60 -0) ➕ `server/utils/agents/aibitat/plugins/sql-agent/get-table-schema.js` (+98 -0) ➕ `server/utils/agents/aibitat/plugins/sql-agent/index.js` (+21 -0) ➕ `server/utils/agents/aibitat/plugins/sql-agent/list-database.js` (+49 -0) ➕ `server/utils/agents/aibitat/plugins/sql-agent/list-table.js` (+85 -0) _...and 20 more files_ </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 #1298 ### What is in this change? Support `sql-agent` skill for : PostgreSQL MySQL Can list, discover, and run SQL commands. Users should not use a URI that can modify data unless they _really_ want to risk that. This PR also adds support for skill `collections` where one parent skill (eg `sql-agent`) can have many child-plugins that can be managed separately instead of one giant `parameters` call for a function. ### 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:34:16 -05:00
yindo closed this issue 2026-02-22 18:34:16 -05:00
yindo changed title from [PR #1411] Support SQL Agent skill to [PR #1411] [MERGED] Support SQL Agent skill 2026-06-05 15:14:38 -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#3673
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?