Deep Dive into Vector Databases for AI Agents