If you want to find extremely tactical games, start by looking at extremely tactical players (Alekhine, Tal and Fischer and any other crazy chess guy you like).
Second best would be games between any grandmasters, regardless of the century the game was played. Chess tactics almost always show up even in the most positional of games.
If you want to find tactics that win early on, search for miniatures (games that end in a win in, let's say, less than 30 moves).
There are sites out there that let users save chess collections (chessgames.com is one example, there are a few good results if you search for tactics or famous players). But you said you have a database in which you wish to search, so you might not be interested in this.
Also not involving your chess database, you could find plenty of variety in tactics in books written by chess coaches or in video playlists created by chess coaches (my favourite example here would be MatoJelic, but there are many more).
If you want to find games that involve a lot of captures, search for the number of
x occurrences (if you have a database with games in PGN and you know regular expressions you could search for occurrences of
x in consecutive moves but that won't get you enough value for the effort, so i wouldn't recommend).
What you can't find are tactics that are avoided. At least you can't find them by looking at the game moves alone. You'll need a human to say what if...?, then make the move, then check with a computer.