MCP SQL Server

MCP SQL Server

Public
JubinSaniei/mcp-mssql

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_TRUST_SERVER_CERT
Optional
string

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

Default: true
SQL_ENCRYPT
Optional
string

Enable encryption (set to 'false' to disable)

Default: true
SQL_MAX_RETRY_DELAY
Optional
string

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

Default: 30000
SQL_PORT
Optional
string

SQL Server port

Default: 1433
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_MAX_RETRIES
Optional
string

Max number of retries for initial connection attempts

Default: 3
SQL_SERVER
Optional
string

SQL Server hostname or IP

Default: localhost
SQL_POOL_IDLE_TIMEOUT
Optional
string

Idle timeout for connections in pool (ms)

Default: 30000
SQL_USER
Optional
string

SQL Server username

Default: sa
LOG_LEVEL
Optional
string

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

Default: info
MCP_SERVER_VERSION
Optional
string

Version of the MCP server

Default: 1.0.0
SQL_INITIAL_RETRY_DELAY
Optional
string

Initial delay (ms) before retrying a failed connection

Default: 1000
MCP_SERVER_NAME
Optional
string

Name of the MCP server

Default: MSSQL Server
SQL_DATABASE
Optional
string

Default database name to connect to

Default: master
SQL_POOL_MIN
Optional
string

Min connections in pool

Default: 0
SQL_PASSWORD
Optional
string

SQL Server password

SQL_POOL_MAX
Optional
string

Max connections in pool

Default: 10
SQL_CONNECTION_TIMEOUT
Optional
string

Connection timeout (ms)

Default: 30000
SQL_REQUEST_TIMEOUT
Optional
string

Request timeout for queries (ms)

Default: 30000
SQL_SCHEMA_CACHE_TTL
Optional
string

Time-To-Live for schema cache (ms)

Default: 300000

Security Notice

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

Related MCPs5
  • Command Executor MCP Server

    Secure Model Context Protocol server enabling execution of pre-approved commands with configurable command lists, real-time output streaming, robust error handling, and enhanced security validations for seamless integration.

    1 tools
    Added May 29, 2025
  • MSSQL MCP Server

    Model Context Protocol server enabling secure connection, SQL query execution, and efficient management of Microsoft SQL Server databases with built-in safeguards and connection pooling.

    Added May 30, 2025
  • Supabase MCP Server

    Open-source Model Context Protocol server enabling secure SQL execution, schema versioning, Supabase project management, and user administration with robust safety controls and seamless IDE integration.

    11 tools
    Added May 29, 2025
  • MySQL MCP Server

    Provides read-only access to MySQL databases for LLMs via the Model Context Protocol, enabling schema discovery and secure execution of SELECT queries with automatic SQL validation and simple configuration.

    Added May 30, 2025
  • Slowtime MCP Server

    Secure Model Context Protocol server enabling time-based operations with advanced timelock encryption, timing attack protection, interval management, and encrypted data analytics for enhanced security and privacy.

    Added May 30, 2025