Benefit of client-side connection vs server?

I’m trying to connect and send data to my database. Is there a benefit to connecting to an endpoint which then uses the server to connect to the database or is it easier to just do it on the client side?

I guess I am just trying to wrap my head around use case of client-side database connections vs sever side