Making PostgreSQL a Better AI Database

Two new open-source extensions, pgai and pgvectorscale, have been developed to enhance PostgreSQL as an AI database. These extensions aim to improve the ease of use and unlock large-scale, high-performance AI use cases previously achievable only with specialized vector databases like Pinecone. The new extensions complement pgvector, a popular open-source extension for vector data in PostgreSQL, by adding unique capabilities that help developers use PostgreSQL to build AI applications. Pgvectorscale enables more scalable AI applications with higher-performance embedding search and cost-efficient storage, while Pgai brings more AI workflows to PostgreSQL, like embedding creation and model completion. These extensions are open source under the PostgreSQL license and can be used in AI projects today.