Have (a few) here in Berlin as well. Basically, it’s a room to inject. There’s usually a social worker to help guide people to programs, medical assistance, etc. when asked.

There are also “needle exchanges” where you can get new ones when you return used ones, to keep them off the street. Some may be operated in those rooms, but there are also automated boxes (basically vending machines) out on the streets.