RichardHan_mssql_mcp_server
0
This project is an MCP server designed for secure interaction with Microsoft SQL Server databases. It allows users to list, read, and execute SQL queries safely. Key features include secure access and automatic dependency handling.
Microsoft SQL Server MCP Server
A Model Context Protocol (MCP) server facilitating secure interaction with Microsoft SQL Server databases. This project enables listing tables, reading data, and executing SQL queries via a controlled interface.
Features
- List SQL Server tables
- Read data
- Execute SQL queries with error handling
- Secure access via environment variables
- Comprehensive logging
- Automatic dependency installation
Security Considerations
- Avoid committing credentials
- Use minimal permissions
- Implement query whitelisting
- Enable logging