How to clean up DB record created during test run

If your application has a Delete option, then just write a little script/keyword test to go back and delete the records you've created.  



Another option is to have a backup with a copy of the database from before the test and then after the test is run, restore the backup automatically.