MCPVault

search_columns

MCP tool from Postgres MCP by JaviMaligno

Search for columns by name across all tables

How to use it

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

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)