pgvector (Vector Database) MCP Connector for Claude
A+Run vector similarity searches, manage embedding tables, and build AI-powered retrieval pipelines — all directly inside your existing PostgreSQL database.
Connect your PostgreSQL + pgvector database to any AI agent and manage vector embeddings, similarity searches, and index optimizations through natural conversation.
What you can do
- Vector Similarity Search — Run nearest-neighbor queries using cosine, L2, or inner product distance metrics across millions of embeddings with a single prompt.
- Table Management — Discover which tables contain vector columns, create new embedding tables with custom dimensions, and inspect your schema.
- Embedding CRUD — Insert, update, and delete individual vector entries with metadata, keeping your knowledge base fresh and accurate.
- Index Optimization — Create HNSW or IVFFlat indexes on vector columns to accelerate approximate nearest-neighbor (ANN) queries by orders of magnitude.
How it works
- Subscribe to the pgvector integration on the marketplace.
- Paste your PostgreSQL connection string (e.g.,
postgresql://user:pass@host:5432/db). - Ask your AI agent to search vectors, create tables, or optimize indexes.
Who is this for?
- AI Engineers — Build RAG (Retrieval-Augmented Generation) pipelines that query production embeddings without writing custom API endpoints.
- Data Architects — Manage vector schemas, monitor index performance, and optimize query latency from a single conversational interface.
- Fullstack Developers — Add semantic search to existing apps by querying pgvector directly through your AI agent, no new microservices needed.
Related Connectors
Vald MCP
Power your agent with Vald — query, insert, and manage dense vectors on a highly scalable, distributed nearest-neighbor engine.
MongoDB Atlas Vector Search MCP
Manage vector storage via MongoDB Atlas — perform similarity searches, query MQL documents, and audit collections.
Milvus (Open-Source Vector Database) MCP
Manage vector storage via Milvus — perform ANN searches, query scalar entities, and audit collections.
Pinecone MCP
Equip your AI agent to manage your Pinecone vector databases. Query embeddings, fetch metrics, manage collections, and run stats natively via chat.