mssql-mcp

Nirmal123K/mssql-mcp

3.2

If you are the rightful owner of mssql-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.

The MSSQL MCP Server is a Model Context Protocol server that allows AI assistants to interact with both local SQL Server and Azure SQL Database using natural language.

Tools

Functions exposed to the LLM to take actions

read_data

Query data with SELECT

insert_data

Add new records

update_data

Modify existing data

create_table

Create new tables

create_index

Add database indexes

drop_table

Remove tables

list_tables

Show all tables

describe_table

Show table structure

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources