SQL-Server-MCP
About
## SQL Server MCP (Model Context Protocol) Server A lightweight MCP stdio server that connects to Microsoft SQL Server using provided credentials and exposes tools to query and discover schema. ### Features - **connect**: Connect by `server`, `port`, `user`, `password`, optional `database`, `encrypt`. -…
Explore
- connect: Connect by server, port, user, password, optional database, encrypt.
- disconnect: Close the pool.
- info: Return @@VERSION.
- query: Execute arbitrary SQL and return recordset.
- list_databases: List databases.
- list_schemas: List schemas.
- list_tables: List tables, with optional schema filter.
- Node.js >= 18
- Install deps and build:
npm install
npm run build
- Run as an MCP stdio server (for MCP-compatible clients):
npm start
The server starts over stdio and waits to be driven by an MCP client (e.g., Claude Desktop or other MCP-aware tooling). Use the tools in this order:
1) connect with your SQL Server credentials
2) info, list_*, or query
- connect args:
{
"server": "host or host\\\u005Cinstance",
"port": 1433,
"user": "sa",
"password": "<secret>",
"database": "master",
"encrypt": true
}
- query args:
{ "sql": "SELECT TOP 1 FROM sys.databases" }
{ "sql": "SELECT FROM INFORMATION_SCHEMA.TABLES" }
- Other tools take no args or optional
schema.A lightweight MCP stdio server that connects to Microsoft SQL Server using provided credentials and exposes tools to query and discover schema.
Features
- connect: Connect byserver, port, user, password, optional database, encrypt.
- disconnect: Close the pool.
- info: Return @@VERSION.
- query: Execute arbitrary SQL and return recordset.
- list_databases: List databases.
- list_schemas: List schemas.
- list_tables: List tables, with optional schema filter.
Quickstart
- Node.js >= 18 - Install deps and build: npm install
npm run build
npm start
The server starts over stdio and waits to be driven by an MCP client (e.g., Claude Desktop or other MCP-aware tooling). Use the tools in this order:
1) connect with your SQL Server credentials
2) info, list_, or query
MCP Tools and Schemas
- connect args: {
"server": "host or host\\\u005Cinstance",
"port": 1433,
"user": "sa",
"password": "<secret>",
"database": "master",
"encrypt": true
}
{ "sql": "SELECT TOP 1 FROM sys.databases" }
{ "sql": "SELECT FROM INFORMATION_SCHEMA.TABLES" }
schema.
Security
- Credentials are provided at call-time and are not stored. Prefer secure MCP clients and environments. TLSencrypt defaults to true.
Development
- Scripts: -npm run dev to run with ts-node
- npm run build to emit JS to dist/
- npm start to run built server (dist/server.js)
Commits
- chore: init project scaffolding with TypeScript, tsconfig, and deps - feat: implement MCP stdio server with SQL Server tools (connect, query, info, list_) - docs: add execution plan outline and usage notesLicense
MITSign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
