Mssql Writer
Let coding agents read and mutate SQL Server data via MCP while blocking DDL, so you can seed dev DBs and fix rows without schema-drop risk.
Overview
io.github.ConnorBritain/mssql-writer is a MCP server for the Build phase that enables read and data-write operations on Microsoft SQL Server without DDL tools.
What is this MCP server?
- Read plus data write operations on Microsoft SQL Server
- Explicitly excludes DDL—no CREATE/ALTER/DROP via this MCP package
- Node npm @connorbritain/mssql-mcp-writer (v0.3.1) with stdio MCP
- Middle ground between mssql-reader and full mssql for dev databases
- Supports agent-driven data fixes and fixture loading without structural changes
- Scope: read and data write operations; no DDL
- Package @connorbritain/mssql-mcp-writer version 0.3.1
- Transport: stdio
What problem does it solve?
You need agents to insert or update dev data but cannot trust them with schema DDL on the same connection.
Who is it for?
Solo builders seeding dev/staging SQL Server databases and fixing data issues with MCP without exposing migration DDL to the model.
Skip if: Schema migration workflows requiring CREATE/ALTER TABLE—use the full mssql MCP server instead.
What do I get? / Deliverables
After setup, agents query and apply data-level changes on SQL Server while DDL remains blocked, speeding fixtures and fixes in development.
- Agent-assisted read and write queries against SQL Server data
- Faster dev seeding and row-level corrections without DDL exposure
- Clear separation from full-schema MCP for safer agent defaults
Recommended MCP Servers
Journey fit
Backend Build tasks include seeding test data and correcting rows while schema changes stay human-gated. Backend covers application data layers where controlled INSERT/UPDATE/DELETE helps iteration but DDL should stay out of agent hands.
How it compares
Data-write SQL Server MCP without DDL, not a read-only analytics connector or full database admin suite.
Common Questions / FAQ
Who is io.github.ConnorBritain/mssql-writer for?
Developers on SQL Server who want MCP agents to read and modify rows in controlled environments but keep structural DDL out of scope.
When should I use io.github.ConnorBritain/mssql-writer?
Use it during Build for seed scripts, test data, and DML fixes on dev databases after schema is already defined elsewhere.
How do I add io.github.ConnorBritain/mssql-writer to my agent?
Install @connorbritain/mssql-mcp-writer from npm, add stdio MCP configuration, and use SQL credentials with DML rights but without DDL privileges.