AI Atlas

Database · Developer Tools

MCP Sqlserver Pro

jensenloke/mcp-sqlserver-pro

A Model Context Protocol (MCP) server that provides comprehensive access to Microsoft SQL Server databases. This enhanced server enables Language Models to inspect database schemas, execute queries, manage database objects, and perform advanced database operations through a standardized interface.

View on GitHub

Install

Client configuration

{
  "mcpServers": {
    "mssql": {
      "command": "python3",
      "args": [
        "/path/to/mcp-sqlserver/src/server.py"
      ],
      "env": {
        "MSSQL_SERVER": "<MSSQL_SERVER>",
        "MSSQL_DATABASE": "<MSSQL_DATABASE>",
        "MSSQL_USER": "<MSSQL_USER>",
        "MSSQL_PASSWORD": "<MSSQL_PASSWORD>"
      }
    }
  }
}

Environment variables

MSSQL_SERVERMSSQL_DATABASEMSSQL_USERMSSQL_PASSWORDMSSQL_DRIVERMSSQL_PORT
Author
@jensenloke
Category
Database, Developer Tools
Updated
Oct 6, 2026

Features

  • 23 comprehensive database management tools (expanded from 5 basic operations)

  • Full database object hierarchy exploration - tables, views, stored procedures, indexes, schemas

  • Advanced database object management - create, modify, delete operations

  • Intelligent resource access - all tables and views available as MCP resources

  • Large content handling - retrieves complete stored procedures (1400+ lines) without truncation

  • Database Connection: Connect to MSSQL Server instances with flexible authentication

  • Schema Inspection: Complete database object exploration and management

  • Query Execution: Execute SELECT, INSERT, UPDATE, DELETE, and DDL queries

  • Stored Procedure Management: Create, modify, execute, and manage stored procedures

  • View Management: Create, modify, delete, and describe views

Tools (20)

  • Views

    5 tools (create, modify, delete, list, describe)

  • Indexes

    4 tools (create, delete, list, describe)

  • Total

    23 tools + enhanced write_query supporting all database object operations

  • read_query

    Execute SELECT queries to read data

  • write_query

    Execute INSERT, UPDATE, DELETE, and DDL queries

  • describe_table

    Get schema information for a specific table

  • create_table

    Create new tables

  • create_procedure

    Create new stored procedures

  • modify_procedure

    Modify existing stored procedures

  • delete_procedure

    Delete stored procedures

  • describe_procedure

    Get complete procedure definitions

  • execute_procedure

    Execute procedures with parameters

  • get_procedure_parameters

    Get detailed parameter information

  • create_view

    Create new views

  • modify_view

    Modify existing views

  • delete_view

    Delete views

  • describe_view

    Get view definitions and schema

  • create_index

    Create new indexes

  • delete_index

    Delete indexes

  • describe_index

    Get detailed index information

Details on this page are taken from the project's README. Open README

Supported clients

Clients mentioned in this server's README:

View all
Claude Desktop logo

Claude Desktop

Desktop · Freemium · Proprietary

Anthropic's official Claude AI desktop application. Supports MCP servers to extend functionality.

WindowsMacOS
Cursor logo

Cursor

Desktop · Freemium · Proprietary

The first agentic IDE. The Cursor editor truly merges how developers and AI work together, delivering a magical coding experience.

WindowsMacOSLinux

Related MCP servers

More servers
Supabase MCP logo

Supabase MCP

supabase-community/supabase-mcp

1.3k

The Model Context Protocol (MCP) standardizes how Large Language Models (LLMs) talk to external services like Supabase. It connects AI assistants directly with your Supabase project and allows them to perform tasks like managing tables, fetching config, and querying data. See the full list of tools.

Database
Genai Toolbox logo

Genai Toolbox

googleapis/genai-toolbox

769

MCP Toolbox for Databases is an open source Model Context Protocol (MCP) server that connects your AI agents, IDEs, and applications directly to your enterprise databases.

Database
Supabase MCP Server logo

Supabase MCP Server

alexander-zuev/supabase-mcp-server

677

Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.

Database
Awesome MCP List logo

Awesome MCP List

MobinX/awesome-mcp-list

645

This is a continuously updated curated list of MCP servers, covering categories such as browser control, arts and culture, cloud platforms, command line, communication, customer data platforms, databases, developer tools, data science tools, file systems, finance and fintech, gaming, knowledge and memory, location services, marketing, monitoring, search and utilities. Each project includes a GitHub link and star count for quick reference and use.

Database
PostgreSQL Model Context Protocol (PG MCP) Server logo

PostgreSQL Model Context Protocol (PG MCP) Server

stuzero/pg-mcp-server

440

PG-MCP is a server implementation of the Model Context Protocol for PostgreSQL databases. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases through MCP's resource-oriented architecture.

Database
dbhub logo

dbhub

bytebase/dbhub

332

[!NOTE] If you need an enterprise-level database MCP server with built-in guardrails like approval flow, access control, data masking, and audit logging beyond what DBHub offers, check out Bytebase.

Database