# Accessing sqlite database tables

**URL:** <https://discourse.nodered.org/t/accessing-sqlite-database-tables/81132>\
**Category:** General\
**Tags:** database\
**Created:** [8 September 2023 07:01 UTC](https://discourse.nodered.org/t/accessing-sqlite-database-tables/81132 "2023-09-08T07:01:31Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rajendra](https://avatars.discourse-cdn.com/v4/letter/r/8e8cbc/32.png) [@rajendra](https://discourse.nodered.org/u/rajendra)\
**Post date:** [8 September 2023 07:01 UTC](https://discourse.nodered.org/t/accessing-sqlite-database-tables/81132/1 "2023-09-08T07:01:32Z")

</div>

i am having different tables in my local db. trying to insert node data into tables.  
i can able to select path for db and not for tables how to do that?

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [8 September 2023 07:28 UTC](https://discourse.nodered.org/t/accessing-sqlite-database-tables/81132/2 "2023-09-08T07:28:11Z")

</div>

Welcome to the forum!

First off it would be helpful to provide some more information than a general question. So with that in mind:

1. what version of Node-RED and node.js are you running? (you can find this in the Node-RED startup log)
2. what device are you running Node-RED on and what OS v version are you using?
3. what version of SQLite are you using
4. are you using Home Assistant or a Docker container?
5. and last but not least, what have you tried so far?

It would also be helpful it you created a small flow showing an example of what you are trying to do and then exported it and pasted it to a reply.

---

<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:** [7 November 2023 07:28 UTC](https://discourse.nodered.org/t/accessing-sqlite-database-tables/81132/3 "2023-11-07T07:28:33Z")

</div>

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