This study focuses on assessing the pozzolanic potential of two types of ceramic demolition waste, namely terracotta roof tiles and sanitary porcelain, as substitutes for traditional calcined clays in blended and limestone calcined clay (LC3) cement production. Experimental methods employed include the modified Chapelle test and XRD for pozzolanic activity evaluation, flexural and compressive strength tests, capillary absorption measurements, and SEM for microstructure analysis. Mortars containing 10%, 20%, and 30% ceramic powders and 5%, 10%, or 15% limestone filler were tested. The findings showed that porcelain powders exhibited lower pozzolanic activity due to their lower surface area and higher firing temperature of the material. Up to 20% substitution of OPC with terracotta had minimal strength impact, with a 103% strength activity index (SAI) at 90 days. Ultrafine terracotta powder showed promise in LC3 production with up to 30% OPC substitution, achieving a 97% SAI after 90 days. The poor mechanical properties of porcelain-containing mortars were explained by surfactants present in sanitary porcelain. This research informs the cement and processing industries on the potential use of specific ceramic demolition waste materials in eco-cement production, offering insights into blended pozzolanic cements and LC3 formulations, with the goal of reducing the carbon footprint of cement manufacturing.