Vector databases like Pinecone, Weaviate, and Supabase pgvector store text as numerical vectors and enable similarity search, finding semantically related content rather than exact keyword matches. They are the memory layer for AI agents, allowing them to retrieve relevant context from large knowledge bases at query time.