Is it possible to vibe-code a production-grade database?

Simple answer is no vibe coding isn't real.

Slightly longer answer, if you can't code you can't debug. If you can't debug nothing you get out of an AI prompt will work correctly.

The people that can use AI coding tools well can already write whatever thing they are tasked with the tool is just helping them write/debug/test faster.