Mssql
CreatedRichardHan
Enables secure interaction with Microsoft SQL Server databases via a controlled interface for AI assistants.
About
Mssql provides a secure Model Context Protocol (MCP) server that enables AI assistants to interact safely with Microsoft SQL Server databases. It allows listing available tables, reading data, and executing SQL queries through a controlled interface, enhancing database exploration and analysis while maintaining security and structure. The server manages database access through environment variables, offers comprehensive logging, and automates system dependency installation.
Key Features
- Executes SQL queries with error handling
- 28 GitHub stars
- Lists available SQL Server tables as resources
- Secures database access through environment variables
- Reads table contents
- Provides comprehensive logging
Use Cases
- Enables safe reading of data from SQL Server tables by AI agents
- Allows AI agents to execute SQL queries in a controlled environment
- Securely allows AI assistants to list SQL Server tables