# Fetch data from SQL database and show that in dashboard

**URL:** <https://discourse.nodered.org/t/fetch-data-from-sql-database-and-show-that-in-dashboard/83128>\
**Category:** Dashboard\
**Tags:** node-red-dashboard\
**Created:** [23 November 2023 12:21 UTC](https://discourse.nodered.org/t/fetch-data-from-sql-database-and-show-that-in-dashboard/83128 "2023-11-23T12:21:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Subiksha](https://avatars.discourse-cdn.com/v4/letter/s/e5b9ba/32.png) [@Subiksha](https://discourse.nodered.org/u/Subiksha)\
**Post date:** [23 November 2023 12:21 UTC](https://discourse.nodered.org/t/fetch-data-from-sql-database-and-show-that-in-dashboard/83128/1 "2023-11-23T12:21:55Z")

</div>

I am all new to this NODE RED and to this world of automation. 🙂

I would like to know how to fetch data from SQL database and show that in my frontend created using template node (usinh html). Currently, I have a form in the frontend which has input field and when i type something in the form and click on submit, the data will be automatically transferred to SQL database. Now all I have to do is, showing this input value which is transferred to the sql again in the frontend as a separate thing and it should be just visible in frontend. How do I achieve the task of fetching data from SQL database and post in the dashboard ?

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [23 November 2023 20:41 UTC](https://discourse.nodered.org/t/fetch-data-from-sql-database-and-show-that-in-dashboard/83128/2 "2023-11-23T20:41:11Z")

</div>

Welcome to the forum @Subiksha

> [@Subiksha](#):
>
> How do I achieve the task of fetching data from SQL database and post in the dashboard ?

Start with how to fetch the data. What sort of SQL database is it?

---

<div class="post-metadata">

**Author:** ![Subiksha](https://avatars.discourse-cdn.com/v4/letter/s/e5b9ba/32.png) [@Subiksha](https://discourse.nodered.org/u/Subiksha)\
**Post date:** [24 November 2023 09:35 UTC](https://discourse.nodered.org/t/fetch-data-from-sql-database-and-show-that-in-dashboard/83128/3 "2023-11-24T09:35:02Z")

</div>

Hi ! Thanks for your response. 😊  
It am ms sql database.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [24 November 2023 09:44 UTC](https://discourse.nodered.org/t/fetch-data-from-sql-database-and-show-that-in-dashboard/83128/4 "2023-11-24T09:44:25Z")

</div>

I think the usual node to use with MSSQL server is node-red-contrib-mssql-plus. Give that a go and see if you are able to connect and query the db.

---

<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:** [24 December 2023 09:44 UTC](https://discourse.nodered.org/t/fetch-data-from-sql-database-and-show-that-in-dashboard/83128/5 "2023-12-24T09:44:50Z")

</div>

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