You need an embassy visa for Saint Pierre and Miquelon if you have an Indian passport
Visa options for Saint Pierre and Miquelon
Visitor visa
To visit Saint Pierre and Miquelon for Business or Tourism, you require a visa. A paper or embassy visa is the only type of visa available for visitors. Typically the visa is a stamp or sticker added to your passport. You must submit your application through the consulate or local visa center. Visit the government website for details.