query

MCP tool from Ainative Postgres MCP by AINative-Studio

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

How to use it

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

pgvector

Manual setup