The correct answer is situational irony.
In this context, John claims to be "amazing at this" while simultaneously cleaning up the wreckage of his toothpick sculpture, which implies that he is not successful at it. This discrepancy between his claim and the reality of the situation illustrates situational irony.