Well it depends on which Database , the Technology  and the Costs involved in the project.

Few of the Tools are below:

1.Azure SQL Query Performance Insights - supports  Azure SQL DB

2.SQL Server Management Studio - supports SQL DB and Azure SQL DB

3.Toad SQL -  supports Oracle DB

There are many other tools available. As there is a huge shift towards Cloud technologies in the the market  Azure is gaining momentum.

I hope this answer helps.