pgvector
Similarity search, hybrid search, and index management for pgvector-backed PostgreSQL…
- Pricing
- Open source
- Runs
- Locally
- Version
- 0.1.0
- Listing updated
- 5 days ago
About pgvector
pgvector is an open-source MCP server. It runs locally on your machine and is started by your AI client.
Similarity search, hybrid search, and index management for pgvector-backed PostgreSQL tables
Install
Run in a terminal
claude mcp add pgvector --env DATABASE_URL='<DATABASE_URL>' -- uvx mcp-server-pgvectorAdd to claude_desktop_config.json
{
"mcpServers": {
"pgvector": {
"command": "uvx",
"args": [
"mcp-server-pgvector"
],
"env": {
"DATABASE_URL": "<DATABASE_URL>"
}
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"pgvector": {
"command": "uvx",
"args": [
"mcp-server-pgvector"
],
"env": {
"DATABASE_URL": "<DATABASE_URL>"
}
}
}
}Add to .vscode/mcp.json
{
"servers": {
"pgvector": {
"type": "stdio",
"command": "uvx",
"args": [
"mcp-server-pgvector"
],
"env": {
"DATABASE_URL": "<DATABASE_URL>"
}
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"pgvector": {
"command": "uvx",
"args": [
"mcp-server-pgvector"
],
"env": {
"DATABASE_URL": "<DATABASE_URL>"
}
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"pgvector": {
"command": "uvx",
"args": [
"mcp-server-pgvector"
],
"env": {
"DATABASE_URL": "<DATABASE_URL>"
}
}
}
}Using several servers? Build one config file with the MCP config generator.
Configuration
DATABASE_URLPostgreSQL connection string, e.g. postgresql://user:password@host:5432/dbnameRequiredMCP_PGVECTOR_READ_ONLYSet to 'true' to disable upsert_embedding and create_vector_index
Pricing
Open source
More servers for the same service
pgvector FAQ
Is pgvector free?
Yes. pgvector is open source, so you can use and self-host it for free.
How do I add pgvector to Claude Code?
Run this command in your terminal: claude mcp add pgvector --env DATABASE_URL='<DATABASE_URL>' -- uvx mcp-server-pgvector
Where this comes from
- Description: from the official MCP Registry entry.
- Install steps: from the official MCP Registry entry.