--- bezeichner: "io.github.alyiox/mcp-mssql" art: "mcp_server" slug: "io-github-alyiox-mcp-mssql" paketkoordinate: "nuget:Alyio.McpMssql" status: "aktiv" homepage: "https://github.com/alyiox/mcp-mssql" erhebungsstand: "2026-10-10T01:17:01.464Z" namensraum: "io.github.alyiox" registerseite: "https://tracevero.com/mcp/io-github-alyiox-mcp-mssql" abgerufen_am: "2026-10-10" zugangsdaten_erforderlich: false ausfuehrungsort: "lokal" dateisystem_pfadargument: false quelloffen_einsehbar: true einsatzgebiet: "datenbank" roh_beschreibung: "Read-only-by-default SQL Server: schema, parameterized SELECT, execution plans; writes opt-in." version: "1.6.1" roh_umgebungsvariablen: "MCPMSSQL_CONNECTION_STRING, MCPMSSQL_DESCRIPTION, MCPMSSQL_QUERY_MAX_ROWS, MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS, MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS, MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS, MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS, MCPMSSQL_ALLOW_WRITE, MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS, DOTNET_ENVIRONMENT" roh_geheime_pflichtvariablen: "" roh_transportarten: "stdio" roh_pfadargumente: "" roh_repository_url: "https://github.com/alyiox/mcp-mssql" roh_paketquellen: "nuget" roh_geheime_pflichtkopfzeilen: "" roh_pfad_umgebungsvariablen: "" roh_remote_adressen: "" roh_remote_hosts: "" roh_statusmeldung: "" roh_veroeffentlicht_am: "2026-09-15" roh_aktualisiert_am: "2026-09-15" roh_schemafassung: "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json" roh_bereitstellungsform: "paket" roh_repository_quelle: "github" roh_repository_unterordner: "src/Alyio.McpMssql" roh_paketbezeichner: "Alyio.McpMssql" roh_paketversionen: "1.6.1" roh_laufzeithinweise: "dnx" roh_umgebungsformate: "boolean, number, string" roh_umgebungsbeschreibungen: "DOTNET_ENVIRONMENT=Set to Development to load dotnet user-secrets (local dev). · 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_ANALYZE_COMMAND_TIMEOUT_SECONDS=Execution plan analysis timeout in seconds (default 300; ceiling 600). · MCPMSSQL_CONNECTION_STRING=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_COMMAND_TIMEOUT_SECONDS=Interactive query command timeout in seconds (default 30). · MCPMSSQL_QUERY_MAX_ROWS=Max rows per interactive query (default 500; ceiling 1000). · MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS=Snapshot query timeout in seconds (default 120). · MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS=Max rows for snapshot queries (default 10000; ceiling 50000). · MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS=Write command timeout in seconds (default 60; ceiling 600)." roh_symbolformate: "" roh_verbindungswege: "{\"packages\":[{\"registryType\":\"nuget\",\"identifier\":\"Alyio.McpMssql\",\"version\":\"1.6.1\",\"runtimeHint\":\"dnx\",\"transport\":\"stdio\",\"environment\":[{\"name\":\"MCPMSSQL_CONNECTION_STRING\",\"description\":\"Default profile SQL Server connection string (often contains secrets). Optional if profiles are only in user appsettings.\",\"format\":\"string\",\"required\":false,\"secret\":true},{\"name\":\"MCPMSSQL_DESCRIPTION\",\"description\":\"Optional human-readable description for the default profile.\",\"format\":\"string\",\"required\":false,\"secret\":false},{\"name\":\"MCPMSSQL_QUERY_MAX_ROWS\",\"description\":\"Max rows per interactive query (default 500; ceiling 1000).\",\"format\":\"number\",\"required\":false,\"secret\":false},{\"name\":\"MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS\",\"description\":\"Interactive query command timeout in seconds (default 30).\",\"format\":\"number\",\"required\":false,\"secret\":false},{\"name\":\"MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS\",\"description\":\"Max rows for snapshot queries (default 10000; ceiling 50000).\",\"format\":\"number\",\"required\":false,\"secret\":false},{\"name\":\"MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS\",\"description\":\"Snapshot query timeout in seconds (default 120).\",\"format\":\"number\",\"required\":false,\"secret\":false},{\"name\":\"MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS\",\"description\":\"Execution plan analysis timeout in seconds (default 300; ceiling 600).\",\"format\":\"number\",\"required\":false,\"secret\":false},{\"name\":\"MCPMSSQL_ALLOW_WRITE\",\"description\":\"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.\",\"format\":\"boolean\",\"required\":false,\"secret\":false},{\"name\":\"MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS\",\"description\":\"Write command timeout in seconds (default 60; ceiling 600).\",\"format\":\"number\",\"required\":false,\"secret\":false},{\"name\":\"DOTNET_ENVIRONMENT\",\"description\":\"Set to Development to load dotnet user-secrets (local dev).\",\"format\":\"string\",\"required\":false,\"secret\":false}],\"additional_arguments_declared\":false}],\"remotes\":[]}" --- # Microsoft SQL Server ## Measured values | Property | Value | Source | Collected on | Level of trust | Raw declaration | | --- | --- | --- | --- | --- | --- | | Required secrets declared | false | MCP-Register | 2026-08-06T13:57:41.838Z | abgeleitet | roh_geheime_pflichtvariablen: ; roh_geheime_pflichtkopfzeilen: | | Execution location | lokal | MCP-Register | 2026-08-06T13:57:41.838Z | abgeleitet | roh_transportarten: stdio | | Path argument present | false | MCP-Register | 2026-08-06T13:57:41.838Z | abgeleitet | roh_pfadargumente: ; roh_pfad_umgebungsvariablen: | | Repository URL listed | true | MCP-Register | 2026-08-06T13:57:41.838Z | abgeleitet | roh_repository_url: https://github.com/alyiox/mcp-mssql | | Field of use, derived from the vendor description | datenbank | MCP-Register | 2026-08-26T16:45:01.514Z | abgeleitet | roh_beschreibung: Read-only-by-default SQL Server: schema, parameterized SELECT, execution plans; writes opt-in. | | Description (raw) | Read-only-by-default SQL Server: schema, parameterized SELECT, execution plans; writes opt-in. | MCP-Register | 2026-09-16T01:17:01.931Z | selbstauskunft | | | Declared version | 1.6.1 | MCP-Register | 2026-09-16T01:17:01.931Z | selbstauskunft | | | Environment variables (raw) | MCPMSSQL_CONNECTION_STRING, MCPMSSQL_DESCRIPTION, MCPMSSQL_QUERY_MAX_ROWS, MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS, MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS, MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS, MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS, MCPMSSQL_ALLOW_WRITE, MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS, DOTNET_ENVIRONMENT | MCP-Register | 2026-08-06T13:57:41.838Z | selbstauskunft | | | Required secret variables (raw) | | MCP-Register | 2026-08-06T13:57:41.838Z | selbstauskunft | | | Transports (raw) | stdio | MCP-Register | 2026-08-06T13:57:41.838Z | selbstauskunft | | | Path arguments (raw) | | MCP-Register | 2026-08-06T13:57:41.838Z | selbstauskunft | | | Repository (raw) | https://github.com/alyiox/mcp-mssql | MCP-Register | 2026-08-06T13:57:41.838Z | selbstauskunft | | | Package registries (raw) | nuget | MCP-Register | 2026-08-06T13:57:41.838Z | selbstauskunft | | | Required secret headers (raw) | | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Path environment variables (raw) | | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Remote URLs (raw) | | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Remote hosts (raw) | | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Registry status message (raw) | | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | First listed in the registry (raw) | 2026-09-15 | MCP-Register | 2026-09-16T01:17:01.931Z | selbstauskunft | | | Last changed in the registry (raw) | 2026-09-15 | MCP-Register | 2026-09-16T01:17:01.931Z | selbstauskunft | | | Schema version of the raw record (raw) | https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Delivery form (raw) | paket | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Repository platform (raw) | github | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Repository subfolder (raw) | src/Alyio.McpMssql | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Package identifiers (raw) | Alyio.McpMssql | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Package versions (raw) | 1.6.1 | MCP-Register | 2026-09-16T01:17:01.931Z | selbstauskunft | | | Runtime hints (raw) | dnx | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Environment variable formats (raw) | boolean, number, string | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Environment variable descriptions (raw) | DOTNET_ENVIRONMENT=Set to Development to load dotnet user-secrets (local dev). · 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_ANALYZE_COMMAND_TIMEOUT_SECONDS=Execution plan analysis timeout in seconds (default 300; ceiling 600). · MCPMSSQL_CONNECTION_STRING=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_COMMAND_TIMEOUT_SECONDS=Interactive query command timeout in seconds (default 30). · MCPMSSQL_QUERY_MAX_ROWS=Max rows per interactive query (default 500; ceiling 1000). · MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS=Snapshot query timeout in seconds (default 120). · MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS=Max rows for snapshot queries (default 10000; ceiling 50000). · MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS=Write command timeout in seconds (default 60; ceiling 600). | MCP-Register | 2026-09-16T01:17:01.931Z | selbstauskunft | | | Icon formats (raw) | | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Connection paths (source structure) | {"packages":[{"registryType":"nuget","identifier":"Alyio.McpMssql","version":"1.6.1","runtimeHint":"dnx","transport":"stdio","environment":[{"name":"MCPMSSQL_CONNECTION_STRING","description":"Default profile SQL Server connection string (often contains secrets). Optional if profiles are only in user appsettings.","format":"string","required":false,"secret":true},{"name":"MCPMSSQL_DESCRIPTION","description":"Optional human-readable description for the default profile.","format":"string","required":false,"secret":false},{"name":"MCPMSSQL_QUERY_MAX_ROWS","description":"Max rows per interactive query (default 500; ceiling 1000).","format":"number","required":false,"secret":false},{"name":"MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS","description":"Interactive query command timeout in seconds (default 30).","format":"number","required":false,"secret":false},{"name":"MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS","description":"Max rows for snapshot queries (default 10000; ceiling 50000).","format":"number","required":false,"secret":false},{"name":"MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS","description":"Snapshot query timeout in seconds (default 120).","format":"number","required":false,"secret":false},{"name":"MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS","description":"Execution plan analysis timeout in seconds (default 300; ceiling 600).","format":"number","required":false,"secret":false},{"name":"MCPMSSQL_ALLOW_WRITE","description":"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.","format":"boolean","required":false,"secret":false},{"name":"MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS","description":"Write command timeout in seconds (default 60; ceiling 600).","format":"number","required":false,"secret":false},{"name":"DOTNET_ENVIRONMENT","description":"Set to Development to load dotnet user-secrets (local dev).","format":"string","required":false,"secret":false}],"additional_arguments_declared":false}],"remotes":[]} | MCP-Register | 2026-09-16T01:17:01.931Z | selbstauskunft | | ## Links - Namespace: [[namensraum/io-github-alyiox|io.github.alyiox]] --- - Registry page: - Retrieved on: 2026-10-10