Mssql
io.github.ConnorBritain/mssql is a MCP server that connects agents to Microsoft SQL Server for schema discovery, profiling, safe writes, and DDL.
About
io.github.ConnorBritain/mssql is a Model Context Protocol server that connects coding agents to Microsoft SQL Server with schema discovery, profiling, safe writes, and DDL. Developers shipping B2B SaaS, internal tools, or API products on SQL Server often bounce between SSMS, scripts, and chat without the model seeing real catalog metadata; this MCP closes that gap so Claude Code or Cursor can propose queries and migrations grounded in your database. It belongs on the Build / backend shelf as a task integration, not a methodology skill. Use it while designing tables, seeding dev data, or iterating stored procedures—then tighten access before production Ship. ConnorBritain also publishes read-only and writer-only variants; choose this package when one dev environment needs the full tool surface. You will need a reachable SQL Server instance, connection string or auth your host can inject securely, and Node for the npm package. Treat DDL and writes as high-impact: pair with code review and separate reader MCP in CI or prod-adjacent workflows.
- Schema discovery and profiling so agents understand tables, columns, and data shape before generating queries
- Safe write paths for data changes alongside read operations
- DDL support for creating and altering database objects during development
- Node npm server @connorbritain/mssql-mcp-server (v0.4.5) with stdio MCP transport
- Single full-capability server when you trust the agent with schema and data mutations in dev
Mssql by the numbers
- Data as of Jul 7, 2026 (Skillselion catalog sync)
claude mcp add mssql -- npx -y @connorbritain/mssql-mcp-serverAdd your badge
Show developers this MCP server is listed on Skillselion. Paste this into your README.
| Package | @connorbritain/mssql-mcp-server |
|---|---|
| Transport | STDIO |
| Auth | None |
What it does
Give your coding agent full Microsoft SQL Server access for schema exploration, data profiling, controlled writes, and DDL when building or evolving a.NET or SQL-backed product.
Who is it for?
Best when you're on SQL Server and want one MCP server for exploration plus schema and data changes in local or staging databases.
Skip if: Production databases where you want zero DDL and minimal write surface—use mssql-reader or mssql-writer instead.
What you get
After registration, your agent profiles schemas, runs informed queries, applies safe writes, and executes DDL in dev with context from the real database.
- Grounded SQL and migration suggestions from live schema discovery
- Data profiling context for query and API design
- Ability to apply writes and DDL through MCP tools in dev
By the numbers
- Capabilities: schema discovery, profiling, safe writes, and DDL
- Package @connorbritain/mssql-mcp-server version 0.4.5
- Transport: stdio
Recommended MCP Servers
A2dbSafe, read-only database access for AI agents.2
AdoMcpDatabase MCP server for schema discovery, comments, and SQL queries.1
Afgong Sqlite Mcp ServerExplore your Messages SQLite database to browse tables and inspect schemas with ease.
AI ERDAI-powered ERD design tool.
AirtableCreate, read, update, and delete records in Airtable bases and tables29
AirtableRead and write access to Airtable database schemas, tables, and records.455How it compares
Full-capability SQL Server MCP bridge, not an ORM code generator skill or Azure-only data studio integration.
FAQ
Who is io.github.ConnorBritain/mssql for?
Developers building on Microsoft SQL Server who want MCP-enabled agents to discover schema, profile data, write rows, and manage DDL in trusted dev environments.
When should I use io.github.ConnorBritain/mssql?
Use it during Build when modeling schema, migrating tables, debugging data issues, or generating SQL backed by live catalog and profile metadata.
How do I add io.github.ConnorBritain/mssql to my agent?
Install @connorbritain/mssql-mcp-server from npm, add a stdio MCP entry in Claude Code or Cursor, and configure SQL Server connection settings per the package README without committing secrets.