// MCP TOOL REFERENCE

SQL SERVER MCP (WINDOWS) TOOLS

12 tools from the SQL Server MCP (Windows) MCP Server, categorised by risk level.

View the SQL Server MCP (Windows) policy →

// ALL 12 SQL SERVER MCP (WINDOWS) TOOLS

READ 11 tools

Read describe_table Get detailed schema information about a table including columns, data types, constraints, foreign keys, and... Read find_column_usage Find all tables that contain a column with a specific name. Useful for tracking where a field is used acros... Read get_database_overview Get high-level statistics about a database including table count, view count, procedure count, and schema c... Read get_procedure_definition Get the full SQL definition of a stored procedure. Read get_related_tables Get all tables directly related to a given table through foreign key relationships. Helps understand table ... Read get_table_relationships Get all foreign key relationships for a table (both incoming and outgoing). Shows how tables are connected. Read list_databases List all databases on the SQL Server instance. Useful for discovering what databases are available. Read list_stored_procedures List all stored procedures in a database. Read list_tables List all tables in a specific database with row counts. Essential for understanding database structure. Read list_views List all views in a database. Read search_schema Search across tables, columns, views, and stored procedures by keyword. Perfect for finding where something...

EXECUTE 1 tools

Execute execute_query Execute a read-only SELECT query against the database. Automatically limited to prevent large result sets. ...

// RUNNING THIS SERVER

The managed route: connect SQL Server MCP (Windows) through the PolicyLayer gateway — every tool call above is checked against your policy before it runs, with a full audit log.

DIRECT INSTALL (UNMANAGED) npx -y @tharanabopearachchi/sql-server-mcp-macos

// FAQ

How many tools does the SQL Server MCP (Windows) MCP server have? +

The SQL Server MCP (Windows) MCP server exposes 12 tools across 2 categories: Read, Execute.

How do I enforce policies on SQL Server MCP (Windows) tools? +

Route the SQL Server MCP (Windows) server through the PolicyLayer gateway. Define allow, deny, or approval rules per tool in the dashboard — they are enforced on every call before it reaches the server.

What risk categories do SQL Server MCP (Windows) tools fall into? +

SQL Server MCP (Windows) tools are categorised as Read (11), Execute (1). Each category has a recommended default policy.

Let agents act without letting them run wild.

Route your MCP servers through PolicyLayer and every tool call is checked against your policy before it runs — allow, deny, or require approval. Per-identity grants. Full audit log. Live in minutes.

SECURE YOUR MCP →

Free to start. No card required.

4,600+ MCP servers and 31,000+ tools scanned and risk-classified.