pgvector

Name: pgvector
Author: mittalpk

by mittalpkversion 0.1.0i★ 0iRuns on your computer

Registry nameio.github.mittalpk/pgvector

How to install

What it does

Similarity search, hybrid search, and index management for pgvector-backed PostgreSQL tables

Connects Runs on your computer
Account or key Needs DATABASE_URL
Category Search & AI memory

Install

Pick the AI app you use, then copy the settings.

Passed 3/3 checks · Runs on your computer · ✓ Commands checked Nov 13, 2026

First: which AI do you use?

ClaudeWeb · app · phoneChatGPTWebClaude CodeTerminalCursorCode editorVS CodeCode editorOtherOther apps

Pick your app and the steps appear below.

Works with Claude, with some setup first

You need a pgvector key (create it on the maker’s site) · Install Python (uv) on your computer first (one time) · Only the Claude desktop app (Windows or Mac), not the web or phone

Install Python (uv)
One time only; it works for every server that needs Python (uv)
Open the Python (uv) download page ↗
Done
Sign up and create a pgvector key
Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.
How to get a key is in the maker’s README below
Done
Open the Claude desktop app’s settings file
SettingsDeveloperEdit Config
Done

Paste these settings and save the file

{
  "mcpServers": {
    "pgvector": {
      "command": "uvx",
      "args": [
        "mcp-server-pgvector"
      ],
      "env": {
        "DATABASE_URL": "your-value",
        "MCP_PGVECTOR_READ_ONLY": "your-value"
      }
    }
  }
}

Paste the key only into the app’s field, never into a chat or to anyone

Done

Quit Claude and open it again
Done
Try it
Use pgvector and tell me what you can do for me, then show me one thing
✓ If Claude says it is using pgvector or shows a pgvector tool in the answer, you are connected

Menu names checked against Anthropic’s help page on Nov 11, 2026 · your screen may differ slightly by app version

ChatGPT cannot connect pgvector yet

pgvector runs on your computer, but ChatGPT can only connect servers that run on the web

What you can do instead

A · Use an app that can connect pgvector

Steps for Claude →You need a pgvector key (create it on the maker’s site) · Install Python (uv) on your computer first (one time) · Only the Claude desktop app (Windows or Mac), not the web or phone
Steps for Claude Code →You need a pgvector key (create it on the maker’s site) · Install Python (uv) on your computer first (one time)
Steps for Cursor →You need a pgvector key (create it on the maker’s site) · Install Python (uv) on your computer first (one time)
Steps for VS Code →You need a pgvector key (create it on the maker’s site) · Install Python (uv) on your computer first (one time)

B · Others in Search & AI memory that work with ChatGPT

Picked from the most used in the same category, only ones that connect by address with no key

Context7✓ ChatGPT
AIHOT✓ ChatGPT
Sui Knowledge Base (kapa.ai)✓ ChatGPT

Works with Claude Code, with some setup first

You need a pgvector key (create it on the maker’s site) · Install Python (uv) on your computer first (one time)

Install Python (uv)
One time only; it works for every server that needs Python (uv)
Open the Python (uv) download page ↗
Done
Sign up and create a pgvector key
Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.
How to get a key is in the maker’s README below
Done
Open Terminal
Mac: press Command+Space and type Terminal · Windows: open PowerShell
Done
4
Paste this command and press Enter
```
claude mcp add --scope user pgvector --env DATABASE_URL=your-value --env MCP_PGVECTOR_READ_ONLY=your-value -- uvx mcp-server-pgvector
```
Replace “your-value” with your key before pressing Enter
Paste the key only into the app’s field, never into a chat or to anyone
Done
Type /mcp in Claude Code
You should see pgvector listed as connected
Done
Try it
Use pgvector and tell me what you can do for me, then show me one thing
✓ If Claude Code says it is using pgvector or shows a pgvector tool in the answer, you are connected

Menu names checked against Anthropic’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Works with Cursor, with some setup first

You need a pgvector key (create it on the maker’s site) · Install Python (uv) on your computer first (one time)

