Skip to main content
Glama
Sign In
MSSQL MCP Reader

MSSQL MCP Reader

by ConnorBritain
OverviewSchemaSourceRelated ServersDiscussionsAdmin
JavaScript
Remote

MSSQL MCP Reader

npm version License: MIT

Read-only Model Context Protocol server for Microsoft SQL Server.

Safe schema discovery, profiling, and querying with zero risk of data modification. Ideal for analysts, auditors, and anyone who needs database exploration without write access.

Architecture

This package is a thin wrapper around @connorbritain/mssql-mcp-core, which contains all shared logic, tools, and governance features. The wrapper selects the "reader" tier and delegates to the core's startMcpServer() function. This design enables:

  • Hard separation at the package level — regulated enterprises can guarantee that certain builds physically cannot perform destructive operations

  • Independent versioning — each tier can be published separately with its own release cycle

  • Clear audit trail — "we only allow mssql-mcp-reader in prod" is a compile-time guarantee

The core library handles all SQL Server connections, tool dispatch, audit logging, and governance enforcement.

Related MCP server: mcp-sqlserver-readonly

Package Tiers

Package

npm

Tools

Use Case

mssql-mcp-reader (this)

@connorbritain/mssql-mcp-reader

14 read-only

Analysts, auditors, safe exploration

mssql-mcp-writer

@connorbritain/mssql-mcp-writer

17 (reader + data ops)

Data engineers, ETL developers

mssql-mcp-server

@connorbritain/mssql-mcp-server

20 (all tools)

DBAs, full admin access

Config Builder — Visual wizard to generate your mcp_config.json and environments.json files.

Tools Included

Category

Tools

Discovery

search_schema, describe_table, list_table, list_databases, list_environments

Profiling

profile_table, inspect_relationships, inspect_dependencies, explain_query

Querying

read_data (SELECT only)

Scripts

list_scripts, run_script (readonly scripts only)

Operations

test_connection, validate_environment_config

Not included: insert_data, update_data, delete_data, create_table, create_index, drop_table

Quick Start

Install

npm install -g @connorbritain/mssql-mcp-reader@latest

MCP Client Configuration

{
  "mcpServers": {
    "mssql": {
      "command": "npx",
      "args": ["@connorbritain/mssql-mcp-reader@latest"],
      "env": {
        "SERVER_NAME": "127.0.0.1",
        "DATABASE_NAME": "mydb",
        "SQL_AUTH_MODE": "sql",
        "SQL_USERNAME": "readonly_user",
        "SQL_PASSWORD": "YourPassword123"
      }
    }
  }
}

Configuration

Variable

Required

Notes

SERVER_NAME

Yes

SQL Server hostname/IP

DATABASE_NAME

Yes

Target database

SQL_AUTH_MODE

sql, windows, or aad (default: aad)

SQL_USERNAME / SQL_PASSWORD

Required for sql/windows modes

ENVIRONMENTS_CONFIG_PATH

Path to multi-environment JSON config

SCRIPTS_PATH

Path to named SQL scripts directory

AUDIT_LOG_PATH

Custom audit log path

Features

All packages in the MSSQL MCP family share:

  • Multi-environment support - Named database environments (prod, staging, dev) with per-environment policies

  • Governance controls - allowedTools, deniedTools, allowedSchemas, deniedSchemas, requireApproval

  • Audit logging - JSON Lines logs with session IDs and auto-redaction

  • Secret management - ${secret:NAME} placeholders for secure credential handling

  • Named SQL scripts - Pre-approved parameterized queries with governance controls

Documentation

Full documentation, configuration examples, and governance details are available in the main repository:

MSSQL MCP Server Documentation

License

MIT License. See LICENSE for details.

Repository: https://github.com/ConnorBritain/mssql-mcp-reader Issues: https://github.com/ConnorBritain/mssql-mcp-reader/issues npm: https://www.npmjs.com/package/@connorbritain/mssql-mcp-reader

Available Tools

14 tools
describe_tableB

Describes the schema (columns and types) of a specified MSSQL Database table. For server-level access environments, you can specify a database to target.

Inputs: tableName (required), database, environment.

explain_queryA

Generates an estimated execution plan (SHOWPLAN_XML) for a SQL query without executing it.

Inputs: query (required), environment, includePlanXml.

inspect_dependenciesA

Shows what database objects depend on a table, view, or other object. Use for impact analysis before schema changes.

Inputs: objectName (required), includeColumns, environment.

inspect_relationshipsA

