Migrate database

[Alireza]

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

[n8n]

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:

[Jon]

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?

[Alireza]

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?

[Alireza]

any idea guys? @Jon

[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.

[Alireza]

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

[jan]

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

[Alireza]

thanks @jan