This service allows users to query the ALeRCE database tables without needing any authentication. This API includes services to query objects filtering them by id,number of detections, class, class probabilities, coordinates, or detection times. Users can also get the associated sql command for a given query, get all the detections for a given object, get all the non–detections for a given object, get the classification probabilities for a given object, or get the features used as input for the machine learning classifiers for a given object. This service is used in the ALeRCE explorer and the SN Hunter.