// MCP TOOL REFERENCE

MSSQL TOOLS

21 tools from the Mssql MCP Server, categorised by risk level.

READ TOOLS

call_procedure Call a stored procedure fetch_results Fetch results from a cursor get_columns List table columns get_connection_info Get connection information get_foreign_keys List foreign keys get_primary_keys List primary keys get_procedures List stored procedures get_tables List database tables list_connections List all active connections rollback Rollback current transaction

WRITE TOOLS

bulk_copy Perform bulk copy operation 3/5 close_connection Close an existing connection 2/5 commit Commit current transaction 2/5 connect_tool Connect to Microsoft SQL Server 2/5 set_autocommit Set autocommit mode 2/5 set_connection_timeout Set connection timeout 2/5 set_login_timeout Set login timeout 2/5

EXECUTE TOOLS

build_connection_string Build connection string 3/5 execute_query Execute SQL query and return results 3/5 execute_scalar Execute SQL and return single value 3/5 parse_connection_string Parse connection string 3/5

// FAQ

How many tools does the Mssql MCP server have? +

The Mssql MCP server exposes 21 tools across 3 categories: Read, Write, Execute.

How do I enforce policies on Mssql tools? +

Use Intercept, the open-source MCP proxy. Write YAML rules for each tool — rate limits, argument validation, or deny rules — then run Intercept in front of the Mssql server.

What risk categories do Mssql tools fall into? +

Mssql tools are categorised as Read (10), Write (7), Execute (4). Each category has a recommended default policy.

Enforce policies on Mssql

Open source. One binary. Zero dependencies.

npx -y @policylayer/intercept

github.com/policylayer/intercept →