node-red-contrib-mssql-plus-box
A Node-RED node for connecting to Microsoft MS SQL Databases.
Importantly, this package comes with pre-built linux drivers for communicating with the Azure & MS SQL services (using TDS protocal), removing the need to set-up environment level MSSQL (or similar) drivers.
Added disconnect of database on each message input
Install
Easiest
Use the Manage Palette > Install option from the menu inside node-red
Harder
Alternatively in your Node-RED user directory, typically ~/.node-red, run
npm install node-red-contrib-mssql-plus-box
Other
This node based on node-red-contrib-mssql-plus. Thanks to Redconnect.io.