Why developers are betting on Postgres for AI

PostgreSQL has become the leading database choice for AI applications, with 66% of Stack Overflow 2025 survey respondents preferring it. Key advantages include its true open-source community model, scalability (OpenAI's API runs on it), and extension architecture that supports vector workloads via pgvector — eliminating the need for standalone vector databases. Postgres can handle structured data, vector embeddings, and unstructured documents in one place, enabling RAG-based chatbots and agentic AI workflows. A notable gotcha: pgvector doesn't automatically update vectors when underlying content changes, requiring additional tooling for vector maintenance. pgEdge, the post's sponsor, offers an Agentic AI Toolkit including a vectorizer and MCP server to address these gaps.