# Available Now: Node Red Microsoft SQL Server Storage Plugin

**URL:** <https://discourse.nodered.org/t/available-now-node-red-microsoft-sql-server-storage-plugin/21649>\
**Category:** Share Your Nodes\
**Created:** [13 February 2020 12:13 UTC](https://discourse.nodered.org/t/available-now-node-red-microsoft-sql-server-storage-plugin/21649 "2020-02-13T12:13:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![gingerhelp](https://avatars.discourse-cdn.com/v4/letter/g/dc4da7/32.png) [@gingerhelp](https://discourse.nodered.org/u/gingerhelp)\
**Post date:** [13 February 2020 12:13 UTC](https://discourse.nodered.org/t/available-now-node-red-microsoft-sql-server-storage-plugin/21649/1 "2020-02-13T12:13:37Z")

</div>

Hello all,

I have just finished publishing a storage plugin for Microsoft SQL Server here:

> **[node-red-contrib-mssql-storage-plugin](https://www.npmjs.com/package/node-red-contrib-mssql-storage-plugin)**
>
> Node-RED Storage Plugin For Microsoft SQL Server

With this plugin you can store your flows, configuration, settings, sessions, and library into a Microsoft SQL Server database as opposed to JSON files. The plugin was inspired by the MongoDB storage plugin by adibenmati ([https://github.com/adibenmati/node-red-mongo-storage-plugin](https://github.com/adibenmati/node-red-mongo-storage-plugin)).

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/7/47420694a8fa93de20745b2cfffda4aa4957d202.png)

I created this because there is a great degree of comfort level with SQL Server among the teams I am working with - they already have backup plans in place, security, and generally prefer all data live under one roof. Also, SQL Server has great JSON support nowadays should I ever need to query / update / compute columns on the data. Fortunately the simple storage API made this come together with just a few hours of work.

One known bug with the current release - I am able to save library entries just fine but am not connecting the dots somewhere on what properties need to be present on the object when selecting to install an item from the library. Perhaps somebody out there will have a pointer on that.

Let me know if anybody has any problems!  
Adam

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [13 February 2020 13:45 UTC](https://discourse.nodered.org/t/available-now-node-red-microsoft-sql-server-storage-plugin/21649/2 "2020-02-13T13:45:38Z")

</div>

Nice, thanks for sharing. Hope you don't mind, I changed the group to "Share Your Nodes" from "General".

---

<div class="post-metadata">

**Author:** ![gingerhelp](https://avatars.discourse-cdn.com/v4/letter/g/dc4da7/32.png) [@gingerhelp](https://discourse.nodered.org/u/gingerhelp)\
**Post date:** [13 February 2020 13:59 UTC](https://discourse.nodered.org/t/available-now-node-red-microsoft-sql-server-storage-plugin/21649/3 "2020-02-13T13:59:19Z")

</div>

Great - thanks!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [13 April 2020 13:59 UTC](https://discourse.nodered.org/t/available-now-node-red-microsoft-sql-server-storage-plugin/21649/4 "2020-04-13T13:59:19Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.