Mssql Writer
io.github.ConnorBritain/mssql-writer is a MCP server that enables read and data-write operations on Microsoft SQL Server without DDL tools.
About
io.github.ConnorBritain/mssql-writer is a Model Context Protocol server for Microsoft SQL Server that combines read access with data write operations while omitting DDL. Developers often want agents to load seed data, backfill columns, or clean bad rows during Build, but a single mistaken ALTER TABLE can wreck a sprint; writer MCP scopes mutations to data only. Place it on Build / backend alongside your API and ORM work, using dev or disposable databases. It is narrower than io.github.ConnorBritain/mssql, which adds DDL for migration-heavy workflows, and broader than mssql-reader, which is inspection-only. Configure @connorbritain/mssql-mcp-writer through npm and stdio in Claude Code or Cursor, with credentials that can write data but not alter schema. Still review agent-generated DML before running against anything valuable, and keep reader MCP for production analytics. This is a task integration for SQL Server-backed SaaS and internal tools, not a replacement for migration frameworks.
- 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
Mssql Writer by the numbers
- Data as of Jul 7, 2026 (Skillselion catalog sync)
claude mcp add mssql-writer -- npx -y @connorbritain/mssql-mcp-writerAdd your badge
Show developers this MCP server is listed on Skillselion. Paste this into your README.
| Package | @connorbritain/mssql-mcp-writer |
|---|---|
| Transport | STDIO |
| Auth | None |
What it does
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.
Who is it for?
Best when you're 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 you get
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
By the numbers
- Scope: read and data write operations; no DDL
- Package @connorbritain/mssql-mcp-writer version 0.3.1
- 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
Data-write SQL Server MCP without DDL, not a read-only analytics connector or full database admin suite.
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.