Pgai: Giving PostgreSQL Developers AI Engineering Superpowers

Pgai is an open-source extension for PostgreSQL that aims to bring more AI workflows closer to the database, making it an even better choice for AI applications. The extension supports tasks like embedding creation and model completion, simplifying the process of building search and retrieval-augmented generation (RAG) applications. Pgai is designed to help developers familiar with PostgreSQL build production-ready AI applications more easily by providing them with additional tools to streamline their workflows. The initial release of pgai supports OpenAI models, but future plans include adding support for other models like Claude and Cohere, as well as open-source embedding and generation models via Ollama and HuggingFace endpoints. Pgai is available on Timescale's cloud PostgreSQL platform and can be accessed through the pgai GitHub repository.