add http endpoint, make sure we SELECT correct db
retention http end-point