# \#database **URL:** https://community.n8n.io/tag/database/335.md [Latest](https://community.n8n.io/latest.md) · [Categories](https://community.n8n.io/categories.md) · [Tags](https://community.n8n.io/tags.md) --- ## [Have you been noticing increased Postgres db connection timeouts lately?](https://community.n8n.io/t/have-you-been-noticing-increased-postgres-db-connection-timeouts-lately/311994)
**Author:** [@Eric\_OConnor](https://community.n8n.io/u/Eric_OConnor)\ **Replies:** 9\ **Last updated:** [October 16, 2026, 12:54am UTC](https://community.n8n.io/t/have-you-been-noticing-increased-postgres-db-connection-timeouts-lately/311994 "2026-10-16T00:54:32Z")
Describe the problem/error/question On the morning of 9/1/26, we upgraded our self-hosted N8N environment to v2.36.7. Later that morning, we started seeing spikes in errors. These errors were caused by timeouts attemptin… --- ## [Free tool: clean & dedupe messy B2B lead lists before your workflow](https://community.n8n.io/t/free-tool-clean-dedupe-messy-b2b-lead-lists-before-your-workflow/304349)
**Author:** [@Aleksey\_Panfil](https://community.n8n.io/u/Aleksey_Panfil)\ **Replies:** 0\ **Last updated:** [July 22, 2026, 6:42pm UTC](https://community.n8n.io/t/free-tool-clean-dedupe-messy-b2b-lead-lists-before-your-workflow/304349 "2026-07-22T18:42:13Z")
Made a small open-source tool for cleaning messy lead CSVs before they hit an n8n workflow: normalize inconsistent headers, validate emails offline, dedupe (keeps the most complete row), enrich company domains. Pure Pyth… --- ## [Inbuilt Database vs External DB Efficiency for 6,00,000+ rows and 40+ columns](https://community.n8n.io/t/inbuilt-database-vs-external-db-efficiency-for-6-00-000-rows-and-40-columns/284029)
**Author:** [@weblineindia](https://community.n8n.io/u/weblineindia)\ **Replies:** 8\ **Last updated:** [June 14, 2026, 7:23am UTC](https://community.n8n.io/t/inbuilt-database-vs-external-db-efficiency-for-6-00-000-rows-and-40-columns/284029 "2026-06-14T07:23:43Z")
We have a sheet with over 600,000+ rows and 40+ columns data and wanted to understand if n8n’s internal database will be able to efficiently process that data during workflow operations or better to use some external dat… --- ## [Per-project Data Tables size limit](https://community.n8n.io/t/per-project-data-tables-size-limit/298917)
**Author:** [@Tomasz\_Traczyk](https://community.n8n.io/u/Tomasz_Traczyk)\ **Replies:** 1\ **Last updated:** [June 11, 2026, 7:28am UTC](https://community.n8n.io/t/per-project-data-tables-size-limit/298917 "2026-06-11T07:28:16Z")
The idea is: Allow setting per-project upper bound on Data Tables size. Currently, only a global limit can be set via N8N\_DATA\_TABLES\_MAX\_SIZE\_BYTES. My use case: An enterprise self-hosted environment with per-team proj… --- ## [Deduplication Workflow: Only Add Genuinely New data to Your Database](https://community.n8n.io/t/deduplication-workflow-only-add-genuinely-new-data-to-your-database/298873)
**Author:** [@LCA-Optimize](https://community.n8n.io/u/LCA-Optimize)\ **Replies:** 2\ **Last updated:** [June 10, 2026, 2:45pm UTC](https://community.n8n.io/t/deduplication-workflow-only-add-genuinely-new-data-to-your-database/298873 "2026-06-10T14:45:02Z")
What this workflow does This workflow solves a problem you most likely hit when feeding data (leads, prospects, contacts, anything) into an existing database or Google Sheet. How it works, step by step 1. Manual Trigger… --- ## [Practical limits to N8N\_DATA\_TABLES\_MAX\_SIZE\_BYTES in self-hosted+Postgres setup](https://community.n8n.io/t/practical-limits-to-n8n-data-tables-max-size-bytes-in-self-hosted-postgres-setup/297897)
**Author:** [@Tomasz\_Traczyk](https://community.n8n.io/u/Tomasz_Traczyk)\ **Replies:** 7\ **Last updated:** [June 4, 2026, 7:51am UTC](https://community.n8n.io/t/practical-limits-to-n8n-data-tables-max-size-bytes-in-self-hosted-postgres-setup/297897 "2026-06-04T07:51:26Z")
Describe the problem/error/question N8N\_DATA\_TABLES\_MAX\_SIZE\_BYTES is the limit for the total size of all data tables in an n8n instance. The default is 50 MB. I’d like a recommendation on how far it is feasible to inc… --- ## [N8n isn't accepting my PostgreSQL configuration](https://community.n8n.io/t/n8n-isnt-accepting-my-postgresql-configuration/295467)
**Author:** [@Mr\_Kintu](https://community.n8n.io/u/Mr_Kintu)\ **Replies:** 6\ **Last updated:** [May 13, 2026, 1:12pm UTC](https://community.n8n.io/t/n8n-isnt-accepting-my-postgresql-configuration/295467 "2026-05-13T13:12:26Z")
have configured my .env file to use PostgreSQL instead of SQLite3: DB\_TYPE=postgresdb DB\_POSTGRESDB\_HOST=localhost DB\_POSTGRESDB\_PORT=5432 DB\_POSTGRESDB\_DATABASE=n8n DB\_POSTGRESDB\_USER= DB\_POSTGRESDB\_PASSWORD= Use… --- ## [\[Workflow\] LinkedIn Company Enricher — $2.50/1K domains, no subscription](https://community.n8n.io/t/workflow-linkedin-company-enricher-2-50-1k-domains-no-subscription/291818)
**Author:** [@YoneCode](https://community.n8n.io/u/YoneCode)\ **Replies:** 0\ **Last updated:** [April 27, 2026, 7:00am UTC](https://community.n8n.io/t/workflow-linkedin-company-enricher-2-50-1k-domains-no-subscription/291818 "2026-04-27T07:00:59Z")
I built an Apify actor that turns domain lists into LinkedIn company profiles. Made free n8n workflows so you can drop it into any automation. Price: $2.50 per 1,000 successful lookups. First 100 results free. No subscr… --- ## [How do I create a firestore document](https://community.n8n.io/t/how-do-i-create-a-firestore-document/278272)
**Author:** [@Punosie](https://community.n8n.io/u/Punosie)\ **Replies:** 5\ **Last updated:** [March 17, 2026, 7:07pm UTC](https://community.n8n.io/t/how-do-i-create-a-firestore-document/278272 "2026-03-17T19:07:31Z")
Problem: I only want the stuff inside the “formatted” object in the root of the document. How do I reference it inside the firestore db node. I tried using the key json in the columns/Attributes section but to no … --- ## [Possible to Reduce Database Size by Deleting From "insights\_raw" Table](https://community.n8n.io/t/possible-to-reduce-database-size-by-deleting-from-insights-raw-table/270108)
**Author:** [@MarleTangible](https://community.n8n.io/u/MarleTangible)\ **Replies:** 2\ **Last updated:** [February 25, 2026, 7:06pm UTC](https://community.n8n.io/t/possible-to-reduce-database-size-by-deleting-from-insights-raw-table/270108 "2026-02-25T19:06:57Z")
Describe the problem/error/question Hello, Is it possible to delete data from the “insights\_raw” table to reduce the database size? Insights are already turned off, so there won’t be any need for it at the moment, but t… --- ## [How to connect redshift db using postgres connection](https://community.n8n.io/t/how-to-connect-redshift-db-using-postgres-connection/232896)
**Author:** [@NOUREEN\_NASAR\_206223](https://community.n8n.io/u/NOUREEN_NASAR_206223)\ **Replies:** 1\ **Last updated:** [January 18, 2026, 11:21pm UTC](https://community.n8n.io/t/how-to-connect-redshift-db-using-postgres-connection/232896 "2026-01-18T23:21:50Z")
Describe the problem/error/question I have n8n hosted in my VPS, and I want to connect to redshift database. Since there is no redshift node, I am trying to achieve this using postgres node. I could not find any detailed… --- ## [Data tables 'object' column](https://community.n8n.io/t/data-tables-object-column/233637)
**Author:** [@syadnom](https://community.n8n.io/u/syadnom)\ **Replies:** 0\ **Last updated:** [December 9, 2025, 4:32pm UTC](https://community.n8n.io/t/data-tables-object-column/233637 "2025-12-09T16:32:33Z")
The idea is: Add an object type to data tables for columns so it’s simpler to store json data My use case: some data from my object store changes rarely, but the queries add a lot of time to my workflows. I’m using dat… --- ## [How to update a table with fresh data on a fixed interval](https://community.n8n.io/t/how-to-update-a-table-with-fresh-data-on-a-fixed-interval/226396)
**Author:** [@OgnyanGuglev](https://community.n8n.io/u/OgnyanGuglev)\ **Replies:** 8\ **Last updated:** [December 4, 2025, 1:37pm UTC](https://community.n8n.io/t/how-to-update-a-table-with-fresh-data-on-a-fixed-interval/226396 "2025-12-04T13:37:41Z")
Describe the problem/error/question I am managing a self-service indoor tennis club. I have a booking platform which I use to manage the courts and the users. My club has two courts. I want to implement an AI chatbot on … --- ## [JSON input for Data table node](https://community.n8n.io/t/json-input-for-data-table-node/217661)
**Author:** [@bedwards](https://community.n8n.io/u/bedwards)\ **Replies:** 1\ **Last updated:** [November 7, 2025, 7:23am UTC](https://community.n8n.io/t/json-input-for-data-table-node/217661 "2025-11-07T07:23:26Z")
Data Tables + AI Agent: where/how to define JSON for reliable row updates? Goal I’m moving a simple “employee update” use case from Google Sheets to beta Data Tables and want best-practice guidance on where/how to defin… --- ## [Is it possible to modify n8n to use Oracle Database instead of PostgreSQL?](https://community.n8n.io/t/is-it-possible-to-modify-n8n-to-use-oracle-database-instead-of-postgresql/212463)
**Author:** [@Gilbert\_HG](https://community.n8n.io/u/Gilbert_HG)\ **Replies:** 6\ **Last updated:** [October 29, 2025, 4:33am UTC](https://community.n8n.io/t/is-it-possible-to-modify-n8n-to-use-oracle-database-instead-of-postgresql/212463 "2025-10-29T04:33:06Z")
Hi everyone, I’m exploring whether it’s possible to modify the n8n backend to use Oracle Database instead of PostgreSQL. Has anyone tried running n8n with Oracle as the main database backend? I understand that Postgre… --- ## [Data Tables not working when storing BAse64 string in a column](https://community.n8n.io/t/data-tables-not-working-when-storing-base64-string-in-a-column/210542)
**Author:** [@Theis](https://community.n8n.io/u/Theis)\ **Replies:** 0\ **Last updated:** [October 23, 2025, 2:49pm UTC](https://community.n8n.io/t/data-tables-not-working-when-storing-base64-string-in-a-column/210542 "2025-10-23T14:49:53Z")
Hey, so was playing with the idea of storing images in the native Data Tables (beta) by converting files into a Base64 string and then storing in a cell. When needed to be called it could then convert the base64 string i… --- ## [Critical Issue: Unable to Recover Workflows From Old Database After Config File Corruption](https://community.n8n.io/t/critical-issue-unable-to-recover-workflows-from-old-database-after-config-file-corruption/198838)
**Author:** [@jakejake](https://community.n8n.io/u/jakejake)\ **Replies:** 1\ **Last updated:** [October 3, 2025, 11:56am UTC](https://community.n8n.io/t/critical-issue-unable-to-recover-workflows-from-old-database-after-config-file-corruption/198838 "2025-10-03T11:56:39Z")
Hello n8n community, I’m facing a critical and very strange issue where I cannot access my old workflows after my instance’s config file was found to be corrupted. I would be extremely grateful for any expert insight. T… --- ## [Using AI Agents to query and analyze project data securely in n8n](https://community.n8n.io/t/using-ai-agents-to-query-and-analyze-project-data-securely-in-n8n/195354)
**Author:** [@fatiimahoseini](https://community.n8n.io/u/fatiimahoseini)\ **Replies:** 0\ **Last updated:** [September 27, 2025, 10:22am UTC](https://community.n8n.io/t/using-ai-agents-to-query-and-analyze-project-data-securely-in-n8n/195354 "2025-09-27T10:22:01Z")
Hi everyone, I’m working on a scenario where I want to build a bot that holds data about a series of tasks and projects, and users can interact with it to ask questions. For example: “Which tasks are left for today?” “… --- ## [New version 1.113.2 table question](https://community.n8n.io/t/new-version-1-113-2-table-question/194321)
**Author:** [@joulong\_leu](https://community.n8n.io/u/joulong_leu)\ **Replies:** 4\ **Last updated:** [September 25, 2025, 1:50pm UTC](https://community.n8n.io/t/new-version-1-113-2-table-question/194321 "2025-09-25T13:50:24Z")
I want to data table add column using Traditional Chinese but cannot add it,Use English is OK use New version 1.113.2 --- ## [Workflows shutting down by themselves](https://community.n8n.io/t/workflows-shutting-down-by-themselves/193227)
**Author:** [@joao-guioto](https://community.n8n.io/u/joao-guioto)\ **Replies:** 1\ **Last updated:** [September 24, 2025, 1:02pm UTC](https://community.n8n.io/t/workflows-shutting-down-by-themselves/193227 "2025-09-24T13:02:38Z")
I have about 40 workflows divided into several folders and running them on AWS on a 2CPU, 4RAM instance, containerized and using SQLite as the DB. It happens that, at certain times (practically weekly), workflows in a f… --- ## [How do I create a workflow that retrieves images from the database when I ask the agent to display them?](https://community.n8n.io/t/how-do-i-create-a-workflow-that-retrieves-images-from-the-database-when-i-ask-the-agent-to-display-them/184208)
**Author:** [@astrumax](https://community.n8n.io/u/astrumax)\ **Replies:** 2\ **Last updated:** [September 9, 2025, 8:58am UTC](https://community.n8n.io/t/how-do-i-create-a-workflow-that-retrieves-images-from-the-database-when-i-ask-the-agent-to-display-them/184208 "2025-09-09T08:58:59Z")
Hey everyone,I’m trying to build a workflow in n8n where an AI Agent can respond with an image whenever I ask something like: “Show me the image of product X” or “Display the stored picture for Y”. Describe the problem… --- ## [Supabase Database Connection Issues in Queue Mode](https://community.n8n.io/t/supabase-database-connection-issues-in-queue-mode/161980)
**Author:** [@jkf](https://community.n8n.io/u/jkf)\ **Replies:** 1\ **Last updated:** [August 27, 2025, 7:45am UTC](https://community.n8n.io/t/supabase-database-connection-issues-in-queue-mode/161980 "2025-08-27T07:45:47Z")
I have n8n deployed on fly.io, with one main instance and 1-3 worker instances that scale up based upon queue depth. The database I use for storing the 8n database is postgres via Supabase. n8n version is 1.105.2 As e… --- ## [Storing Chatbot Session Data using Workflow Static Data VS Postgres](https://community.n8n.io/t/storing-chatbot-session-data-using-workflow-static-data-vs-postgres/168081)
**Author:** [@Fatimah\_M](https://community.n8n.io/u/Fatimah_M)\ **Replies:** 2\ **Last updated:** [August 18, 2025, 2:39am UTC](https://community.n8n.io/t/storing-chatbot-session-data-using-workflow-static-data-vs-postgres/168081 "2025-08-18T02:39:35Z")
TL;DR: I’m building a WhatsApp chatbot in n8n (via WAHA) and need to store session data (phone, last timestamp, status) to prevent spam replies and allow human takeover mode. Options: Workflow static data: fast, but… --- ## [Trying to identify duplicate Supabase DB rows and iterate only on the duplicates](https://community.n8n.io/t/trying-to-identify-duplicate-supabase-db-rows-and-iterate-only-on-the-duplicates/155651)
**Author:** [@Pixabits](https://community.n8n.io/u/Pixabits)\ **Replies:** 8\ **Last updated:** [July 24, 2025, 7:27pm UTC](https://community.n8n.io/t/trying-to-identify-duplicate-supabase-db-rows-and-iterate-only-on-the-duplicates/155651 "2025-07-24T19:27:19Z")
Describe the problem/error/question I am building a service where users can make new requests. Nothing is stopping a user from submitting the same request multiple times. So after receiving a new request, I am checking… --- ## [How to store links from RSS Read in datastore and how to remove duplicates to send on Discord server?](https://community.n8n.io/t/how-to-store-links-from-rss-read-in-datastore-and-how-to-remove-duplicates-to-send-on-discord-server/154257)
**Author:** [@MJeat](https://community.n8n.io/u/MJeat)\ **Replies:** 0\ **Last updated:** [July 22, 2025, 4:03pm UTC](https://community.n8n.io/t/how-to-store-links-from-rss-read-in-datastore-and-how-to-remove-duplicates-to-send-on-discord-server/154257 "2025-07-22T16:03:51Z")
Describe the problem/error/question Hello im working on a project automation on n8n workflow to send cybersecurity news to a discord server. Here’s how it works: First, i used schedule trigger node daily or every 24 ho… --- ## [Hey i am doing an n8n automation and i have problem with mysql execute query](https://community.n8n.io/t/hey-i-am-doing-an-n8n-automation-and-i-have-problem-with-mysql-execute-query/144721)
**Author:** [@Shri\_J](https://community.n8n.io/u/Shri_J)\ **Replies:** 2\ **Last updated:** [July 19, 2025, 12:27pm UTC](https://community.n8n.io/t/hey-i-am-doing-an-n8n-automation-and-i-have-problem-with-mysql-execute-query/144721 "2025-07-19T12:27:00Z")
Hi there guys i need help with my automation. I have given my database schema to my ai agent which generates queries according to the database schema And i execute it in my mysql node The problem is that sometimes the… --- ## [Heroko n8n auto database update role issue](https://community.n8n.io/t/heroko-n8n-auto-database-update-role-issue/152014)
**Author:** [@Patrick\_Mclean](https://community.n8n.io/u/Patrick_Mclean)\ **Replies:** 0\ **Last updated:** [July 18, 2025, 3:00pm UTC](https://community.n8n.io/t/heroko-n8n-auto-database-update-role-issue/152014 "2025-07-18T15:00:12Z")
So it looks like Heroku did an automatic database update. I just noticed this in an older dev box. I’m not an expert but it appears that the update wiped the n8n database? users and roles? Anyone know how to recover this… --- ## [Gcloud n8n startup very slow - selfhosted](https://community.n8n.io/t/gcloud-n8n-startup-very-slow-selfhosted/135204)
**Author:** [@schtiewen](https://community.n8n.io/u/schtiewen)\ **Replies:** 1\ **Last updated:** [June 25, 2025, 11:58am UTC](https://community.n8n.io/t/gcloud-n8n-startup-very-slow-selfhosted/135204 "2025-06-25T11:58:06Z")
Hi, I’ve created a docker file for a google cloud deployment. It works, but the starting process is very slow. it tooks minutes. i’m using theese env variables: # db DB\_TYPE=postgresdb DB\_POSTGRESDB\_HOST=/cloudsql/\ **Author:** [@Zachary\_Wolpov](https://community.n8n.io/u/Zachary_Wolpov)\ **Replies:** 0\ **Last updated:** [June 24, 2025, 9:55pm UTC](https://community.n8n.io/t/struggling-to-backfill-airtable-database-with-hundreds-of-meeting-transcripts/138067 "2025-06-24T21:55:24Z") Describe the problem/error/question I’m trying to use n8n to backfill my Airtable database with hundreds of transcripts from our company’s meetings. The current workflow steps I’m using are: Retrieve all new meeting tr… --- ## [Having trouble during RDS Postgres Connectivity](https://community.n8n.io/t/having-trouble-during-rds-postgres-connectivity/87363)
**Author:** [@Ravindra\_Sai](https://community.n8n.io/u/Ravindra_Sai)\ **Replies:** 3\ **Last updated:** [March 18, 2025, 9:36am UTC](https://community.n8n.io/t/having-trouble-during-rds-postgres-connectivity/87363 "2025-03-18T09:36:59Z")
Describe the problem/error/question Unable to connect RDS POSTGRES from n8n container for internal data use the typical command i use for this , surprisingly from the same machine i’m able to connect through psql client … [Next page](https://community.n8n.io/tag/database/335.md?match_all_tags=true&page=1&tags%5B%5D=database)