Star Trek: The Next Generation Season 4 Episode 19

An alien probe transforms Barclay from a shy, awkward character into an arrogant super-genius who is able to interface with the Enterprise’s computer through the holodeck.