Enables AI assistants to explore and query Microsoft SQL Server databases securely via the Model Context Protocol.
Sponsored
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
01Flexible authentication (Windows and SQL Server Authentication)
02Smart limits on query results to prevent overwhelming responses
032 GitHub stars
04MCP compliant using the official C# SDK
05Provides tools for listing tables, getting table details, and running queries
06Secure by default (only SELECT queries allowed)
Use Cases
01Allowing AI assistants to retrieve a list of all tables and views in a SQL Server database.
02Executing safe, read-only SQL SELECT queries against a SQL Server database via an AI assistant.
03Enabling AI assistants to fetch detailed schema information (columns, types, keys) for specific database tables.
