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!

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.

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