Microsoft SQL Server MCP Server & Skill

What you can do with Microsoft SQL Server

Built for

Developers, analysts, and operators working with Microsoft SQL Server or Azure SQL

Example workflows

Explore an unfamiliar database

Database list, schema search, inspect schema, then bounded read.

List databases on my SQL Server instance, search for tables matching %order%, then inspect the best match before reading ten sample rows.

Safe row update

update_rows preview=true confirms the predicate before mutation.

Try this

Update the status column to shipped for order id 12345 in dbo.orders and show the preview rows before applying the change.

Context to know first

Does update rows show what will change?

Yes — update rows runs a SELECT preview of up to ten matching rows before the UPDATE by default so agents can verify the where clause.

AI Skill
SKILL.md

Domain knowledge for Microsoft SQL Server — workflow patterns, data models, and gotchas for your AI agent.

Microsoft SQL Server

SQL Server access via standard host/port/database credentials. Read tools reject mutating SQL; write tools allow only INSERT, UPDATE, and DELETE.

Operational order

List databases or list tables / search schema before writing ad hoc SQL.
Inspect schema for column, key, and index detail on a known table (prefer over describe schema for new work).
List rows or search rows for bounded table reads with pagination.
Explain query when a SELECT is slow — estimated SHOWPLAN by default; set analyze for actual plans.
Execute read SQL only for SELECT/WITH/SHOW-style statements you have validated against live schema.
Insert row, update rows, or execute write SQL for parameterized mutations; delete rows requires confirm_write=true.

Encryption

Set encrypt to true for Azure SQL and other TLS-required hosts. trust_server_certificate may be required for self-signed dev instances.

Gotchas

Schema names default to dbo in describe/search helpers — pass schema_name when objects live elsewhere.
describe_schema is legacy column-only detail; use inspect_schema for keys, indexes, and row estimates.
update_rows returns a preview of matching rows by default before applying the UPDATE.
execute_read_sql and execute_write_sql reject statements outside their allowed classes.
Write tools block DROP, ALTER, CREATE, TRUNCATE, MERGE, and EXEC.

Tools in this Server (13)

Mssql Delete Rows

Delete rows from one SQL Server table matching a parameterized WHERE clause. Set confirm_write=true after validating the predicate with a read query.

Mssql Describe Schema

Describe columns for one SQL Server table via INFORMATION_SCHEMA.COLUMNS.

Mssql Execute Read SQL

Execute a read-only SQL statement. Mutating statements are rejected before execution. Inspect schema first when column names are uncertain.

Mssql Execute Write SQL

Execute one parameterized INSERT, UPDATE, or DELETE statement. DDL and other mutating statements are rejected before execution.

Mssql Explain Query

Return a SQL Server execution plan as XML. Estimated plans use SHOWPLAN; set analyze=true for an actual plan via STATISTICS XML.

Mssql Insert Row

Insert one row into a SQL Server table using a column map. Inspect schema first when column names are uncertain.

Mssql Inspect Schema

Inspect a SQL Server schema or table: columns, primary keys, foreign keys, and indexes. Run before raw SQL when column names are unknown.

Mssql List Databases

List databases visible on the connected SQL Server instance. Use before switching the credential database when exploring multiple catalogs.

Mssql List Rows

Browse rows from one SQL Server table with optional filter, column selection, sorting, and pagination.

Mssql List Tables

List tables in the connected SQL Server database with optional schema filter.

Mssql Search Rows

Search rows in one table with a parameterized WHERE clause. Use ? placeholders in where_sql and pass matching params.

Mssql Search Schema

Search table and column names with SQL LIKE wildcards (% and _). Prefer inspect_schema for full table detail once you know the table name.

Mssql Update Rows

Update rows in one SQL Server table with a parameterized SET map and WHERE clause. Always include a selective where_sql predicate.

Frequently Asked Questions

Does update rows show what will change?

Yes — update rows runs a SELECT preview of up to ten matching rows before the UPDATE by default so agents can verify the where clause.

How do I connect Microsoft SQL Server to my AI agent?

Add the MCPBundles server URL to your MCP client configuration (Claude Desktop, Cursor, VS Code, etc.). The URL format is: https://mcp.mcpbundles.com/bundle/mssql. Authentication is handled automatically.

How many tools does Microsoft SQL Server provide?

Microsoft SQL Server provides 13 tools that can be called by AI agents, along with a SKILL.md that gives your AI agent domain knowledge about when and how to use them.

What authentication does Microsoft SQL Server require?

Microsoft SQL Server uses API Key. Microsoft SQL Server requires credentials. Connect via MCPBundles and authentication is handled automatically.

Microsoft SQL Server MCP Server

What you can do with Microsoft SQL Server

Example workflows

Context to know first

AI Skill
SKILL.md

Microsoft SQL Server

Operational order

Encryption

Gotchas

Tools in this Server (13)

Frequently Asked Questions

Setup Instructions

One-click install:

Or add manually

Related MCP Servers

Ready to use Microsoft SQL Server?

Microsoft SQL Server MCP Server

What you can do with Microsoft SQL Server

Example workflows

Context to know first

AI SkillSKILL.md

Microsoft SQL Server

Operational order

Encryption

Gotchas

Tools in this Server (13)

Frequently Asked Questions

Setup Instructions

One-click install:

Or add manually

Related MCP Servers

Ready to use Microsoft SQL Server?

AI Skill
SKILL.md