Data Tables Are Here! 📊

Hey everyone :waving_hand:

We’re super excited to share that starting with v1.113 we’re rolling out data tables (beta) to all plans. :bar_chart:

Since the very beginning of n8n we’ve heard many of you mention the need for a proper table inside n8n to store data between workflow executions without needing to switch platforms or setting up credentials and now it’s finally here.

With data tables you can:

  • Save specific data from your workflow runs

  • Keep data around between multiple executions

  • Avoid duplicate runs by tracking execution status

  • Store reusable prompts for different workflows

  • Collect evaluation data for your AI workflows

  • Do lookups, merges, enhancements…

  • …and honestly, probably 100 other creative things we haven’t even thought of yet :smiley:

:backhand_index_pointing_right: To make sure your instance stays performant, we’ve set a 50MB limit for everyone. If you’re self-hosting (and know what you’re doing), you can change that via the ENV variable N8N_DATA_TABLES_MAX_SIZE_BYTES

:loudspeaker: Upgrade to 1.113, give data tables a spin, and let us know what you think! What’s missing? What would make it even more useful for you? We’re really curious to hear your ideas and thoughts! :blush:

:link: Read more about the data tables in the docs here.

42 Likes

:tada::tada::confetti_ball::confetti_ball: I am so excited for this. I can’t wait to hear people’s feedback :grin:

7 Likes

This is absolutely awesome to see, I can’t wait to use these! It’s probably been my number one frustration that saving even a small amount of data between executions for all sorts of purposes requires either integrating PostgreSQL and dealing with schemas, using a third party database or API like Supabase (as handy as they are), or using variables that are powerful but are somewhat clumsy to instantiate and track since they only work in Code nodes and only save data for production executions, making testing hard. Hoping data-tables makes a ton of these things easier! Probably won’t run the new version until it’s in final release rather than pre-release, but this is awesome to see!

4 Likes

This is really great - when I migrated from “the other platform” almost 4 years ago, I really felt the pain of not having a simple in-app data storage. I played around with Data tables this weekend and it’s just SUCH a good and fast experience! Kudos to our Product and Engineering teams :clap:

3 Likes

Hey all,

IMPORTANT NOTE: There is an issue with very large SQLite databases that is causing instances to slow down. Out of an abundance of caution, we are unfortunately removing version 1.113.0 until we fix this issue. We hope to have this released again with a fix within the next couple of days.

Very sorry about this!

10 Likes

This is great!

It´d be cool for self hosting to be able to add a second DB, where n8n pulls the data from. So one could have performance without having to set up each time a postgres connection.

2 Likes

Data tables is back on!

A patch was released earlier today. It has now been tested and we have high confidence. Please update to 1.113.1 (which is still in beta) to try this feature.

4 Likes

is that Data Tables only available for the Cloud version? local host will not have Data Tables?

1 Like

It’s on all plans (cloud and self hosted) starting on version 1.113.1 :slightly_smiling_face:

2 Likes

I am unable to see the data tables in my local self hosted n8n. I’ve also updated the docker image to pick the latest one. What am I missing?

1 Like

Does this mean we can share data between multiple workflows now? This would make splitting up complex workflows across multiple workflows so much easier.

1 Like

I believe this is still only available in the beta version?

1 Like

The fact that the “latest” is not “1.113.1”. The latest is “the latest stable”, where 1.113.1 is not that.

3 Likes

Very happy to see this feature. I’ve been testing it out, and was commenting feedback on Reddit but someone in the Discord server said the forums is the best place to post this instead. Here’s my list(so far)

  1. When going to the Data Tables tab, “Create Table” is not default on the upper right button, it’s defaulted to “Create Workflow” instead.

  2. Cannot change the data type after a column is created.

  3. Cannot set any of the column’s as primary or unique such as the ID column (To prevent duplicates)

  4. For some odd reason, setting a column data type to “number” then pushing data from JSON array into the table, physically opening the table and looking at the rows, the numbers in the “number” data type column are not all together. For example “29683389” shows in the table as “29 683 389”. This isn’t a one off either, ALL rows exhibit the same behavior and ALL columns set as “numbers” too.

  5. Table page can only show 50 rows per page. Which I understand is probably for performance reasons. However, there really needs to be a “search” function for the table to search for data.

Are there any limitations for creating tables?
or we can create multiples/unlimited (in 50Mb limit)?

1 Like

Love this list @compaholic, thanks so much for sharing it.
1, 2 and 5 are all planned. For (4), I think that is just a highlighting to make it easier to read that it’s actually 29M. So the number should still be correct.

You can created unlimited ones within the storage limit :slight_smile: