brendankowitz/dotnet-sqlserver-mcp
If you are the rightful owner of dotnet-sqlserver-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 dayong@mcphub.com.
A .NET-based Model Context Protocol (MCP) server providing essential tools for SQL Server database inspection, querying, and debugging.
Tools
Functions exposed to the LLM to take actions
execute_sql
Run any SQL query, handling custom queries, aggregations, and metadata inspection.
describe_table
Inspect table schema with clean formatted output for columns, indexes, and constraints.
get_procedure_definition
View stored procedure source code without metadata noise.
list_stored_procedures
Find available stored procedures with creation and modification dates.
get_query_stats
Performance debugging with pre-formatted top queries by CPU, duration, and execution count.
get_connections
Monitor active sessions with program names and login times.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client