List of PostgreSQL® AI projects and resources

A curated list of PostgreSQL® project including or addressing AI

This list includes projects, extensions or demos showcasing how to use PostgreSQL® in the AI landscape

➕ Extensions

• pgvector: open-source vector similarity search for PostgreSQL. Includes vector storage and similarity search, as well as IVFFlat and HNSW indexing
• pg_vectorize: open-source PostgreSQL extension that automates the transformation and orchestration of text to embeddings, allowing vector and semantic search on existing data with as little as two function calls.
• postgresml: Generative AI and Simple ML with PostgreSQL. Perform Text classification, Translation, Summarization directly in SQL within the PostgreSQL database.
• azure_ai: Enables you to integrate Azure AI services with your operational data
• azure_local_ai: Enables you to generate embeddings within the PostgreSQL database.
• pgai: Enables you to generate embeddings within the PostgreSQL database. Developed by Timescale
• pgvectorscale: Works in conjunction with pgvector and adds the DiskANN indexing type. Developed by Timescale

💡 Applications

🤖 Bots

• PostgresAI bot: a PostgreSQL expert bot, by PostgresAI

📑 Text to SQL and SQL to Text

• Text to SQL: auto-generate SQL queries from text for free by EverSQL by Aiven
• SQL to Text: explains in plain english what your SQL query does by EverSQL by Aiven

⚡️ Query Optimizer

• Aiven SQL Query Optimizer: AI-driven query optimizer based on SQL and database metadata. Monitor your database and receive performance insights and improvement suggestions for free

🎛️ Configuration Tuning

• Ottertune: AI to optimize your Amazon RDS and Aurora database Ottertune is no longer a company
• DBTune: AI driven PostgreSQL configuration tuning engine

✏️ Content

👩‍💻Code examples

• 📝Image recognition with Python, OpenCV, OpenAI CLIP and pgvector by Francesco Tisiot
• 📝TensorFlow, PostgreSQL®, PGVector & Next.js: building a movie recommender by Olena Kutsenko
• 📽️TensorFlow, PostgreSQL®, PGVector & Next.js: building a movie recommender by Olena Kutsenko
• 📽️How I found my Pokémon cards thanks to Postgres: an AI Journey by Matt Cornillon at pgconf.eu 2023
• 📽️PostgresML: How to Use AI Models and Machine Learning Algorithms in Your Database by Let's Talk Dev
• 📝What's Postgres Got To Do With AI? by Crunchy Data
• 📝Real-time text translation using the azure_ai extension in Azure Database for PostgreSQL by Denzil Ribeiro

What's next

• 📽️What's next in pgvector
• 📝pgvector 0.5.0 feature highlight and howtos by Jonathan Katz
• 📝An early look at HNSW performance with pgvector by Jonathan Katz

Presentation slides

• 🛝Finding PostgreSQL’s fit in the AI space by Francesco Tisiot