Helper functions for AI workflows in PostgreSQL
pgext.cloud · Source code · Documentation · License text · Control file
| Package | pgai |
|---|---|
| Version | 0.11.3-dev |
| PostgreSQL versions | 16 · 17 · 18 |
| Repository | Unspecified |
| Extension type | SQL only |
| Project status | Archived |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Schema | ai |
| Stars | 5,806 |
| Latest commit | 2026-05-27 |
| Latest release | 2025-10-14 |
| Catalogue updated | 2026-08-30 |
| plpython3u | PL/Python3U untrusted procedural language |
| vector | vector data type and ivfflat and hnsw access methods |
| tencentdb_ai | TencentDB extension for calling large-model APIs and building in-database RAG workflows. |
| pg_deeplake | Deeplake is AI Data Runtime for Agents. It provides serverless postgres with a multimodal datalake, enabling scalable retrieval and training. |
| pgtoken | PostgreSQL extension for compact, codebook-compressed LLM token ID storage. Encode once, retrieve forever. O(1) token count without decoding. |
| ollama | Ollama client for PostgreSQL |
| ai_toolkit | AI-powered query generation and explanation tools for PostgreSQL. |
| rds_ai | Alibaba Cloud RDS extension for calling LLMs, generating embeddings, semantic retrieval, and end-to-end RAG from SQL |
| avocado | AvocadoDB PostgreSQL extension for deterministic context compilation for AI agents. |
| lantern_extras | Convenience functions for working with vector embeddings |
| pgclaw | Store LLM or OpenClaw agents as PostgreSQL values and process watched rows with a background worker |
| google_ml_integration | Google Cloud machine learning integration extension for registering model endpoints, generating embeddings, and invoking predictions from SQL. |
| pg_llm | Integrates local and remote large-language models with chat, sessions, text-to-SQL, audit and vector-backed knowledge features. |
| pg_ai | PostgreSQL extension that provides (RAG capable)SQL functions to interpret data using multi modal LLMs and vectors. |
| pgai | In-database predictive analytics using LSTM, Prophet, ARIMA, and SARIMA models. |