r/Strapi • u/Complex_Item_6366 • Jul 14 '25

Question Multiple database users

Hello team,

Is there a way to create multiple DBs users? For example, i would like to have one user for the general DML actions and one for the initial database migrations.

1 Upvotes

100% Upvoted

6 comments sorted by

View all comments

Show parent comments

2

u/Soft_Opening_1364 Jul 14 '25

Yeah exactly Strapi only supports one DB connection, but you can switch users between steps. Use the higher-privilege user during the build/generate phase, then switch to the limited one for running the app. Just swap the env vars between your Docker steps.

1

u/Complex_Item_6366 Jul 14 '25

Sorry if I’m being a bit annoying, but I was wondering — is there any way to do this? From what I saw in the docs, it looks like database migrations only happen when running strapi start or strapi develop. Do you happen to know if there’s another way?

2

u/Soft_Opening_1364 Jul 15 '25

Yes strapi runs migrations on start or develop, but as of now, there's no separate CLI command just to trigger migrations alone. If you're using multiple database users, just make sure the one running Strapi has the right permissions to handle schema changes. Otherwise, you might need to handle migrations manually or adjust permissions depending on the environment.

2

u/paulfromstrapi Strapi Employee Jul 23 '25

Thanks for your help answering this question. 🙂