mssql-mcp

Query and manage Microsoft SQL Server and Azure SQL databases via MCP.

3|1|Updated Feb 2, 2026
One-click install
npx skills add https://github.com/HouseGarofalo/claude-code-base --skill mssql-mcp-housegarofalo
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: mssql-mcp
Source: https://github.com/HouseGarofalo/claude-code-base/tree/main/.claude/skills/mssql-mcp
Command: npx skills add https://github.com/HouseGarofalo/claude-code-base --skill mssql-mcp-housegarofalo

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill allows users to interact with Microsoft SQL Server databases using natural language, simplifying complex SQL queries and data management tasks.

Core Features & Use Cases

  • Query Execution: Run SQL queries described in natural language.
  • Data Modification: Insert, update, and delete data with safety features.
  • Schema Management: Create, modify, and drop database objects.
  • Database Inspection: Explore tables, schemas, and relationships.
  • Use Case: A data analyst needs to find the top 5 customers by revenue from the last quarter. They can ask the AI to "Show top 5 customers by total order amount in Q3 2023" and the skill will generate and execute the appropriate SQL query.

Quick Start

Use the mssql-mcp skill to get all users from the 'users' table.

Frequently Asked Questions about mssql-mcp

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query a SQL Server database using natural language instead of T-SQL?

You can query a SQL Server database using natural language by leveraging an MCP interface that translates your plain English requests into and executes the appropriate T-SQL statements automatically.

Can I use this MCP interface to modify data and manage schemas in Azure SQL?

Yes, this MCP interface supports data modification and schema management in Azure SQL, allowing you to insert, update, delete data, and create or drop database objects using natural language commands.

How do I prevent accidental data deletion when executing natural language SQL queries?

To prevent accidental data deletion during natural language SQL queries, the system includes built-in safety features like mandatory WHERE clauses for updates and deletes, plus an optional read-only mode.

Do I need to configure environment variables to connect to an Azure SQL database?

Yes, configuring environment variables is required to set server and database connection parameters, with additional options for specifying authentication methods and connection timeouts for Azure SQL.

What is the best way to inspect tables and relationships in a Microsoft SQL Server database?

The best way to inspect tables and relationships in a Microsoft SQL Server database is using natural language commands via MCP to explore schemas and database structure without writing manual T-SQL queries.