You need an embassy visa for New Caledonia if you have an Indian passport
Visa options for New Caledonia
Visitor visa
Travelers need a visa to visit New Caledonia for Business or Tourism. A paper or embassy visa is the only visa available for travelers visiting New Caledonia. The visa is typically a stamp or sticker added to the passport. Travelers must obtain this visa from a local embassy, consulate, or visa center before traveling.