Migrate database

hi
I trying to customize the n8n database (postgres)
I added a specific column in the user table
now my question is how can I refresh the database to see that column?
or how can I migrate specific altered database files?

  • n8n version: 1.9.3
  • Database (default: SQLite): Postgres
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): npm
  • Operating system: linux

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:

Hey @Alireza,

Can you go into a bit more detail about what you are trying to do? Where are you trying to see the column you have added and how have you added it?

I’m trying to customize the n8n database (trying to add a column in the user table) now my question is how can I migrate that? (i need migration command) and which package n8n is used for database migration?

any idea guys? @Jon

Hey @Alireza,

We manually create the migration file, If you look in the migrations directory you can find other examples, It would just be a case of copying those.

thank you @Jon ,
but how can I migrate my migration file (I mean run the migration file, does n8n have any command for this)

If you did everything correctly, it will run the outstanding migration(s) automatically on startup.

thanks @jan