Automate vector search, RAG, and memory in Azure PostgreSQL with pgvector and azure_ai.
npx skills add https://github.com/samelhousseini/microhacks --skill postgres-ai
Please help me install this Agent Skill. Skill: postgres-ai Source: https://github.com/samelhousseini/microhacks/tree/main/.github/skills/postgres-ai Command: npx skills add https://github.com/samelhousseini/microhacks --skill postgres-ai
Azure PostgreSQL AI workloads are complex to set up and maintain; this Skill delivers a ready-to-run integration for vector search, RAG pipelines, and persistent agent memory using pgvector and azure_ai extensions to accelerate AI-powered data apps.
Configure environment variables (PGHOST, PGDATABASE, PGUSER, PGPASSWORD, AZURE_OPENAI_ENDPOINT, AZURE_OPENAI_API_KEY) and run the scripts in .github/skills/postgres-ai/scripts to initialize the vector table, insert documents, and perform a sample search or RAG query.
High-intent search queries and answers about installing and using this skill.
Vector search in Azure PostgreSQL requires installing pgvector and azure_ai extensions to create a vector table, insert embeddings, and run similarity queries. The Skill automates this initialization using configured environment variables.
Yes, you can build RAG pipelines using LangChain, Azure OpenAI, and a PostgreSQL-backed vector store. This Skill provides scripts to execute retrieval-augmented generation queries directly inside your database.
LangGraph maintains persistent agent memory in PostgreSQL through checkpointing to store and retrieve context across sessions. This Skill integrates langgraph-checkpoint-postgres to preserve state continuity for data-driven apps.
Connecting Azure OpenAI with PostgreSQL requires configuring PGHOST, PGDATABASE, PGUSER, PGPASSWORD, AZURE_OPENAI_ENDPOINT, and AZURE_OPENAI_API_KEY. These variables authenticate both the database and AI embedding services.
The best way to implement scalable embeddings and retrieval in Azure PostgreSQL is using pgvector for similarity queries and LangGraph for state management. This Skill delivers a ready-to-run integration for these specific workloads.
chicagopeabodydev-sudoConnect Supabase PostgreSQL and pgvector to store and query embeddings.
FrekiManagarmPerform semantic vector similarity search with metadata-aware filtering and MMR diversity.
hoodiniBuild end-to-end LLM applications with LangChain and LangGraph.
MassimilianoPiliIntegrate Qdrant vector database into Java applications with LangChain4j and Spring Boot.
