pgvector (Vector Database) Connector for AI agents.
6 live capabilities
Run semantic search and manage embeddings inside your PostgreSQL database.
Waiting for input…
Why people use pgvector (Vector Database)
Pgvector PostgreSQL Vector Search for RAG Pipelines
This Connector changes that by letting your agent handle the pgvector logic directly. You get the power of semantic search without the headache of extra infrastructure, keeping everything in one place.
What Vinkius changes
You get production-ready vector search without leaving your PostgreSQL environment.
Use it from Claude, ChatGPT, Cursor or another AI client you already have.
One account · 5,900+ Connectors
- Real-world use case 01
Finding similar support tickets
A developer needs to find the 5 most similar documents to a user's question using search_vectors.
- Real-world use case 02
Improving search speed on large datasets
An engineer needs to create a new index on a large product table to improve search speed with create_index.
- Real-world use case 03
Auditing vector columns across the database
A data scientist wants to see which tables currently hold vector data to plan a migration using list_tables.
Complete set · 6capabilities
The complete pgvector (Vector Database) capability set.
These are the exact actions your AI can choose when you ask it to work with pgvector (Vector Database).
01—03
3 capabilities in this set.
Part of 6 available through pgvector (Vector Database).
- 01 Capability
Search vectors
Run a similarity search to find the closest matches for a specific query. This helps you find relevant data based on meaning rather than just keywords.
- 02 Capability
List tables
View a list of all tables in your database. Use this to quickly identify which ones contain your vector data.
- 03 Capability
Insert vector
Add a new vector and its associated metadata into an existing table. This keeps your knowledge base updated with new entries.
04—06
3 capabilities in this set.
Part of 6 available through pgvector (Vector Database).
- 04 Capability
Create index
Set up HNSW or IVFFlat indexes on your vector columns. This makes your similarity searches much faster as your dataset grows.
- 05 Capability
Create table
Build a new table with the specific dimensions required for your embeddings. This sets up the correct structure for your vector data.
- 06 Capability
Delete vector
Remove a specific vector entry from your database. This is useful for keeping your data clean and up to date.
Set up in minutes
One URL. Then ask pgvector (Vector Database) to work.
Claude and ChatGPT only need the Connector URL. Copy it once, add it in settings, and use pgvector (Vector Database) from the conversation.
Choose your client
Live previewAdvanced clients IDE · CLI
Claude · Web + desktop
Connector URL · ready to paste
Streamable HTTPhttps://edge.vinkius.com/vk_preview_m3Dmr7TKd7NjkaPwx4OA0eTWiY7yo9GZdmp9NSJ4/mcp - Step 01
Open Connectors
In Claude Web or Claude Desktop, open Settings and choose Connectors.
- Step 02
Add the URL
Choose Add custom connector, name it pgvector (Vector Database), and paste the URL above.
- Step 03
Turn it on in chat
Select +, open Connectors, and enable pgvector (Vector Database) for the conversation.
ChatGPT · Web + desktop
Connector URL · ready to paste
Streamable HTTPhttps://edge.vinkius.com/vk_preview_m3Dmr7TKd7NjkaPwx4OA0eTWiY7yo9GZdmp9NSJ4/mcp - Step 01
Open MCP settings
On desktop, open Settings and MCP servers. On web, open your workspace app or connector settings.
- Step 02
Add the URL
Choose Add server with Streamable HTTP, or create a custom MCP app, then paste the pgvector (Vector Database) URL.
- Step 03
Save and start
Save the connection and enable pgvector (Vector Database) in your conversation. Desktop may ask you to restart once.
Cursor · IDE configuration
Advanced setup
{
"mcpServers": {
"pgvector-vector-database": {
"url": "https://edge.vinkius.com/vk_preview_m3Dmr7TKd7NjkaPwx4OA0eTWiY7yo9GZdmp9NSJ4/mcp"
}
}
} - Step 01
Open MCP Settings
Press Cmd+Shift+P (macOS) or Ctrl+Shift+P (Windows/Linux) → search "MCP Settings"
- Step 02
Add the server config
Paste the JSON configuration above into the mcp.json file that opens
- Step 03
Save the file
Cursor will automatically detect the new Connector
- Step 04
Start using pgvector (Vector Database)
Open Agent mode in chat and ask: "Using pgvector (Vector Database), help me...". 6 tools available
VS Code Copilot · IDE configuration
Advanced setup
{
"mcpServers": {
"pgvector-vector-database": {
"url": "https://edge.vinkius.com/vk_preview_m3Dmr7TKd7NjkaPwx4OA0eTWiY7yo9GZdmp9NSJ4/mcp"
}
}
} - Step 01
Create MCP config
Create a .vscode/mcp.json file in your project root
- Step 02
Add the server config
Paste the JSON configuration above
- Step 03
Enable Agent mode
Open GitHub Copilot Chat and switch to Agent mode using the dropdown
- Step 04
Start using pgvector (Vector Database)
Ask Copilot: "Using pgvector (Vector Database), help me...". 6 tools available
Windsurf · IDE configuration
Advanced setup
{
"mcpServers": {
"pgvector-vector-database": {
"url": "https://edge.vinkius.com/vk_preview_m3Dmr7TKd7NjkaPwx4OA0eTWiY7yo9GZdmp9NSJ4/mcp"
}
}
} - Step 01
Open MCP Settings
Go to Settings → MCP Configuration or press Cmd+Shift+P and search "MCP"
- Step 02
Add the server
Paste the JSON configuration above into mcp_config.json
- Step 03
Save and reload
Windsurf will detect the new server automatically
- Step 04
Start using pgvector (Vector Database)
Open Cascade and ask: "Using pgvector (Vector Database), help me...". 6 tools available
Cline · IDE configuration
Advanced setup
{
"mcpServers": {
"pgvector-vector-database": {
"url": "https://edge.vinkius.com/vk_preview_m3Dmr7TKd7NjkaPwx4OA0eTWiY7yo9GZdmp9NSJ4/mcp"
}
}
} - Step 01
Open Cline MCP Settings
Click the Connectors icon in the Cline sidebar panel
- Step 02
Add remote server
Click "Add Connector" and paste the configuration above
- Step 03
Enable the server
Toggle the server switch to ON
- Step 04
Start using pgvector (Vector Database)
Ask Cline: "Using pgvector (Vector Database), help me...". 6 tools available
Claude Code · Terminal command
Advanced setup
claude mcp add pgvector-vector-database --transport http "https://edge.vinkius.com/vk_preview_m3Dmr7TKd7NjkaPwx4OA0eTWiY7yo9GZdmp9NSJ4/mcp" - Step 01
Install Claude Code
Run npm install -g @anthropic-ai/claude-code if not already installed
- Step 02
Add the Connector
Run the command above in your terminal
- Step 03
Verify the connection
Run claude mcp to list connected servers, or type /mcp inside a session
- Step 04
Start using pgvector (Vector Database)
Ask Claude: "Using pgvector (Vector Database), show me...". 6 tools are ready
Where the request belongs
Work pgvector can move forward.
This is for the developer who wants to keep their architecture simple and the data architect who doesn't want to manage a separate vector database.
AI Engineer
Building RAG pipelines that need to query production embeddings without extra API hops.
Data Architect
Managing vector schemas and monitoring index performance from a single chat interface.
Fullstack Developer
Adding semantic search to an existing app without spinning up new infrastructure.
Build the capability set
Add more capabilities.
Each Connector adds new actions and data without changing how you work.
Browse ConnectorsSupabase Vector
Connect your AI to Supabase Vector. Execute pgvector semantic searches, manage embeddings, and run relational database queries directly from your terminal.
Milvus (Open-Source Vector Database)
Manage vector storage via Milvus. perform ANN searches, query scalar entities, and audit collections.
MyScale (SQL Vector Database API)
Manage MyScale vector databases via SQL. execute queries, perform vector searches, and manage indices directly from any AI agent.
Redis Vector
Equip your AI to autonomously manage embeddings, run KNN similarity searches, and administrate vector indexes natively inside your Redis stack.
Weaviate
Search and manage vector data on Weaviate. the AI-native database for building production-grade AI applications.
Qdrant
Empower your AI to interact directly with your Qdrant vector database. query clusters, perform similarity searches, and manage collections effortlessly.
Bring your own AI
Change the model, client or framework. Keep pgvector connected.
-
Claude -
ChatGPT -
Gemini -
Cursor -
VS Code -
Windsurf -
ZCode -
Cline -
Zed -
Continue -
Kiro -
Roo Code -
Zencoder -
Goose -
Void -
Augment Code -
Amp -
Qodo -
Tabnine -
Pieces -
Sourcegraph Cody -
JetBrains -
Warp -
Amazon Q -
Antigravity -
BoltAI -
Raycast -
Jan -
LM Studio -
AnythingLLM -
Open WebUI -
Msty -
Cherry Studio -
LibreChat -
TypingMind -
Chorus -
5ire -
n8n -
LangChain -
LlamaIndex -
CrewAI -
Vercel AI SDK
Before you connect
Questions about pgvector.
The practical details behind the request, access and result.
Can pgvector MCP help me build a RAG system?
Yes, it allows your agent to query embeddings directly from your PostgreSQL database. This makes it easy to build a retrieval-augmented generation pipeline without needing a separate vector database.
How do I use pgvector MCP to speed up my searches?
You can ask your agent to create HNSW or IVFFlat indexes on your vector columns. These indexes significantly reduce the time it takes to find the most similar results in large datasets.
Does pgvector MCP support different distance metrics?
Yes, it supports common metrics like cosine, L2, and inner product. You can specify which one your agent should use when performing a similarity search.
Can I manage my embeddings directly with pgvector MCP?
Absolutely. You can ask your agent to insert new embeddings, update existing ones, or delete old records directly within your PostgreSQL tables.
Is pgvector MCP better than a separate vector database?
It depends on your needs. If you already use PostgreSQL and want to keep your data in one place, this is often the simplest choice. If you need specialized high-scale vector-only features, a dedicated store might be better.
How does pgvector MCP handle large datasets?
It handles large scale data by using production-grade indexing. By creating HNSW or IVFFlat indexes, the Connector ensures your similarity searches remain fast even as your row count grows into the millions.
Does the agent connect directly to my database?
Yes. Your connection string is encrypted at rest and injected into an isolated runtime. The agent connects directly to your PostgreSQL instance. no intermediate proxies, no data copies, no third-party storage.
What vector dimensions are supported?
Any dimension supported by pgvector. from small 128-d vectors to large 3072-d embeddings (e.g., OpenAI text-embedding-3-large). Specify the dimension when creating a table and the agent handles the rest.
Which distance metrics can I use for similarity search?
pgvector supports three operators: (L2/Euclidean distance), (cosine distance), and `` (negative inner product). The agent uses cosine distance by default, which works best for normalized embeddings like those from OpenAI.
One connection away
Give your agent a direct line to pgvector.
Connect pgvector once. Keep it beside 5,900+ managed Connectors when the next task needs more.
Explore every Connector No credit card required · Free tier available