describe_table

MCP tool from Ainative Postgres MCP by AINative-Studio

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

How to use it

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

insert

Insert rows into a table (returns inserted rows)

list_tables

List all tables with schema, name, and type

pgvector

Manual setup

query

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