SqlServerMcp MCP server
An MCP server for SQL Server that allows AI agents to inspect database schemas, perform safe read-only queries, and analyze query execution plans. It operates by having the client generate SQL based on schema tools, enforcing safety rules like blocking write operations and limiting row counts via environment variables.
Package and access
Local package with source-attributed installation metadata. Koskamo does not execute packages during review.
What you can do with it
- List available databases and tables
- Describe table columns and schema
- Execute safe read-only SELECT queries
- Explain query execution plans
Source and maintenance
- Maintenance checked
Packages and installation
Source-provided package data. Koskamo has not executed or live-probed this package.
SqlServerMcp 1.0.6
{
"version": "1.0.6",
"transport": "stdio",
"identifier": "SqlServerMcp",
"registryType": "nuget",
"registryBaseUrl": "https://api.nuget.org/v3/index.json",
"environmentVariables": [
{
"name": "ConnectionStrings__MyDb",
"value": "{connection_string}",
"variables": {
"connection_string": {
"isRequired": true,
"description": "SQL Server connection string, e.g. Server=localhost;Database=MyDatabase;Trusted_Connection=True;TrustServerCertificate=True;"
}
}
},
{
"name": "Query__DefaultTop",
"value": "{default_top}",
"variables": {
"default_top": {
"default": "1000",
"description": "Default row limit applied to queries"
}
}
},
{
"name": "Query__MaxTop",
"value": "{max_top}",
"variables": {
"max_top": {
"default": "500000",
"description": "Maximum allowed row limit"
}
}
}
]
}Tools
Reported by the attributed source; not independently observed by Koskamo.
Let your agent find its tools
Find servers like SqlServerMcp from your agent. Add Koskamo once to search the index for endpoints, access requirements, and client setup. Public discovery needs no key.