Home › Databases & Data › Microsoft SQL Server
Microsoft SQL Server
MCP server for SQL Server metadata, parameterized queries, plan analysis, and writes opt-in.
Connect
Review any command before running it. Package names and URLs come from the server's own registry entry.
Package (nuget 1.8.0)
Package: nuget Alyio.McpMssql
MCPMSSQL_CONNECTION_STRINGsecret — Default profile SQL Server connection string (often contains secrets). Optional if profiles are only in user appsettings.MCPMSSQL_DESCRIPTION— Optional human-readable description for the default profile.MCPMSSQL_QUERY_MAX_ROWS— Max rows per interactive query (default 500; ceiling 1000).MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS— Interactive query command timeout in seconds (default 30).MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS— Max rows for snapshot queries (default 10000; ceiling 50000).MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS— Snapshot query timeout in seconds (default 120).MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS— Execution plan analysis timeout in seconds (default 300; ceiling 600).MCPMSSQL_ALLOW_WRITE— Enable write commands (DDL/DML) via run_command on the default profile (default false). With no write-enabled profile the tool is not advertised at all. Soft guard only β prefer a db_datareader login for a hard read-only guarantee.MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS— Write command timeout in seconds (default 60; ceiling 600).DOTNET_ENVIRONMENT— Set to Development to load dotnet user-secrets (local dev).
Related servers
metabase/metabase
Lets AI clients search, explore, query, and visualize data in a Metabase instance.
context-mode
Free, local plugin that keeps tool output out of your coding agent's context window. Sandbox and SQLite FTS5 search, 99% fewer bytes inβ¦
dbx
Query databases from AI agents using connections configured in DBX.
MCP Toolbox for Databases
MCP Toolbox for Databases enables your agent to connect to your database.
convex-backend
Convex database integration to introspect tables and functions and run one-off queries.
instant
Create, manage, and update applications on InstantDB, the modern Firebase.
Data from the Official MCP Registry