List collections

Returns a list of all collections within the specified database and tenant. Supports pagination through limit and offset parameters.