list_tables

MCP tool from MCP Sql Server by Attilio81

All accessible tables with row counts

How to use it

Project documentation lists list_tables 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

search_columns

Find columns by name across the database

update_dictionary

Persist a semantic discovery (called by Claude)