It has no negative or positive connotation, so you can consider it as neutral. It can of course be used in both a positive and negative manner but the connotation would be implied by the person using the word and the context.
For example:
'He's such a bookworm, isn't it adorable.' (positive)
'He's such a bookworm, he needs to leave the house occasionally and play outside like a normal teenager.' (negative)