Install Python (uv)
One time only; it works for every server that needs Python (uv)
Open the Python (uv) download page ↗
Done
Sign up and create a pgvector key
Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.
How to get a key is in the maker’s README below
Done
Click this button to open Cursor
Open in Cursor
Cursor asks you to confirm; click Install
Done
Fill in your key
In the pgvector settings, DATABASE_URL, MCP_PGVECTOR_READ_ONLY is empty; add your key and save
Paste the key only into the app’s field, never into a chat or to anyone
Done
Open the AI chat in Cursor in Agent mode
Done
Try it
Use pgvector and tell me what you can do for me, then show me one thing
✓ If Cursor says it is using pgvector or shows a pgvector tool in the answer, you are connected

Menu names checked against Cursor’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Works with VS Code, with some setup first

You need a pgvector key (create it on the maker’s site) · Install Python (uv) on your computer first (one time)

Install Python (uv)
One time only; it works for every server that needs Python (uv)
Open the Python (uv) download page ↗
Done
Sign up and create a pgvector key
Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.
How to get a key is in the maker’s README below
Done
Click this button to open VS Code
Open in VS Code
VS Code asks you to confirm; click Install
Done
Fill in your key
In the pgvector settings, DATABASE_URL, MCP_PGVECTOR_READ_ONLY is empty; add your key and save
Paste the key only into the app’s field, never into a chat or to anyone
Done
Open the AI chat in VS Code in Agent mode
Done
Try it
Use pgvector and tell me what you can do for me, then show me one thing
✓ If VS Code says it is using pgvector or shows a pgvector tool in the answer, you are connected

Menu names checked against VS Code’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Other apps that use MCP, such as Windsurf, Zed or Gemini CLI, each add servers differently. See how in the app list.

See every app that uses MCP →

JSON settings are under “For developers” below

Stuck? Ask people who use pgvector💬 Discussion →

For developers: Terminal commands and JSON settings

Installed on your computer

Claude Code

claude mcp add --scope user pgvector --env DATABASE_URL=your-value --env MCP_PGVECTOR_READ_ONLY=your-value -- uvx mcp-server-pgvector

Claude Desktop (claude_desktop_config.json)

{
  "mcpServers": {
    "pgvector": {
      "command": "uvx",
      "args": [
        "mcp-server-pgvector"
      ],
      "env": {
        "DATABASE_URL": "your-value",
        "MCP_PGVECTOR_READ_ONLY": "your-value"
      }
    }
  }
}

Cursor (~/.cursor/mcp.json)

{
  "mcpServers": {
    "pgvector": {
      "command": "uvx",
      "args": [
        "mcp-server-pgvector"
      ],
      "env": {
        "DATABASE_URL": "your-value",
        "MCP_PGVECTOR_READ_ONLY": "your-value"
      }
    }
  }
}

VS Code (mcp.json)

{
  "servers": {
    "pgvector": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-server-pgvector"
      ],
      "env": {
        "DATABASE_URL": "your-value",
        "MCP_PGVECTOR_READ_ONLY": "your-value"
      }
    }
  }
}

Values you fill in

DATABASE_URL secret required env
PostgreSQL connection string, e.g. postgresql://user:password@host:5432/dbname
MCP_PGVECTOR_READ_ONLY env
Set to 'true' to disable upsert_embedding and create_vector_index

These settings are generated from the maker’s registry entry. If the README says otherwise, follow the README.

At a glance

GitHub stars i: 0
Downloads per weeki: 23/wk
Licence i: MIT
Connection: Runs on your computer
Transport: stdio
Latest versioni: 0.1.0
Categoryi: Search & AI memory
Published to registryi: Jul 22, 2026
Code last changedi: Jul 22, 2026
Maker: mittalpk
Packages: pypi: mcp-server-pgvector
Repo: mittalpk/mcp-server-pgvector
Registry status: Active

Which apps can use it

Based on how this server connects and on each app’s own docs, checked Nov 10, 2026.

Run on your computer in

Claude Goose LM Studio Msty Studio Cherry Studio Cursor VS Code + GitHub Copilot Visual Studio Windsurf (Devin Desktop)Zed Kiro Cline Continue JetBrains AI Assistant Claude Code Codex CLI Gemini CLI OpenCode nodecode Warp LibreChat Raycast

