mcp-sqlserver-pro

jensenloke/mcp-sqlserver-pro

3.4

If you are the rightful owner of mcp-sqlserver-pro and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

A Model Context Protocol (MCP) server that provides comprehensive access to Microsoft SQL Server databases.

The MSSQL MCP Server is an advanced server designed to facilitate seamless interaction between Language Models and Microsoft SQL Server databases. It offers a standardized interface for inspecting database schemas, executing queries, managing database objects, and performing advanced operations. This server is equipped with 23 comprehensive database management tools, allowing for full exploration and manipulation of database object hierarchies, including tables, views, stored procedures, indexes, and schemas. It supports intelligent resource access, enabling all tables and views to be available as MCP resources. The server is optimized for handling large content, such as retrieving complete stored procedures without truncation, and ensures secure operations by separating read-only and write operations.

Features

  • Complete Database Schema Traversal
  • Advanced Database Object Management
  • Intelligent Resource Access
  • Large Content Handling
  • Security and Validation

Usages

usage with Claude Desktop

{
  "mcpServers": {
    "mssql": {
      "command": "python3",
      "args": ["/path/to/mcp-sqlserver/src/server.py"],
      "cwd": "/path/to/mcp-sqlserver",
      "env": {
        "MSSQL_SERVER": "your-server",
        "MSSQL_DATABASE": "your-database",
        "MSSQL_USER": "your-username",
        "MSSQL_PASSWORD": "your-password"
      }
    }
  }
}

Tools

  1. read_query

    Execute SELECT queries to read data

  2. write_query

    Execute INSERT, UPDATE, DELETE, and DDL queries

  3. list_tables

    List all tables in the database

  4. describe_table

    Get schema information for a specific table

  5. create_table

    Create new tables

  6. create_procedure

    Create new stored procedures

  7. modify_procedure

    Modify existing stored procedures

  8. delete_procedure

    Delete stored procedures

  9. list_procedures

    List all stored procedures with metadata

  10. describe_procedure

    Get complete procedure definitions

  11. execute_procedure

    Execute procedures with parameters

  12. get_procedure_parameters

    Get detailed parameter information

  13. create_view

    Create new views

  14. modify_view

    Modify existing views

  15. delete_view

    Delete views

  16. list_views

    List all views in the database

  17. describe_view

    Get view definitions and schema

  18. create_index

    Create new indexes

  19. delete_index

    Delete indexes

  20. list_indexes

    List all indexes (optionally by table)

  21. describe_index

    Get detailed index information

  22. list_schemas

    List all schemas in the database

  23. list_all_objects

    List all database objects organized by schema