Skip to content
mcp/harbor
VS Code

pgvector for VS Code

io.github.mittalpk/pgvector

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

client:VS Code transport:stdio runtime:pypi

Install pgvector in VS Code

.vscode/mcp.json 

{
  "inputs": [
    {
      "type": "promptString",
      "id": "database-url",
      "description": "DATABASE_URL",
      "password": true
    },
    {
      "type": "promptString",
      "id": "mcp-pgvector-read-only",
      "description": "MCP_PGVECTOR_READ_ONLY",
      "password": true
    }
  ],
  "servers": {
    "pgvector": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-server-pgvector"
      ],
      "env": {
        "DATABASE_URL": "${input:database-url}",
        "MCP_PGVECTOR_READ_ONLY": "${input:mcp-pgvector-read-only}"
      }
    }
  }
}

VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs

pgvector in other clients

pgvector MCP server