drio
Open app

aws-ow-pgvector-mcp

Source

AWS Aurora Postgres with Pgvector Extension MCP Server.

Catalog onlyCatalog onlySTDIO

Overview

aws-ow-pgvector-mcp is a server setup for AWS Aurora Postgres that includes the Pgvector extension, enabling advanced vector operations for machine learning and AI applications.

To use aws-ow-pgvector-mcp, deploy the server on AWS Aurora and configure it to utilize the Pgvector extension for your database needs.

  • Integration with AWS Aurora for scalable database solutions. - Support for the Pgvector extension to handle vector embeddings. - Optimized for machine learning and AI workloads.
  1. Storing and querying vector embeddings for AI models.
  2. Performing similarity searches in large datasets.
  3. Enhancing data retrieval processes in machine learning applications.

Add to your AI client

Use these steps to connect aws-ow-pgvector-mcp in Cursor, Claude, VS Code, and other MCP-compatible apps. The same JSON appears in the Use with menu above for one-click copy.

Cursor

Add this to your .cursor/mcp.json file in your project root, then restart Cursor.

.cursor/mcp.json

{
  "mcpServers": {
    "aws-ow-pgvector-mcp-openworkspace-o1": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-aws-ow-pgvector-mcp-openworkspace-o1"
      ]
    }
  }
}

Claude Desktop

Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.

~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows)

{
  "mcpServers": {
    "aws-ow-pgvector-mcp-openworkspace-o1": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-aws-ow-pgvector-mcp-openworkspace-o1"
      ]
    }
  }
}

Claude Code

Add this to your project's .mcp.json file. Claude Code will detect it automatically.

.mcp.json (project root)

{
  "mcpServers": {
    "aws-ow-pgvector-mcp-openworkspace-o1": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-aws-ow-pgvector-mcp-openworkspace-o1"
      ]
    }
  }
}

VS Code (Copilot)

Add this to your .vscode/mcp.json file. Requires the GitHub Copilot extension with MCP support enabled.

.vscode/mcp.json

{
  "servers": {
    "aws-ow-pgvector-mcp-openworkspace-o1": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-aws-ow-pgvector-mcp-openworkspace-o1"
      ]
    }
  }
}

Windsurf

Add this to your Windsurf MCP config file, then restart Windsurf.

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "aws-ow-pgvector-mcp-openworkspace-o1": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-aws-ow-pgvector-mcp-openworkspace-o1"
      ]
    }
  }
}

Cline

Open Cline settings, navigate to MCP Servers, and add this server configuration.

Cline MCP Settings (via UI)

{
  "mcpServers": {
    "aws-ow-pgvector-mcp-openworkspace-o1": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-aws-ow-pgvector-mcp-openworkspace-o1"
      ]
    }
  }
}

FAQ

What is the Pgvector extension?

Pgvector is an extension for PostgreSQL that allows for efficient storage and querying of vector data, which is essential for machine learning applications.

Is aws-ow-pgvector-mcp free to use?

The server setup is free, but AWS Aurora usage may incur costs based on your usage and configuration.

Can I use aws-ow-pgvector-mcp for production workloads?

Yes, it is designed to handle production workloads with the scalability of AWS Aurora.

Databases