
MCP SQL Server
Model Context Protocol server enabling secure execution of SELECT queries, stored procedures, and schema exploration on SQL Server databases with robust connection management, configurable caching, and enhanced security features.
Supercharge Your AI with MCP SQL Server
Unlock the full potential of MCP SQL Server through LangDB's AI Gateway. Get enterprise-grade security, analytics, and seamless integration with zero configuration.
Free tier available • No credit card required
Trust server certificate (set to 'false' to disable)
trueEnable encryption (set to 'false' to disable)
trueMaximum delay (ms) for connection retries (uses exponential backoff)
30000SQL Server port
1433Comma-separated list of databases the server is allowed to access. If empty, access is less restricted (relies on DB user permissions).
Max number of retries for initial connection attempts
3SQL Server hostname or IP
localhostIdle timeout for connections in pool (ms)
30000SQL Server username
saLog level for pino logger (e.g., 'fatal', 'error', 'warn', 'info', 'debug', 'trace', 'silent')
infoVersion of the MCP server
1.0.0Initial delay (ms) before retrying a failed connection
1000Name of the MCP server
MSSQL ServerDefault database name to connect to
masterMin connections in pool
0SQL Server password
Max connections in pool
10Connection timeout (ms)
30000Request timeout for queries (ms)
30000Time-To-Live for schema cache (ms)
300000Security Notice
Your environment variables and credentials are securely stored and encrypted. LangDB never shares these configuration values with third parties.