Back to Home
scopweb icon

mcp-go-mssql

Verified Safe

by scopweb

Overview

Provides secure Microsoft SQL Server connectivity for AI assistants via the Model Context Protocol (MCP) or a CLI tool, supporting robust security and granular access controls.

Installation

Run Command
go run main.go

Environment Variables

  • MSSQL_SERVER
  • MSSQL_DATABASE
  • MSSQL_USER
  • MSSQL_PASSWORD
  • MSSQL_PORT
  • MSSQL_AUTH
  • MSSQL_ENCRYPT
  • MSSQL_CONNECTION_STRING
  • MSSQL_READ_ONLY
  • MSSQL_WHITELIST_TABLES
  • MSSQL_MAX_QUERY_SIZE
  • DEVELOPER_MODE

Security Notes

The project demonstrates an excellent security posture. It explicitly protects against SQL injection using prepared statements, prevents command injection with a dangerous keyword blacklist, and mitigates authentication bypass via mandatory TLS encryption and strong credential handling. Sensitive data is sanitized in logs, and `DEVELOPER_MODE` ensures generic errors in production to prevent information leakage. A key feature is the granular table permissions (whitelist) that validates all tables in modification queries, enhancing AI safety. Comprehensive security testing with `govulncheck` and `gosec` confirms no known vulnerabilities in dependencies or the codebase. No 'eval'-like functions or obfuscation are present, and race conditions are actively tested for.

Similar Servers

Stats

Interest Score0
Security Score10
Cost ClassLow
Avg Tokens1
Stars0
Forks0
Last Update2025-12-04

Tags

MCPSQL ServerGoDatabaseAI-Assistant