---
title: "FlowFuse Tables"
canonical_url: "https://flowfuse.com/docs/user/ff-tables/"
---

> Index of every page on this site: [llms.txt](https://flowfuse.com/llms.txt)

# FlowFuse Tables

<warning>

This feature is currently in [the beta state](https://flowfuse.com/handbook/engineering/releases/#beta-release).

</warning>

From FlowFuse v2.20.0 Teams (Enterprise teams only) can create a relational database to use to store data.

You can create a database by selecting the Tables entry in the left hand menu

![Screenshot of FF Tables create database menu](https://flowfuse.com/docs/user/images/tables/create-database.png)*Screenshot of FF Tables create database menu*

Once you have created a database you can use the wizard to create some tables. The wizard offers a subset of the most used column types and has the option to set default values and generate sequences for ids.

![Screenshot of create tables wizard](https://flowfuse.com/docs/user/images/tables/create-table-wizard.png)*Screenshot of create tables wizard*

Once the tables have data in them the rows will be displayed in the Explorer tab, 25 at a time. On a longer table, use the controls under the grid to move between pages or change how many rows are shown per page. Click a column's name to sort the whole table by that column, click again to turn the order around, and a third time to go back to the table's own order. A table with more than 10,000 rows shows its first 10,000, and its row count as 10000+. A table that big can only be sorted by its primary key.

![Screenshot of Tables Explorer](https://flowfuse.com/docs/user/images/tables/tables-ui-screenshot.png)*Screenshot of Tables Explorer*

## Query Nodes

FlowFuse Node-RED instances come with a Query Node that will be enabled if running in a Team with a FlowFuse Tables database enabled. This node will automatically import the required credentials to connect to the database.

![Screenshot of Node-RED query node](https://flowfuse.com/docs/user/images/tables/tables-query-node.png)*Screenshot of Node-RED query node*

## Postgres Clients

You can connect any Postgres Client to the FlowFuse Tables database using the information on the Credentials tab

![Screenshot of credentials](https://flowfuse.com/docs/user/images/tables/credentials.png)*Screenshot of credentials*

## Sitemap

See the full [sitemap](https://flowfuse.com/sitemap.md) for all pages.
