"Tight" is slang for very close. So if you're talking about someone and you say "we're super tight", it means "we're really good friends". The word "tight" is like describing the bond between the two of you.

If you call someone "tight"it means that they are very frugal. "We're supertight" can mean that we are very frugal/miserly.