jensenloke/mcp-sqlserver-pro
If you are the rightful owner of mcp-sqlserver-pro 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 Model Context Protocol (MCP) server that provides comprehensive access to Microsoft SQL Server databases.
Tools
Functions exposed to the LLM to take actions
read_query
Execute SELECT queries to read data
write_query
Execute INSERT, UPDATE, DELETE, and DDL queries
list_tables
List all tables in the database
describe_table
Get schema information for a specific table
create_table
Create new tables
create_procedure
Create new stored procedures
modify_procedure
Modify existing stored procedures
delete_procedure
Delete stored procedures
list_procedures
List all stored procedures with metadata
describe_procedure
Get complete procedure definitions
execute_procedure
Execute procedures with parameters
get_procedure_parameters
Get detailed parameter information
create_view
Create new views
modify_view
Modify existing views
delete_view
Delete views
list_views
List all views in the database
describe_view
Get view definitions and schema
create_index
Create new indexes
delete_index
Delete indexes
list_indexes
List all indexes (optionally by table)
describe_index
Get detailed index information
list_schemas
List all schemas in the database
list_all_objects
List all database objects organized by schema
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client