The Microsoft SQL node is tied to only one database for insert, update, delete functions based on the credential tied to it

Feature Requests Nodes
1

It would help if Microsoft SQL node insert, update, and delete functions could point to other databases/schemas that the credential also has access to.

My use case:

It would be extremely beneficial if we could choose other databases from a drop down or if not at least type in the database name in the insert, update, delete functions. We have a few service accounts/users in SQL that can access multiple databases. The current way is to create multiple credentials per database using the same username and password this makes the credential lookup length long and confusing. Our current work around in some cases is to run the query option and manually set everything up because we can point to specific tables there but some tables are complex and it would be much easier for a simple insert.

Any resources to support this?

n8n MS SQL node

Are you willing to work on this?

Yes not a full dev expert but willing to learn and help out in any way I can.

1 Like
2

Thanks for the suggestion! This makes sense for users whose SQL service accounts can access multiple databases. Allowing the database to be selected (or entered manually) in the Insert, Update, and Delete operations would reduce duplicate credentials and simplify management. The Query workaround exists, but it defeats the purpose of having simple CRUD operations.