Mods that don't affect gameplay or world generation can be used across both single-player and multiplayer worlds. Mods that do affect gameplay or world generation can only be used in single-player worlds.