All apps, with pros and cons →

What it can do

Runs on your computer; the tool list appears in your AI app after you install it.

Basic checksi

We check information anyone can see; we have not read the code. Checks that do not apply are left out of the count. · Checked Nov 13, 2026

✓ Pass
Maker matches the repo
The registry name was verified with the GitHub account mittalpk, which owns the repo
✓ Pass
Still maintained
Code last changed 4 months ago
✓ Pass
Has a licence
Uses MIT
– Not applicable
Endpoint responds
This one runs on your computer; there is no internet endpoint
– Not applicable
Sign-in with OAuth
Runs on your computer and uses local settings instead
… Not checked yet
No hidden instructions in tool descriptions
Runs on your computer; we can only read tool lists from internet endpoints

Discussion

Ask, share a tip or report that it does not work. Sorted by what people marked helpful.

No posts yet. Be the first to ask or share.

Posts here are written by users, not the PopNx team.

User reviews

No reviews yet

Compared with others in Search & AI memoryi

More stars than 0% of the other 6064 servers in this category
Published to the registry more recently than 22% of the other 6064 servers in this category
Basic checks equal to or better than 100% of the other 6064 servers in this category

Compared with every active server in this category in the registry. Stars count only when the publisher owns the repo.

Common questions

Is pgvector safe?

It passed 3 of 3 applicable basic checks. We have not read the code. Before adding a key or token, see what access the server asks for and use a key with only the permissions you need.

What keys or codes does it need?

You need to fill in: DATABASE_URL

Does it run on my computer or in the cloud?

It runs on your computer. Your AI app starts it when needed, and data does not pass through the maker’s servers (unless it calls an online service itself).

Is it still maintained?

The GitHub repo last changed 4 months ago, and the latest version (0.1.0) reached the registry 4 months ago.

Which apps can use it?

Apps that support MCP, such as Claude Desktop, Claude Code, Cursor and VS Code. You also need Python (uv) on your computer.

What can I use instead?

In the same category: Context7, Codebase Memory, Ruflo

Others in the same category

Servers in the same category from other makers, sorted by stars.

Reading a card:↓ Downloads per weeki★ GitHub starsiThree pillars: reviews · checks · usageiUpdated = latest version published to the registryi

Context7

Feeds AI the latest docs for libraries and frameworks before it answers, so code it writes does not use outdated, removed functions.

by upstashWidely used↓ 1.2M/wk★ 64.7KUpdated yesterday

Computer or cloud

Install

Codebase Memory

Codebase knowledge graph for AI agents — 162 languages, sub-ms queries, 99% fewer tokens.

by DeusDataWidely used↓ 16.8K/wk★ 48.6KUpdated 27 days ago

Runs on your computer

Install

Ruflo

Agent teams, swarms, memory and hooks for Claude Code and Codex, served over MCP.

by ruvnetWidely used↓ 74.3K/wk★ 81.6K Stars for the whole repoUpdated today

Runs on your computer

Install

README from the maker

Open the README

Copied from the maker’s repo as written. PopNx MCP has not reviewed or endorsed it. HTML, images and scripts are removed. Links lead off this site.

mcp-server-pgvector

An MCP server that gives LLM agents first-class access to pgvector-backed embedding tables in PostgreSQL: similarity search, hybrid (vector + full-text) search, upserts, and HNSW/IVFFlat index management.

Generic Postgres MCP servers expose raw SQL or schema introspection; this one speaks pgvector specifically — nearest-neighbor search, distance metrics, and ANN index tuning are first-class tools, not something the model has to hand-write SQL for.

Tools

Tool	Description
`list_vector_tables`	Discover every `vector` column in the database, with its dimensionality
`describe_vector_table`	Columns, indexes, and approximate row count for a table
`similarity_search`	k-NN search over a vector column (cosine / L2 / inner product), with structured metadata filters
`hybrid_search`	Weighted blend of vector similarity and Postgres full-text search (`ts_rank_cd`)
`upsert_embedding`	Insert or update a row's embedding + metadata
`create_vector_index`	Create an HNSW or IVFFlat index with tunable parameters
`explain_similarity_query`	`EXPLAIN ANALYZE` a similarity query to confirm the ANN index is used

