insert

MCP tool from Ainative Postgres MCP by AINative-Studio

Insert rows into a table (returns inserted rows)

How to use it

insert is exposed by the Ainative Postgres MCP MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the insert tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

Install Ainative Postgres MCP

$npx ainative-postgres-mcp

FULL AINATIVE POSTGRES MCP LISTING

Other tools in Ainative Postgres MCP (6)

Auto-provisioning

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)