postgres-ai
CommunityUnified AI for Azure PostgreSQL vector search.
System Documentation
What problem does it solve?
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.
Core Features & Use Cases
- Vector search with pgvector on Azure PostgreSQL for fast similarity queries over embeddings
- RAG pipelines using LangChain, Azure OpenAI, and a PostgreSQL-backed vector store for retrieval-augmented generation
- Persistent agent memory and checkpointing with LangGraph to maintain context across sessions
Quick Start
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.
Dependency Matrix
Required Modules
Components
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: postgres-ai Download link: https://github.com/samelhousseini/microhacks/archive/main.zip#postgres-ai Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.