MSSQL

About

This Model Context Protocol (MCP) server provides a robust interface for AI assistants to interact with Microsoft SQL Server databases. It offers essential tools for database exploration, including listing tables and views, retrieving detailed table schema information, and executing safe SELECT queries. Built with the official MCP C# SDK, it emphasizes security by blocking DML/DDL operations, supports both Windows and SQL Server authentication, and incorporates smart limits to manage query results effectively. This tool is ideal for integrating SQL Server data access directly into AI-driven workflows and applications.

Key Features

• Flexible authentication (Windows and SQL Server Authentication)
• Smart limits on query results to prevent overwhelming responses
• 2 GitHub stars
• MCP compliant using the official C# SDK
• Provides tools for listing tables, getting table details, and running queries
• Secure by default (only SELECT queries allowed)

Use Cases

• Allowing AI assistants to retrieve a list of all tables and views in a SQL Server database.
• Executing safe, read-only SQL SELECT queries against a SQL Server database via an AI assistant.
• Enabling AI assistants to fetch detailed schema information (columns, types, keys) for specific database tables.