It depends on how and when you ask, of course. If you’re on a date I think it’s a great question - many people love talking about themselves. It’s perhaps a cultural thing too, Western society is very individualist and so asking a question like that makes sense. Other cultures may have different values, and it could be seen as conceited to up-talk yourself.
Exactly, forming it as an open ended, permission based question is far better. "Hey would you mind telling me a little about yourself?" Is much more comfortable. It is more conversational.