The correct answer is situational irony.
In the sentence, John claims to be "amazing" at his sculpture while he is actually cleaning up the remnants of it, which implies that it has fallen apart. This situation contrasts his statement of being skilled at something that has clearly failed, hence the situational irony.