pgvector

MCP tool from Ainative Postgres MCP by AINative-Studio

Manual setup

How to use it

Project documentation lists pgvector for the Ainative Postgres MCP MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), then check which tools your installed version makes available. Tool availability can depend on configuration and credentials. A server handshake does not verify this tool’s behavior. See the full listing for setup details.

Install Ainative Postgres MCP

$npx ainative-postgres-mcp
FULL AINATIVE POSTGRES MCP LISTING

Other tools in Ainative Postgres MCP (6)

Auto-provisioning

No

create_table

Create a new table with SQL DDL

describe_table

Get full table schema: columns, types, constraints, indexes

insert

Insert rows into a table (returns inserted rows)

list_tables

List all tables with schema, name, and type

query

Execute read-only SQL queries (runs in READ ONLY transaction)