acpepper/mcp-server-mssql
If you are the rightful owner of mcp-server-mssql 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 Model Context Protocol (MCP) server for Microsoft SQL Server databases, providing secure database operations through a standardized interface.
Tools
Functions exposed to the LLM to take actions
list_table
List tables in the database, optionally filtered by schema.
read_data
Execute SELECT queries with security validation.
describe_table
Get table schema information.
describe_index
Get index information for tables.
insert_data
Insert data into tables.
update_data
Update existing records.
create_table
Create new tables.
create_index
Create indexes on tables.
drop_table
Drop tables (use with caution).
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client