--- 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.de/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 ## Gemessene Werte | Merkmal | Wert | Quelle | Erhoben am | Vertrauensgrad | Rohangabe | | --- | --- | --- | --- | --- | --- | | Pflicht-Geheimnisse deklariert | false | MCP-Register | 2026-08-06T13:57:41.838Z | abgeleitet | roh_geheime_pflichtvariablen: ; roh_geheime_pflichtkopfzeilen: | | Ausführungsort | lokal | MCP-Register | 2026-08-06T13:57:41.838Z | abgeleitet | roh_transportarten: stdio | | Pfadargument vorhanden | false | MCP-Register | 2026-08-06T13:57:41.838Z | abgeleitet | roh_pfadargumente: ; roh_pfad_umgebungsvariablen: | | Repository-Adresse geführt | true | MCP-Register | 2026-08-06T13:57:41.838Z | abgeleitet | roh_repository_url: https://github.com/alyiox/mcp-mssql | | Einsatzgebiet, aus der Anbieterbeschreibung abgeleitet | 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. | | Beschreibung (Rohangabe) | Read-only-by-default SQL Server: schema, parameterized SELECT, execution plans; writes opt-in. | MCP-Register | 2026-09-16T01:17:01.931Z | selbstauskunft | | | Deklarierte Version | 1.6.1 | MCP-Register | 2026-09-16T01:17:01.931Z | selbstauskunft | | | Umgebungsvariablen (Rohangabe) | 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 | | | Geheime Pflichtvariablen (Rohangabe) | | MCP-Register | 2026-08-06T13:57:41.838Z | selbstauskunft | | | Transportarten (Rohangabe) | stdio | MCP-Register | 2026-08-06T13:57:41.838Z | selbstauskunft | | | Pfadargumente (Rohangabe) | | MCP-Register | 2026-08-06T13:57:41.838Z | selbstauskunft | | | Repository (Rohangabe) | https://github.com/alyiox/mcp-mssql | MCP-Register | 2026-08-06T13:57:41.838Z | selbstauskunft | | | Paketquellen (Rohangabe) | nuget | MCP-Register | 2026-08-06T13:57:41.838Z | selbstauskunft | | | Geheime Pflichtkopfzeilen (Rohangabe) | | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Pfad-Umgebungsvariablen (Rohangabe) | | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Remote-Adressen (Rohangabe) | | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Remote-Hosts (Rohangabe) | | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Statusmeldung des Registers (Rohangabe) | | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Im Register eingetragen am (Rohangabe) | 2026-09-15 | MCP-Register | 2026-09-16T01:17:01.931Z | selbstauskunft | | | Im Register geändert am (Rohangabe) | 2026-09-15 | MCP-Register | 2026-09-16T01:17:01.931Z | selbstauskunft | | | Schemafassung des Rohsatzes (Rohangabe) | https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Bereitstellungsform (Rohangabe) | paket | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Repository-Plattform (Rohangabe) | github | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Repository-Unterordner (Rohangabe) | src/Alyio.McpMssql | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Paketbezeichner (Rohangabe) | Alyio.McpMssql | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Paketversionen (Rohangabe) | 1.6.1 | MCP-Register | 2026-09-16T01:17:01.931Z | selbstauskunft | | | Laufzeithinweise (Rohangabe) | dnx | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Formate der Umgebungsvariablen (Rohangabe) | boolean, number, string | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Beschreibungen der Umgebungsvariablen (Rohangabe) | 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 | | | Symbolformate (Rohangabe) | | MCP-Register | 2026-08-16T01:17:01.420Z | selbstauskunft | | | Verbindungswege (Quellstruktur) | {"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 | | ## Verweise - Namensraum: [[namensraum/io-github-alyiox|io.github.alyiox]] --- - Registerseite: - Abgerufen am: 2026-10-10