Waqaar-Rasool/MCP.SqlServer
3.2
If you are the rightful owner of MCP.SqlServer and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.
A comprehensive Model Context Protocol (MCP) server providing AI agents with SQL Server database operations, PowerShell script execution, and document processing capabilities.
MSSQL MCP Server
A comprehensive Model Context Protocol (MCP) server providing AI agents with SQL Server database operations, PowerShell script execution, and document processing capabilities.
Overview
This MCP server enables Large Language Models (LLMs) like ChatGPT to interact with:
- SQL Server databases - Execute queries, manage schemas, retrieve metadata
- PowerShell scripts - Run automation scripts and system commands
- Documents - Read and process PDF and text documents
Built with C# with principle for clean, maintainable code.
Features
🗄️ SQL Server Operations
- Execute any SQL command (DQL, DML, DDL, DCL, TCL)
- List tables with row counts and size information
- Query database schemas and metadata
- Configurable connection strings via environment variables
⚡ PowerShell Execution
- Execute PowerShell scripts and commands
- Run .ps1 script files
- Get installed modules and version information
📄 Document Processing
- Read PDF documents with advanced text extraction
- Process text files from configured directories
- Document caching for improved performance
- Uses PdfPig for intelligent PDF parsing