Hi i want to delete the stale data from the hydra db. I am using hydra v2.2.0. Is there any article to follow ? Also how can i verify that in database that which data is delete and which is not ?

You are probably looking for this: https://www.ory.sh/docs/hydra/cli/hydra-janitor

Thanks for sharing it. I have further one question that , Is there a way to cleanup manually using db scripts ? If yes then in what sequence we should implement it ?

Is there a way to cleanup manually using db scripts

probably but I can't give you advice for this we can offer you more direct support with a support agreement, if you have a budget please contact here https://ory.sh/contact