How to Use the pgvector (Vector Database) MCP in Claude Code

Q: Can I run pgvector (Vector Database) queries inside Claude Code?

Yes. You can execute searchvectors directly from your terminal using Claude Code to find similar embeddings in your database. The agent formats the output so you can pipe it to other CLI tools.

Q: How does Claude Code manage indexes with the pgvector (Vector Database) MCP Server?

Claude Code invokes the createindex tool to build HNSW or IVFFlat indexes on your tables. This ensures your terminal-based testing environments match production performance characteristics.

Q: How do I add this pgvector (Vector Database) MCP Server to my Claude Code CLI tool?

Run the command claude mcp add with the server's transport flags and URL. The CLI stores this configuration in your local JSON file and loads the tools instantly.

Q: Can I automate vector ingestion using Claude Code with this MCP Server?

Yes. Claude Code uses insertvector to load embeddings directly from JSON files or CLI pipes into your Postgres tables, making it perfect for automated data loading scripts.

Run pgvector (Vector Database) operations directly from your terminal using Claude Code and this MCP Server.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers — Included with Plan

Connect pgvector (Vector Database) MCP to Claude Code

Create your Vinkius account to connect pgvector (Vector Database) to Claude Code — we handle the hosting, security, and runtime updates so you don't have to. No server setup required.

GDPR Included with Plan

Setup pgvector (Vector Database) with Claude Code

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Scriptable Database Initialization in Claude Code

The `create_table` tool sets up your vector tables directly from your terminal session. Claude Code runs this tool during CI/CD pipeline runs to spin up ephemeral testing databases with correct vector dimensions. Once the tables are initialized, the agent calls `create_index` to apply HNSW indexes before running your integration test suite. This automates your database migration scripts without requiring heavy external migration tools.

Automated Data Maintenance

The `delete_vector` tool removes specific embeddings from your database using their unique identifiers. Claude Code integrates this tool into cleanup cron jobs, running automated shell scripts to purge expired vectors. The agent checks the cleanup by running `list_tables` to monitor row counts and index health. This keeps your production database lean and fast without manual DBA intervention.

Headless Similarity Auditing

The `search_vectors` tool performs similarity searches directly inside your terminal environment. Claude Code executes this tool to audit model drift, piping the search results into standard Unix utilities for quick analysis. If the search results indicate corrupted embeddings, the agent uses `insert_vector` to overwrite the bad data. You get a complete, terminal-driven pipeline for monitoring and fixing your production vector store.

Setup guide

Set up pgvector (Vector Database) MCP in Claude Code

Prerequisites

Claude Code CLI installed (npm install -g @anthropic-ai/claude-code)
Active Vinkius subscription with a valid endpoint token

1

Run the add command

Open your terminal and run the command shown on the right. Replace [YOUR_TOKEN_HERE] with your endpoint token from cloud.vinkius.com. Use --scope user to make it available across all projects.
2

Verify the connection

Start a Claude Code session and type /mcp to list connected servers. You should see pgvector-vector-database-mcp with a green status indicator.
3

Start using tools

Ask Claude Code something like "Check my latest pgvector (Vector Database) transactions." It will automatically discover and invoke the available pgvector (Vector Database) tools.

Terminal

claude mcp add --transport http pgvector-vector-database-mcp https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp

Get your connection token →

Prerequisites

Claude Code CLI installed
Active Vinkius subscription with a valid endpoint token

1

Open the config file

Create or edit .mcp.json in your project root for project-level scope, or ~/.claude.json for user-level scope.
2

Add the pgvector (Vector Database) MCP

Paste the JSON snippet shown on the right into the mcpServers object. Replace [YOUR_TOKEN_HERE] with your endpoint token from cloud.vinkius.com.
3

Restart Claude Code

Start a new Claude Code session. Type /mcp to confirm the server is connected. The tools will be automatically available in your conversation.

.mcp.json

{
  "mcpServers": {
    "pgvector-vector-database-mcp": {
      "type": "url",
      "url": "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
    }
  }
}

Get your connection token →

Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by pgvector. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.

Why Choose Vinkius

Vinkius connects your tools to AI with real-time monitoring and automatic cost savings — all from one dashboard.

Connect pgvector (Vector Database) now

Real-time monitoring

Live

visibility into every interaction

Connect your favorite tools to your AI and see exactly what's happening — every request, every response, in real time.

Built-in savings

60%

lower AI costs

Vinkius compresses data between your apps and your AI automatically. Lower bills every month — no configuration required.

Single dashboard

One

place for every integration

Every tool your AI connects to, managed from a single screen. One account, complete control.

Common questions about pgvector (Vector Database) MCP in Claude Code

Yes. You can execute `search_vectors` directly from your terminal using Claude Code to find similar embeddings in your database. The agent formats the output so you can pipe it to other CLI tools.

Claude Code invokes the `create_index` tool to build HNSW or IVFFlat indexes on your tables. This ensures your terminal-based testing environments match production performance characteristics.

Run the command `claude mcp add` with the server's transport flags and URL. The CLI stores this configuration in your local JSON file and loads the tools instantly.

Yes. Claude Code uses `insert_vector` to load embeddings directly from JSON files or CLI pipes into your Postgres tables, making it perfect for automated data loading scripts.

Your database credentials and raw SQL queries are processed locally through secure, ephemeral transport layers. This architecture prevents your sensitive connection strings and vector payloads from being exposed to public networks.

Use it with your favorite AI tools

Connect this server to Cursor, Claude, VS Code, and more.

OpenAI Agents SDK sdk-python

Google ADK sdk-python

Pydantic AI sdk-python

Vercel AI SDK sdk-typescript