search_columns

MCP tool from Postgres MCP by JaviMaligno

Search for columns by name across all tables

How to use it

Project documentation lists search_columns for the 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 Postgres MCP

$npx @javiagui/postgresql-mcp
FULL POSTGRES MCP LISTING

Other tools in Postgres MCP (14)

describe_table

Get table structure (columns, types, constraints)

describe_view

Get view definition and columns

execute

Execute write operations (INSERT/UPDATE/DELETE) when enabled

explain_query

Get EXPLAIN plan for query optimization

get_database_info

Get database version and connection info

list_constraints

List constraints (PK, FK, UNIQUE, CHECK)

list_databases

List the configured connections by alias, with host, database, write permission and which is the default. Never returns credentials.

list_functions

List functions and procedures

list_indexes

List indexes for a table

list_schemas

List all schemas in the database

list_tables

List tables in a specific schema

list_views

List views in a schema

query

Execute read-only SQL queries against the database

table_stats

Get table statistics (row count, size, bloat)