Skip to main content
Glama
gbfeliped

mcp-sqlserver-readonly

by gbfeliped
OverviewSchemaRelated ServersScoreDiscussions
TypeScript
Remote

mcp-sqlserver

Read-only SQL Server MCP server for Claude Desktop (and any MCP-compatible client).

Tools exposed

Tool

Description

query

Run a SELECT query

list_tables

List all user tables with row-count estimate and size

describe_table

Show columns, types, nullability, PK for a table

list_schemas

List user-defined schemas

Related MCP server: mssql-mcp

Security protections

Attack

Example

Status

Direct writes

DROP, DELETE, UPDATE, INSERT

✅ Blocked

Multiple statements

SELECT 1; DROP TABLE t

✅ Blocked

System procedures

xp_cmdshell, EXEC sp_help

✅ Blocked

DoS

WAITFOR DELAY '0:0:5'

✅ Blocked

Whitespace bypass

tabs and newlines between keywords

✅ Blocked

Comment bypass

/* */ and -- before keywords

✅ Blocked

Valid queries

SELECT, SELECT TOP, COUNT, WHERE

✅ Allowed

Environment variables

Variable

Required

Default

Description

MSSQL_SERVER

✅

—

Server hostname or IP

MSSQL_DATABASE

✅

—

Database name

MSSQL_USER

✅

—

SQL login username

MSSQL_PASSWORD

✅

—

SQL login password

MSSQL_PORT

1433

TCP port

MSSQL_ENCRYPT

true

Enable TLS (true/false)

MSSQL_TRUST_SERVER_CERTIFICATE

false

Trust self-signed certs

Build

npm install
npm run build

Claude Desktop configuration

Add to %APPDATA%\Claude\claude_desktop_config.json:

{
  "mcpServers": {
    "sqlserver": {
      "command": "node",
      "args": ["C:/Users/gabri/OneDrive/Documentos/mcp-sqlserver/dist/index.js"],
      "env": {
        "MSSQL_SERVER": "localhost",
        "MSSQL_DATABASE": "MyDatabase",
        "MSSQL_USER": "sa",
        "MSSQL_PASSWORD": "YourPassword",
        "MSSQL_TRUST_SERVER_CERTIFICATE": "true"
      }
    }
  }
}

This server cannot be installed

A
license - permissive license
-
quality - not tested
C
maintenance

How are these scores calculated?

Maintenance

–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/gbfeliped/mcp-sqlserver-readonly'

If you have feedback or need assistance with the MCP directory API, please join our Discord server