MSSQL MCP Server

MSSQL MCP Server

Public
daobataotie/mssql-mcp

Provides Model Context Protocol-based database interaction and business intelligence capabilities, enabling SQL query execution, data analysis, and automated generation of business insight memos for efficient MSSQL management.

python
0 tools
May 30, 2025
Updated Jun 4, 2025

Supercharge Your AI with MSSQL MCP Server

MCP Server

Unlock the full potential of MSSQL MCP 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
DATABASE_USERNAME
Optional
string

Username for SQL Server authentication

SERVER_HOST
Optional
string

Host address for the MCP server

Default: 0.0.0.0
DATABASE_SERVER
Optional
string

The SQL Server address/IP

DATABASE_DRIVER
Optional
string

The ODBC driver to use for SQL Server connection

Default: ODBC Driver 17 for SQL Server
DATABASE_NAME
Optional
string

The database name to connect to

SERVER_PORT
Optional
string

Port for the MCP server

Default: 8080
DATABASE_PASSWORD
Optional
string

Password for SQL Server authentication

DATABASE_TRUSTED_CONNECTION
Optional
string

Whether to use Windows authentication (trusted connection)

Default: false

Security Notice

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

Related MCPs5
  • SQLite MCP Server

    Model Context Protocol server enabling SQLite database interactions, SQL query execution, and automated business insight generation through dynamic memos and comprehensive analysis tools.

    6 tools
    Added May 30, 2025
  • IoTDB MCP Server

    Provides Model Context Protocol (MCP) support for IoTDB, enabling SQL query execution, metadata retrieval, and schema inspection through configurable tree or table data models for advanced database interaction and business intelligence.

    Added May 29, 2025
  • Multi Database MCP Server

    Provides AI assistants with unified, multi-database access via the Model Context Protocol, enabling SQL query execution, transaction management, schema exploration, and performance analysis across MySQL, PostgreSQL, and TimescaleDB with dynamic tool generation and clean architecture.

    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
  • MySQL-MCP

    Model Context Protocol server enabling MySQL database interaction, schema management, SQL query execution, and automated generation of continuously updated business insights for enhanced data-driven decision making.

    Added May 29, 2025