Important: This documentation covers Yarn 1 (Classic).
For Yarn 2+ docs and migration guide, see yarnpkg.com.

Package detail

simple-mcp-mssql

CdTgr64MIT0.1.4TypeScript support: included

Lightweight CLI and SDK for using Model Context Protocol (MCP) with MSSQL databases

mcp, model context protocol, mssql, sql server, mssql orm, mssql model, entity modeling, database abstraction, sql abstraction, data context, typescript, nodejs, orm, mssql handler, data layer, contextual data model

readme

🧩 Simple MCP Server for MSSQL

A lightweight command-line tool for connecting to and querying Microsoft SQL Server (MSSQL) using the Model Context Protocol (MCP).

Use this tool to bridge your AI or context-aware systems with MSSQL databases quickly and securely.

🙌 Contributions are welcome!

🚀 Installation

Install globally via npm:

npm i -g simple-mcp-mssql

🛠️ Usage & Debugging

To inspect and debug your MCP server connection, use the official MCP Inspector:

npx @modelcontextprotocol/inspector simple-mcp-mssql \
  --password '<your-password>' \
  -d '<default-database>'

📘 Available Options

You can view all CLI options by running:

simple-mcp-mssql --help
Option Alias Type Required Description Default
--host -h string No Database host address localhost
--port -p number No Database port 1433
--user -u string No Username for authentication sa
--password -P string Yes Password for the database user (none)
--database -d string Yes Default database to connect to (none)

💬 Feedback & Contributions

If you encounter issues, have suggestions, or want to contribute, feel free to open an issue or pull request.

📄 License

MIT © 2025 GhosT