Is getting an MS degree in the US after an MCA in India a possibility or just a dream?

It's definitely a possibility. Many US universities accept MCA graduates for MS programs, especially in computer science or related fields. However, you may need to meet specific prerequisites and demonstrate strong academic performance.