cyberneticlibrary
← library

Query and manage SQL Server databases

mssql-mcpmcp_serversetup L2★0
BYMCS/mssql-mcp ↗
What it does

Execute SQL queries and manage SQL Server databases via MCP

Best for

Enterprise agents working with SQL Server data pipelines where direct database access is safer than APIs.

Inputs
  • · SQL query (SELECT, INSERT, UPDATE, DELETE, DDL)
  • · database name
  • · connection string or parameters
Outputs
  • · query result rows as JSON
  • · affected row count
  • · execution time and plan info
Requires
  • · SQL Server 2019+ (on-premises or Azure SQL)
  • · mssql npm package (tedious driver)
Preconditions
  • · SQL Server instance running and accessible
  • · SQL Server port open (default 1433)
  • · Valid SQL auth (user/pass) or Windows auth
Failure modes
  • · SQL injection if query not parameterized (mitigation: use prepared statements)
  • · Large result sets cause timeout
  • · Transaction deadlocks if concurrent agents query same tables
  • · Secrets exposure if query logs included in output
Trust signals
  • · npm package @mssql/mcp-server published
  • · MIT license
  • · Support for Claude Desktop, Cursor, Windsurf, VS Code
  • · MCP draft/latest spec alignment