A-Point-Systems-ltd/ms-sql-mcp
If you are the rightful owner of ms-sql-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.
This project is a .NET 9 console application implementing a Model Context Protocol (MCP) server for MSSQL Databases using the official MCP C# SDK.
Tools
Functions exposed to the LLM to take actions
ListTables
List all tables in the database
DescribeTable
Get comprehensive table details
CreateTable
Create new tables
DropTable
Drop existing tables
InsertData
Insert data into tables
ReadData
Read/query data from tables
UpdateData
Update values in tables
ExecuteSQL
Execute custom SQL commands
ListStoredProcedures
List all stored procedures with descriptions
GetStoredProc
Get stored procedure details
ListTableFunctions
List all table-valued functions
ListScalarFunctions
List all scalar functions
GetFunction
Get function details
ListViews
List all views
DescribeView
Get view definition
ListTableTriggers
List all table triggers
GetTrigger
Get trigger details
ListSysObjects
List sys.objects with optional type filtering
GetServerInfo
Get comprehensive SQL Server metadata
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client