PluginBench
MCP Server
Active
MIT

pgvector MCP Server

io.github.mittalpk/pgvector

RepositoryRegistry
How to choose

What this kind of tool is for

  • Query, inspect, or seed a database without writing a one-off script.
  • Let your agent look up schema details before it writes migration code.
  • Move a small dataset between tools without leaving the terminal.

How to compare servers like this

Engine match:
Confirm it speaks your exact database and version, not just the family.
Access scope:
Read-only connections are the safe default — start there before granting writes.
Safety rails:
Check whether destructive statements need an explicit confirmation before they run.
Maintenance signal:
Database drivers change; a recently updated tool is less likely to break mid-query.

This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.

What is the pgvector MCP server?

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

How to install pgvector

Copy-paste configuration for popular MCP clients.

transport: stdio
Config generated by PluginBench — verify against the source before use.
Environment / auth
  • DATABASE_URL
    required
    secret

    PostgreSQL connection string, e.g. postgresql://user:password@host:5432/dbname

  • MCP_PGVECTOR_READ_ONLY

    Set to 'true' to disable upsert_embedding and create_vector_index

~/Library/Application Support/Claude/claude_desktop_config.json
JSON config
{
  "mcpServers": {
    "pgvector": {
      "command": "uvx",
      "args": [
        "mcp-server-pgvector"
      ],
      "env": {
        "DATABASE_URL": "<YOUR_DATABASE_URL>",
        "MCP_PGVECTOR_READ_ONLY": "<YOUR_MCP_PGVECTOR_READ_ONLY>"
      }
    }
  }
}

Related MCP servers

Sourced, dated SK/CZ/AT/EU civic, tax and legal facts for AI agents. Read via MCP, not guesswork.

View repository →
REReddit Ads MCP logo

Reddit Ads MCP

Maintained

MCP server for the Reddit Ads API. List accounts, campaigns, ads, and pull reports.

1
C#
MIT
View repository →

AI agents propose database changes as reviewable requests — no direct write access.

PYPyScrappy logo

PyScrappy

Active

AI-native web scraping toolkit with 22+ tools for structured, LLM-ready data extraction

186
Python
MIT
View repository →

Generate academic diagrams and statistical plots with independent VLM and image model connections.

72
Python
MIT
View repository →

Scan website legal docs for missing or stale compliance clauses. Rule-based, no LLM.

0
Python
AGPL-3.0
View repository →