query

MCP tool from Ainative Postgres MCP by AINative-Studio

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

How to use it

query is exposed by the Ainative Postgres MCP MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the query 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

insert

Insert rows into a table (returns inserted rows)

list_tables

List all tables with schema, name, and type

pgvector

Manual setup