Microsoft SQL Server
Local package path declaredNo credentials listedRepository declared by sourceUpdated 2026-09-15
io.github.alyiox/mcp-mssql · Registry status: active
At a glance
Read-only-by-default SQL Server: schema, parameterized SELECT, execution plans; writes opt-in.
Vendor's own description, untranslated and unverified
- Execution location
- Local package path declaredMCP-Register · 2026-08-06
- Required secrets declared
- No credentials listedMCP-Register · 2026-08-06
- Declared version and change
1.6.1· Source-reported change date 2026-09-15MCP-Register · 2026-09-16- Repository as declared
- github.com/alyiox/mcp-mssqlMCP-Register · 2026-08-06
- Configuration
- cannot be built: no disclosed start template
Inspect connection paths and prerequisites
Related categories
- MCP servers for databases338
- MCP servers without declared required secrets35,800
- Locally executed MCP servers17,056
- MCP servers with a repository URL30,107
- Local MCP servers without declared required secrets13,238
- Local MCP servers with a repository URL16,152
6 of 9 categories. All categories in the segment catalogue
Page last changed:
Sources and collection
- Runs
- Local package path declared
- Credentials
- No credentials listed
- Registry record changed
- 2026-09-15
- Setup
- No template in the registry
- Registry name
io.github.alyiox/mcp-mssql- Package coordinate
nuget:Alyio.McpMssql- Declared version
1.6.1- Source-reported listing date
- 2026-09-15
- Source-reported change date
- 2026-09-15
- First seen by tracevero
- 2026-08-06
- Vendor's website
- https://github.com/alyiox/mcp-mssql
Evidence for this page: The values on this page come from several collections. Each row therefore states its own origin. What the confidence levels mean
Measured values
| Required secrets declared | No credentials listed no Original data – Required secret variables (raw): confirmed absent Original data – Required secret headers (raw): confirmed absent Source: MCP-Register · collected on 2026-08-06 · derived |
|---|---|
| Execution location | Local package path declared local Original data – Transports (raw): stdio Source: MCP-Register · collected on 2026-08-06 · derived |
| Path argument present | no Original data – Path arguments (raw): confirmed absent Original data – Path environment variables (raw): confirmed absent Source: MCP-Register · collected on 2026-08-06 · derived |
| Repository URL listed | Repository declared by source yes Original data – Repository (raw): https://github.com/alyiox/mcp-mssql Source: MCP-Register · collected on 2026-08-06 · derived |
| Field of use, derived from the vendor description | Databases Original data – Description (raw): Read-only-by-default SQL Server: schema, parameterized SELECT, execution plans; writes opt-in. Source: MCP-Register · collected on 2026-08-26 · derived |
| Declared version | 1.6.1 Source: MCP-Register · collected on 2026-09-16 · self-declared |
What is measured is what a manifest declares, not what a piece of software does. This registry fetches no repository URL, no endpoint and no package index; nothing here is verified. Which value comes from which source, and by which rule it was formed, is set out in the Methodology.
Source data25
Evidence for this page: The values on this page come from several collections. Each row therefore states its own origin.
| Description (raw) | Read-only-by-default SQL Server: schema, parameterized SELECT, execution plans; writes opt-in. Source: MCP-Register · collected on 2026-09-16 · self-declared |
|---|---|
| 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 Source: MCP-Register · collected on 2026-08-06 · self-declared |
| Required secret variables (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-06 · self-declared |
| Transports (raw) | stdio Source: MCP-Register · collected on 2026-08-06 · self-declared |
| Path arguments (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-06 · self-declared |
| Repository (raw) | https://github.com/alyiox/mcp-mssql Source: MCP-Register · collected on 2026-08-06 · self-declared |
| Package registries (raw) | nuget Source: MCP-Register · collected on 2026-08-06 · self-declared |
| Required secret headers (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Path environment variables (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Remote URLs (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Remote hosts (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Registry status message (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-16 · self-declared |
| First listed in the registry (raw) | 2026-09-15 Source: MCP-Register · collected on 2026-09-16 · self-declared |
| Last changed in the registry (raw) | 2026-09-15 Source: MCP-Register · collected on 2026-09-16 · self-declared |
| Schema version of the raw record (raw) | https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Delivery form (raw) | package Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Repository platform (raw) | github Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Repository subfolder (raw) | src/Alyio.McpMssql Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Package identifiers (raw) | Alyio.McpMssql Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Package versions (raw) | 1.6.1 Source: MCP-Register · collected on 2026-09-16 · self-declared |
| Runtime hints (raw) | dnx Source: MCP-Register · collected on 2026-08-16 · self-declared |
| Environment variable formats (raw) | boolean, number, string Source: MCP-Register · collected on 2026-08-16 · self-declared |
| 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). Source: MCP-Register · collected on 2026-09-16 · self-declared |
| Icon formats (raw) | confirmed absent Source: MCP-Register · collected on 2026-08-16 · self-declared |
| 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":[]} Source: MCP-Register · collected on 2026-09-16 · self-declared |
Embed this badge
Paste this line into a README of your own. The badge states how many values the registry holds for the entry and when it last looked, and it links back to this page.
[](https://tracevero.com/mcp/io-github-alyiox-mcp-mssql)
The image is drawn again on every request, so it always reports the current state while the pasted line stays as it is. It carries no rating and no traffic light – only the two measured figures.
Changes
| 2026-09-16 | Declared version: 1.5.0 → 1.6.1 |
|---|---|
| 2026-09-16 | Description (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-16 | Last changed in the registry (raw): 2026-09-14 → 2026-09-15 |
These are the 3 most recent changes to this entry. Full history
tracevero · https://tracevero.com/mcp/io-github-alyiox-mcp-mssql