MCPRUNNER/mssqlMCP
3.3
If you are the rightful owner of mssqlMCP 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.
This is a Model Context Protocol (MCP) server that connects to one or more SQL Server databases; designed to be used by Visual Studio Code as a Copilot Agent.
Tools
Functions exposed to the LLM to take actions
initialize
Initializes the SQL Server connection
executeQuery
Executes a SQL query and returns results as JSON
getTableMetadata
Retrieves metadata about database tables, columns, keys, etc.
getDatabaseObjectsMetadata
Retrieves metadata about tables, views, stored procedures and functions
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client