Skip to content

History of Microsoft SQL Server

io.github.alyiox/mcp-mssql · Registry status: active

Report data on this entry

Every published change to this entry, most recent first.

Changes
2026-09-16Declared version: 1.5.0 → 1.6.1
2026-09-16Description (raw): Read-only-by-default SQL Server: execution plans, parameterized SELECT, metadata, opt-in writes. → Read-only-by-default SQL Server: schema, parameterized SELECT, execution plans; writes opt-in.
2026-09-16Last changed in the registry (raw): 2026-09-14 → 2026-09-15
2026-09-16First listed in the registry (raw): 2026-09-14 → 2026-09-15
2026-09-16Environment 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). 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). → 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).
2026-09-16Connection paths (source structure): {"packages":[{"registryType":"nuget","identifier":"Alyio.McpMssql","version":"1.5.0","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). 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":[]} → {"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":[]}
2026-09-16Package versions (raw): 1.5.0 → 1.6.1
2026-09-15Declared version: 1.3.0 → 1.5.0
2026-09-15Description (raw): Read-only MCP for Microsoft SQL Server: metadata discovery, parameterized SELECT, plans. → Read-only-by-default SQL Server: execution plans, parameterized SELECT, metadata, opt-in writes.
2026-09-15Last changed in the registry (raw): 2026-09-01 → 2026-09-14
2026-09-15First listed in the registry (raw): 2026-09-01 → 2026-09-14
2026-09-15Environment 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). 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). · 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). → 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). 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).
2026-09-15Connection paths (source structure): {"packages":[{"registryType":"nuget","identifier":"Alyio.McpMssql","version":"1.3.0","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).","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). 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":[]} → {"packages":[{"registryType":"nuget","identifier":"Alyio.McpMssql","version":"1.5.0","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). 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":[]}
2026-09-15Package versions (raw): 1.3.0 → 1.5.0
2026-09-08Connection paths (source structure): – → {"packages":[{"registryType":"nuget","identifier":"Alyio.McpMssql","version":"1.3.0","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).","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). 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":[]}
2026-09-02Declared version: 1.2.0 → 1.3.0
2026-09-02Last changed in the registry (raw): 2026-07-24 → 2026-09-01
2026-09-02First listed in the registry (raw): 2026-07-24 → 2026-09-01
2026-09-02Package versions (raw): 1.2.0 → 1.3.0
2026-08-26Field of use, derived from the vendor description: – → Databases
2026-08-26Description (raw): – → Read-only MCP for Microsoft SQL Server: metadata discovery, parameterized SELECT, plans.
2026-08-16Last changed in the registry (raw): – → 2026-07-24
2026-08-16First listed in the registry (raw): – → 2026-07-24
2026-08-16Registry status message (raw): – → –
2026-08-16Schema version of the raw record (raw): – → https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json
2026-08-16Icon formats (raw): – → –
2026-08-16Environment 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). 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). · 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).
2026-08-16Environment variable formats (raw): – → boolean, number, string
2026-08-16Delivery form (raw): – → package
2026-08-16Remote hosts (raw): – → –
2026-08-16Remote URLs (raw): – → –
2026-08-16Runtime hints (raw): – → dnx
2026-08-16Package versions (raw): – → 1.2.0
2026-08-16Package identifiers (raw): – → Alyio.McpMssql
2026-08-16Repository subfolder (raw): – → src/Alyio.McpMssql
2026-08-16Repository platform (raw): – → github
2026-08-16Path environment variables (raw): – → –
2026-08-16Required secret headers (raw): – → –
2026-08-06Declared version: – → 1.2.0
2026-08-06Repository URL listed: – → yes
2026-08-06Path argument present: – → no
2026-08-06Execution location: – → local
2026-08-06Required secrets declared: – → no
2026-08-06Package registries (raw): – → nuget
2026-08-06Repository (raw): – → https://github.com/alyiox/mcp-mssql
2026-08-06Path arguments (raw): – → –
2026-08-06Transports (raw): – → stdio
2026-08-06Required secret variables (raw): – → –
2026-08-06Environment 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

tracevero · https://tracevero.com/mcp/io-github-alyiox-mcp-mssql/aenderungen