Last updated
March 16, 2026
MCP profile
Github ConnorBritain Mssql
MCP server for Microsoft SQL Server - schema discovery, profiling, and safe data operations
Data & AnalyticsPackageJavaScript/TypeScriptOpen SourceExternal
Visibility
Public
ByRegistry
About This MCP Server
A production-ready MCP server built for real-world database work: exploring unfamiliar schemas, profiling data shape, validating pipelines in UAT, and moving confidently to production. If you work with SQL Server and want AI tooling that understands enterprise database workflows, this is for you.
Capabilities
Navigating massive schemas you didn't design, often with cryptic naming conventionsUnderstanding data shape before writing anythingWorking safely in regulated environments where one bad UPDATE can trigger an incidentMoving fast in UAT so you can validate changes before they hit production
Tools & Endpoints12
Why Use Github ConnorBritain Mssql?
- Navigating massive schemas you didn't design, often with cryptic naming conventions
- Understanding data shape before writing anything
- Working safely in regulated environments where one bad UPDATE can trigger an incident
- Moving fast in UAT so you can validate changes before they hit production
Specifications
Status
live
Industry
Data & Analytics
Category
General
Server type
Package
Language
JavaScript/TypeScript
License
Open Source
Verified
Yes
Requirements
- You’ll need a current Node.js runtime (minimum 18, recommended 20 LTS). The tooling now shims legacy APIs so it also works on the newest Node releases, but installing an LTS build avoids surprises on fresh machines.
- Verify with node -v (should show v20.x). If you already have a newer Node version installed, the server will still run thanks to the built-in SlowBuffer shim.
Hosting
Hosting Options
- Package
API
Integrate this server into your application. Choose a connection method below.
1
Install
Install command
JavaScript/TypeScript
npm install -g @connorbritain/mssql-mcp-server@latestPerformance
Usage
Quick Reference
- Name
- Github ConnorBritain Mssql
- Function
- MCP server for Microsoft SQL Server - schema discovery, profiling, and safe data operations
- Available Tools
- search_schema – Wildcard/fuzzy search across tables and columns with pagination., describe_table – Column definitions, types, nullability, keys., list_table – List all tables in a database with optional filtering., list_databases – List databases on server-level environments., list_environments – Show configured environments and their policies., profile_table – Column stats (null %, cardinality, min/max/avg/median/p90) with optional sample rows., inspect_relationships – FK mappings in both directions., inspect_dependencies – Full dependency analysis (views, procs, functions, triggers referencing an object)., explain_query – Execution plan analysis via SHOWPLAN., read_data – Safe SELECT with automatic row limits., insert_data – Parameterized inserts (single or batch)., update_data – Preview affected rows, require confirmation.
- Transport
- Package
- Language
- JavaScript/TypeScript
- Install
- npm install -g @connorbritain/mssql-mcp-server@latest
- Source
- External (Registry)
- License
- Open Source
Get started
Ready to integrate this MCP server?
Book a demo to see how this server fits your workflow, or explore the full catalog.