jewei-mssql-mcp-server

Jewei Mssql MCP Server

Microsoft SQL Server data and table metadata are available through jewei-mssql-mcp-server for developers using MCP clients. Its tools list tables, inspect their structure, and run SELECT queries with structured results.

Server facts

jewei-mssql-mcp-server

Project

Author
jeweis
License
Not specified
Category
Databases

Tech

Runtime / language
Not specified
Transports
stdio
Remote available
No
Authentication
Not specified

Activity

GitHub stars
7
Last commit
Data as of

Tags

  • database
  • mssql
  • sqlserver

Overview

Microsoft SQL Server exploration in jewei-mssql-mcp-server centers on finding tables, inspecting their definitions, and retrieving data. The list_tables tool returns table information and a count for a chosen schema, with dbo as the default. For a specific table, get_table_structure exposes column details alongside primary keys, foreign keys, and indexes; it also defaults to dbo when no schema is supplied. These tools support a workflow in which a developer examines the available tables and their structure before composing a query.

Data retrieval uses query_sql, which accepts SELECT statements only and returns column names, row data, and the result row count. Its documented scope is querying rather than changing database contents. The server communicates over stdio, and the configuration examples cover Windsurf, Cursor, Claude, and Cline. Connection settings are supplied through environment variables for the database host, user, password, name, and port. The Cline guidance calls for adapting the example to that client's configuration format, rather than treating the sample as a universal configuration.

jewei-mssql-mcp-server setup notes

  • jewei-mssql-mcp-server records stdio only; confirm a network transport upstream before planning remote access.
  • jewei-mssql-mcp-server has no recorded license; confirm reuse terms in its repository.

Related MCP servers