My test suite passed a service that deletes the entire database on startup.

Eighteen scenarios, eighteen green. The service drops every table before it accepts a single request, then serves every endpoint correctly and enforces every business rule, returning exactly the right answers about the empty space where the data used to be.

I want to walk through why, because the reason is not "my tests were bad", and it took me a while to accept that.

The tests are not the problem

That was my first assumption too.