Mssql Reader
io.github.ConnorBritain/mssql-reader is a MCP server that provides read-only Microsoft SQL Server schema discovery, profiling, and safe querying for coding agents.
About
io.github.ConnorBritain/mssql-reader is a read-only Model Context Protocol server for Microsoft SQL Server. developers often need agents to understand legacy schemas or production snapshots but cannot afford accidental UPDATEs or DROP statements; this package limits the tool surface to schema discovery, profiling, and safe SELECT-style work. Catalog it under Build / integrations because it is an agent-to-database wire, usable while you design endpoints, write reports, or debug customer issues in staging. It pairs naturally with Ship and Operate mindsets even though the canonical shelf stays Build: use reader MCP when connecting Cursor or Claude Code to shared databases, and switch to mssql-writer or full mssql only on isolated dev copies. Setup is npm-based with Node, SQL connection config outside the repo, and stdio in your MCP manifest. For Skillselion shoppers comparing ConnorBritain’s three packages, reader is the conservative default for curiosity and documentation, not schema migration.
- Read-only MCP surface: schema discovery, profiling, and safe querying only
- Reduces risk versus full mssql server when exploring production-like datasets
- Node package @connorbritain/mssql-mcp-reader (v0.3.1) with stdio transport
- Ideal companion for analytics, debugging, and API design sessions
- Same SQL Server focus as the writer/full variants without DDL or data mutation tools
Mssql Reader by the numbers
- Data as of Jul 7, 2026 (Skillselion catalog sync)
claude mcp add mssql-reader -- npx -y @connorbritain/mssql-mcp-readerAdd your badge
Show developers this MCP server is listed on Skillselion. Paste this into your README.
| Package | @connorbritain/mssql-mcp-reader |
|---|---|
| Transport | STDIO |
| Auth | None |
What it does
Safely let agents inspect Microsoft SQL Server with read-only MCP tools for schema discovery, profiling, and querying without DDL or destructive writes.
Who is it for?
Best when you're connecting agents to staging or read replicas, or anyone learning an unfamiliar MSSQL codebase before enabling write tools.
Skip if: Local dev where you need migrations, seed scripts, or INSERT/UPDATE via MCP—use mssql-writer or full mssql instead.
What you get
After install, agents explore schemas, profile columns, and run read-only queries so your SQL and API plans reflect real structure with lower mutation risk.
- Accurate schema and profile context for agent-generated SQL and docs
- Read-only query results for debugging and validation
- Lower-risk MCP footprint on shared database instances
By the numbers
- Read-only: schema discovery, profiling, safe querying (no DDL)
- Package @connorbritain/mssql-mcp-reader 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
Read-only database MCP connector, not a full admin SQL Server skill pack or ETL pipeline product.
FAQ
Who is io.github.ConnorBritain/mssql-reader for?
Developers and small teams who need MCP agents to explore SQL Server schemas and run safe read queries without write or DDL capabilities.
When should I use io.github.ConnorBritain/mssql-reader?
Use it when mapping an existing database, drafting queries for features, or debugging read paths before granting write or DDL MCP servers.
How do I add io.github.ConnorBritain/mssql-reader to my agent?
Install @connorbritain/mssql-mcp-reader via npm, configure stdio in your MCP client, and supply read-only SQL credentials with least privilege.