Not going to be an "upgrade by default" thing - more of a manual upgrade.

Requirements:

• sane design
• not store server/world as a field - we just have contexts now
• not store contexts as a json string

I'm curious. What's wrong with the current schema?

Main issue is the way contexts are stored.

I see. Might as well store UUIDs as binary for additional optimization. Saves space and performance from my experience (binary indexes are a lot smaller and faster than text based ones)

Yes, planning to as well!

Maybe also instead of using uuids per each permission of a player, use the luckperms player table with ID

That would be even better. In principle at least.

I’d check which performs better. Because at that point I think performance is better than normalization.