search_columns

MCP tool from MCP Sql Server by Attilio81

Find columns by name across the database

How to use it

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

$python -m mcp_sqlserver.server --databases C:\Users\you\.mcp_sqlserver\databases.json
FULL MCP SQL SERVER LISTING

Other tools in MCP Sql Server (10)

describe_table

Columns, types, constraints + sample rows

execute_query

Validated SELECT with row cap and timeout

explain_query

Estimated execution plan — query is not executed

get_procedures

Stored procedures with optional SQL definition

get_table_indexes

Indexes: type, columns, uniqueness, fill factor

get_table_relationships

Foreign keys to and from a table

get_table_statistics

Per-column stats: distinct, NULLs, min/max

get_views

Views with optional SQL definition

list_tables

All accessible tables with row counts

update_dictionary

Persist a semantic discovery (called by Claude)