MCP SQL Server

Name: MCP SQL Server
Availability: InStock
Author: LangDB

Public

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.

typescript

0 tools

May 30, 2025

Updated Jun 4, 2025

Supercharge Your AI with MCP SQL Server

MCP 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.

Unified API Access

Complete Tracing

Instant Setup

Get Started Now

Free tier available • No credit card required

Instant Setup

99.9% Uptime

10,000+Monthly Requests

Configuration Requirements

none

Configure authentication and required variables to access this MCP server

Required Environment Variables

SQL_ALLOWED_DATABASES

Optional

string

Comma-separated list of databases the server is allowed to access. If empty, access is less restricted (relies on DB user permissions).

SQL_POOL_MIN

Optional

string

Min connections in pool

Default: 0

SQL_REQUEST_TIMEOUT

Optional

Publicly Shared Threads0

Discover shared experiences

LOG_LEVEL

Optional

string

Log level for pino logger (e.g., 'fatal', 'error', 'warn', 'info', 'debug', 'trace', 'silent')

Default: info

SQL_POOL_IDLE_TIMEOUT

Optional

string

Idle timeout for connections in pool (ms)

Default: 30000

SQL_CONNECTION_TIMEOUT

Optional

string

Connection timeout (ms)

Default: 30000

SQL_TRUST_SERVER_CERT

Optional

string

Trust server certificate (set to 'false' to disable)

Default: true

SQL_PORT

Optional

string

SQL Server port

Default: 1433

SQL_DATABASE

Optional

string

Default database name to connect to

Default: master

MCP_SERVER_NAME

Optional

string

Name of the MCP server

Default: MSSQL Server

SQL_MAX_RETRIES

Optional

string

Max number of retries for initial connection attempts

Default: 3

SQL_USER

Optional

string

SQL Server username

Default: sa

SQL_POOL_MAX

Optional

string

Max connections in pool

Default: 10

SQL_SERVER

Optional

string

SQL Server hostname or IP

Default: localhost

SQL_INITIAL_RETRY_DELAY

Optional

string

Initial delay (ms) before retrying a failed connection

Default: 1000

SQL_SCHEMA_CACHE_TTL

Optional

string

Time-To-Live for schema cache (ms)

Default: 300000

SQL_MAX_RETRY_DELAY

Optional

string

Maximum delay (ms) for connection retries (uses exponential backoff)

Default: 30000

MCP_SERVER_VERSION

Optional

string

Version of the MCP server

Default: 1.0.0

SQL_ENCRYPT

Optional

string

Enable encryption (set to 'false' to disable)

Default: true

Security Notice

Your environment variables and credentials are securely stored and encrypted. LangDB never shares these configuration values with third parties.

Related MCPs5

MCP SSH Server
Secure Model Context Protocol (MCP) SSH server enabling remote command execution, file and directory...
Added May 30, 2025
ERPNext MCP Server
Model Context Protocol server enabling seamless integration with ERPNext via API, offering authentic...
Xano MCP Server for Smithery
Model Context Protocol server enabling seamless integration between Claude AI and Xano databases wit...
CouchDB MCP Server
Model Context Protocol server enabling AI assistants to manage CouchDB databases and documents with ...
PPTX MCP Server
FastMCP-powered Model Context Protocol server enabling programmatic creation, editing, and rendering...