How to Set Up Your Own Postgres Database for N8N or Make.com

To set up your own Postgres database and integrate it with NHN workflow tools like N8N, you can either do it manually or use cloud services. I personally recommend using a VPS for this task, and I’m using a server from Hetzner that costs around five bucks a month. For managing the server, I utilize the Cloud Panel as a user interface.

First, let's clarify what we're aiming to achieve. The purpose of this database is to support projects and tools like N8N or MCPS.

Once you have your database set up, I created a specific database called ‘N8N_test’. Connecting to it is simple: all you need is to enter your server’s IP address, the database name, the username, and the password. After filling all this information, a quick click on ‘save’ will establish the connection successfully.

With the connection sorted, it’s time to start building! For demonstration, we’ll send a message from a chat and directly save it into a test table within our database. So, let’s open the chat interface and run a quick test with a message saying 'Test for YouTube'. After refreshing, voila! The text appears in our test table.

This process is straightforward. Utilizing drag-and-drop features allows you to manage your variables easily, and you can set up webhooks efficiently.

Setting up N8N alongside your Postgres database on a single server is a cost-effective solution. You avoid paying for superbase or similar services, and if like me, you want to experiment with your data and workflows, this setup offers you full control.

So, if you've tried using services like superbase or if you’ve set up your own Postgres instance, feel free to share your thoughts! It’s great to have your own testing environment and keep your data secure. Enjoy building!