Hello, just wanna ask; is the node-red-contrib-mssql still usable? I saw that its last update was more than 3 years ago, and it fails when I tried installing it. Or maybe there's another problem that keeps me from installing the node? I'm quite new to Node-RED, it will make me happy if someone could…

Hello everyone, thanks for all your reply. I am using Raspberry Pi, it seems my problem was with the incorrect time of my pi, thus having an error with the installation. I thought the problem was with the node itself, I am very sorry for all the trouble. Anyways, thanks for all the help, and thanks @…

I tried recently to load this module, and short of breaking open the original source of module and tracking down what is wrong, not likely. This node uses the query operation against the configured database. This does allow both INSERTS and DELETES. By its very nature it allows SQL injection. Al…

Oh, nuts... I did miss read that. Yeah, MS-SQL has some differences in SQL syntax and how it replies to queries. I supported both for years... every time MS would deviate, would drive the developers nuts.

There are a number of issues with node-red-contrib-mssql use node-red-contrib-mssql-plus instead - most of the bugs have been weeded out and there are tonnes of improvements. Improvements include... Built in help and examples Updated dependencies Perform multiple queries in one go & get back mul…

Using mustache to avoid potential injection? Plus not in NPM? I don't see updated module in palette install list?

Who said anything about using mustache to avoid SQL injection? And as colin points out - it is there!

I forgot the sarcastic emoji? The plus... I see it now... I must have fat fingered something when I searched.

So yes, it is possible to cause sql injection if you hook up user settable variables to the mustache parts however, if a user has access to node-red, irregardless of mustache, they can just as easily poke a drop database into the node - and that goes for any / all xxSQL nodes. Mustache is for conve…

I am really looking forward to the future improvement. It was not fun avoiding the injection scenario.

Node-RED

Node-RED Forum

MSSQL node-red installation problem

General

Steve-Mcl 15 August 2020 15:28 14

Parameters and execute mode now supported in mssql-plus V0.5.0

Topic		Replies	Views
Logging data in to SQL General	15	354	12 January 2024
Problem with install node-red-contrib-mssql-plus General	8	80	22 October 2025
How to install node-red-contrib-mssql-plus General	4	420	8 December 2023
UPDATED: node-red-contrib-mssql-plus 0.5.0 Share Your Nodes	1	420	14 October 2020
Node-red-contrib-mssql-plus 0.11.0 missing UI General node-red-contrib-mssql-plus	3	193	28 September 2023

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

MSSQL node-red installation problem

Related topics