jpcanter/sql-server-mcp
3.2
If you are the rightful owner of sql-server-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A production-ready Model Context Protocol (MCP) server for Microsoft SQL Server with comprehensive stored procedure management, virtual filesystem protocol, and safe write operations.
Tools
Functions exposed to the LLM to take actions
search_stored_procedures
Search SPs by name or content.
get_table_schema
Get table structure with columns, indexes, foreign keys.
get_dependencies
Analyze object dependencies (callers and references).
analyze_sp_performance
View execution statistics from plan cache.
execute_query_write
Execute INSERT/UPDATE/DELETE with validation.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client