Answering my own question, you can make a custom migration by running

prisma migrate dev --create-only

To rename a table you need to add to the migration file:

ALTER TABLE "users" RENAME TO "User";
ALTER TABLE "User" RENAME CONSTRAINT "users_pkey" TO "User_pkey";

for each table name you want to change. With that being said, next-auth sure doesn't make it easy to update their prisma connector to the latest version. There are also a number of fields in the

users

,

accounts

and

sessions

tables that you'll have to change the name of along with the table names themselves. I'll post a reply if I can figure out the specific prisma migration needed to make that work.