Mssql
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.
Overview
io.github.ConnorBritain/mssql is a MCP server for the Build phase that connects agents to Microsoft SQL Server for schema discovery, profiling, safe writes, and DDL.
What is this MCP server?
- 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
- Capabilities: schema discovery, profiling, safe writes, and DDL
- Package @connorbritain/mssql-mcp-server version 0.4.5
- Transport: stdio
What problem does it solve?
Agents guess table names and write unsafe SQL because they lack live visibility into your SQL Server schema and controlled mutation tools.
Who is it for?
Solo builders on SQL Server who 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 do I get? / Deliverables
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
Recommended MCP Servers
Journey fit
How it compares
Full-capability SQL Server MCP bridge, not an ORM code generator skill or Azure-only data studio integration.
Common Questions / 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.