Server facts
jewei-mssql-mcp-server
Project
- Author
- jeweis
- Repository
- github.com/jeweis/jewei-mssql-mcp-server
- 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.