insert

MCP tool from Ainative Postgres MCP by AINative-Studio

Insert rows into a table (returns inserted rows)

How to use it

Project documentation lists insert 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

list_tables

List all tables with schema, name, and type

pgvector

Manual setup

query

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