To identify unused tags in WordPress you can use the following snippet.

SELECT * From wp_terms terms 
INNER JOIN wp_term_taxonomy tax ON terms.term_id=tax.term_id 
WHERE tax.taxonomy='post_tag' AND tax.count=0;