Safety

Every table/column name is validated against information_schema / pg_catalog before being interpolated into SQL — an LLM can only ever reference identifiers that already exist. Values are always bound parameters.
Metadata filters are a closed {column, op, value} allowlist, not a raw SQL fragment.
Set MCP_PGVECTOR_READ_ONLY=true to disable upsert_embedding and create_vector_index, leaving only read/search tools available — useful when pointing the server at a production database.
Every query runs with a per-command timeout (MCP_PGVECTOR_COMMAND_TIMEOUT_SECONDS, default 30s) so one expensive query can't occupy a pool connection — and stall every other caller — indefinitely. Set it to 0 to disable.

Installation

uvx mcp-server-pgvector

Or with pip:

pip install mcp-server-pgvector

python -m mcp_server_pgvector

Configuration

The server reads its connection string from DATABASE_URL (or PGVECTOR_DATABASE_URL):

"mcpServers": { "pgvector": { "command": "uvx", "args": ["mcp-server-pgvector"], "env": { "DATABASE_URL": "postgresql://user:password@localhost:5432/mydb", "MCP_PGVECTOR_READ_ONLY": "false", "MCP_PGVECTOR_COMMAND_TIMEOUT_SECONDS": "30" } } } }

Production readiness

Covered:

Identifier-safe SQL (every table/column checked against pg_catalog before use) and a closed filter-operator allowlist — no path from tool arguments to raw SQL.
Per-query timeout, so one runaway query can't monopolize the (small, 5-connection) pool.
60+ tests, including dimension-mismatch and injection-attempt regressions, run in CI on every push/PR against a real pgvector container across Python 3.10–3.13. A separate CI job builds the package and runs twine check on the result.
Connection failures surface as plain ConnectionRefusedError/asyncpg exceptions — verified these don't leak the DSN's credentials into error text.

Known limitations, honestly:

No per-tool authorization — access control is whatever the Postgres role in DATABASE_URL can do. If you need different agents to have different permissions, give them different connection strings backed by different Postgres roles, not different server instances of this same DSN.
hybrid_search's full-text side is hardcoded to Postgres's 'english' text search configuration; there's no parameter to change it yet.
No structured logging — failures are exceptions surfaced through the MCP error channel, not written to a log you can tail. Fine for a single-user desktop MCP client, a real gap if you're running this as a shared service.
The connection pool is fixed at 1–5 connections and isn't configurable via environment variable yet.

Development

uv sync --dev

Bring up an isolated pgvector instance for local testing

docker compose -f docker-compose.dev.yml up -d

export DATABASE_URL=postgresql://postgres:postgres@localhost:5434/postgres uv run pytest

uv run ruff check . uv run pyright

Contributing

See CONTRIBUTING.md. See CHANGELOG.md for release history.

License

MIT — see LICENSE.

pgvector

What it does

Install

Install Python (uv)

Sign up and create a pgvector key

Open the Claude desktop app’s settings file

Paste these settings and save the file

Quit Claude and open it again

Try it

What you can do instead

Install Python (uv)

Sign up and create a pgvector key

Open Terminal

Paste this command and press Enter

Type /mcp in Claude Code

Try it

Install Python (uv)

Sign up and create a pgvector key

Click this button to open Cursor

Fill in your key

Open the AI chat in Cursor in Agent mode

Try it

Install Python (uv)

Sign up and create a pgvector key

Click this button to open VS Code

Fill in your key

Open the AI chat in VS Code in Agent mode

Try it

Installed on your computer

Values you fill in

At a glance

Which apps can use it

Related guides

What it can do

Basic checksi

Maker matches the repo

Still maintained

Has a licence

Endpoint responds

Sign-in with OAuth

No hidden instructions in tool descriptions

Discussion

User reviews

Compared with others in Search & AI memoryi

Common questions

Others in the same category

Context7

Codebase Memory

Ruflo

README from the maker

mcp-server-pgvector

Tools

Safety

Installation

Configuration

Production readiness

Development

Bring up an isolated pgvector instance for local testing

Contributing

License