Describes inbound and outbound foreign-key relationships for a given table, including column mappings and referential actions.

Inputs: tableName (required), schemaName, includeOutbound, includeInbound, +1 more.

list_databasesA

Lists databases on the SQL Server instance. Requires server-level access. Filtered by environment policies.

Inputs: environment, includeSystemDbs, stateFilter.

list_environmentsA

Lists all configured database environments available for connection. Shows environment names, descriptions, access levels, and policy restrictions. Use this to discover which environments are available before running queries.

Inputs: includeDetails.

list_scriptsB

Lists available named SQL scripts. Scripts are pre-approved SQL templates that can be executed with parameters.

Inputs: environment, tier.

list_tablesA

Lists tables in an MSSQL Database, optionally filtered by schema. For server-level access environments, you can specify a database to list tables from.

Inputs: database, schemas, environment.

profile_tableA

Profiles a table by analyzing column statistics, data distributions, and sample records. Returns metadata, cardinality info, null counts, and representative samples for each column.

Inputs: tableName (required), schemaName, sampleSize, includeSamples, +4 more.

read_dataA

Executes a read-only SELECT query. Auto-limits results if no TOP clause present. Blocks destructive operations.

Inputs: query (required), database, maxRows, environment.

run_scriptA

Executes a named SQL script with parameters. Scripts are pre-approved SQL templates. Use list_scripts to see available scripts.

Inputs: scriptName (required), parameters, preview, confirm, +1 more.

search_schemaC

Searches tables and columns using wildcard patterns to discover schema names.

Inputs: tablePattern, columnPattern, limit, tableLimit, +4 more.

test_connectionC

Tests connectivity to a database environment and returns status, latency, and basic server info.

Inputs: environment, verbose.

validate_environment_configA

Validates the environments.json configuration file for correctness and security best practices.

Checks include:

  • Required fields (name, server, database for database-level; name, server for server-level)

  • Valid authentication mode configuration

  • Policy consistency (e.g., readonly + allowedTools including write tools)

  • Secret placeholder syntax

  • Access level configuration validity

  • Tier designation consistency

Returns validation results for each environment with errors and warnings.

Inputs: environment.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    Deploy Server
    Claude Code, inside the Godot 4 editorFlockbay puts an AI agent in the real Godot 4 editor: it writes GDScript, runs your game and fixes what breaks. Free, or bring your own Claude Code or Codex.flockbay.comAd

    TDQS

    A3.7/5.0

    Scored across 14 tools

    Disambiguation5/5

    Each tool targets a distinct database operation or analysis aspect. Even closely related tools like profile_table and describe_table serve different purposes (schema vs. statistics). There is no ambiguity between tools.

    Naming Consistency5/5

    All tool names follow a consistent verb_noun pattern with lowercase underscores. Verbs are clear and descriptive (list, describe, explain, inspect, profile, etc.), making it easy to predict functionality.

    Tool Count5/5

    With 14 tools, the server covers a broad but focused range of database read and analysis operations without being overwhelming or sparse. This count is well-suited for a specialized database reader server.

    Completeness4/5

    The tool set covers schema discovery, data querying, dependency analysis, and configuration management. However, it lacks tools for listing other database objects like views, stored procedures, or indexes, which may be needed for thorough analysis.

    Maintenance

    ActivityInactive
    ResponsivenessLimited data

    Resources

    Related MCP Connectors

    Related MCP Servers

    • MSSQL MCP Server

      mortada7-11
      F
      license
      Not graded
      quality
      D
      maintenance
      A Model Context Protocol server that exposes SQL Server metadata and read-only query execution as a structured HTTP API, with safety validation and allowlist policy enforcement.
      1
      -

    • mcp-sqlserver-readonly

      gbfeliped
      A
      license
      Not graded
      quality
      D
      maintenance
      Read-only SQL Server MCP server enabling safe database queries, table listing, and schema inspection with built-in security protections.
      MIT

    • mssql-mcp-reader

      Store-next
      A
      license
      Not graded
      quality
      D
      maintenance
      Read-only Model Context Protocol server for Microsoft SQL Server. Enables safe schema discovery, profiling, and querying with zero risk of data modification.
      4 npm
      MIT

    • mcp-mssql-secure

      pugltd
      A
      license
      B
      quality
      D
      maintenance
      A Model Context Protocol server for Microsoft SQL Server and Azure SQL Database with permission-based access modes (read-only, DML, full) and security features like SQL classification and connection locking.
      7
      16 npm
      MIT