Back to Home
NicolasPirello icon

Microsoft-SQL-Server-MCP-Server

by NicolasPirello

Overview

Connect AI assistants to Microsoft SQL Server databases for natural language queries and data inspection.

Installation

Run Command
docker compose up mcp_server

Environment Variables

  • MSSQL_SERVER
  • MSSQL_DATABASE
  • MSSQL_USER
  • MSSQL_PASSWORD
  • MSSQL_PORT
  • MSSQL_ENCRYPT
  • MSSQL_TRUST_SERVER_CERTIFICATE
  • MSSQL_WINDOWS_AUTH
  • MSSQL_DRIVER
  • PYTHONPATH

Security Notes

The `call_tool` function directly executes arbitrary SQL queries provided by the AI assistant, including DML and DDL operations (e.g., INSERT, UPDATE, DELETE, CREATE, DROP). This contradicts the README's claim of being 'Solo Lectura (Seguro)' and presents a critical security risk. While `read_resource` validates table names, the `execute_sql` tool has no built-in restrictions on query type. The `docker-compose.yml` uses 'sa' as the default database user, which goes against the security best practices outlined in `SECURITY.md` (recommending minimal permissions and avoiding admin accounts). Without extremely strict database user permissions, this server can be used to execute destructive commands.

Similar Servers

Stats

Interest Score0
Security Score3
Cost ClassHigh
Avg Tokens10000
Stars0
Forks0
Last Update2025-12-10

Tags

MCP ServerSQL ServerAI AssistantDatabaseNatural Language Query