# SQL Server Schema Explorer

> Use this tool when you need to explore and understand SQL Server database schemas, retrieve table and column information, or identify relationships between tables. It solves problems such as generating database-related code, understanding database structures, and querying schema details. The tool takes connection strings as input and provides tables, columns, and relationships as output, making it ideal for use cases where database insight is required within an AI assistant interface.

Canonical page: https://skillsregistry.net/skills/jdlemes-sql-server-schema-explorer  
JSON: https://api.skillsregistry.net/v1/skills/jdlemes-sql-server-schema-explorer

## Description

MsSqlMCP is a Model Context Protocol server that enables AI assistants to query SQL Server database schemas, providing tools to retrieve tables, columns, and relationships. Built with .NET 9, it offers three main functions: getting all tables in a database, retrieving columns for a specific table, and identifying relationships between tables. The implementation connects to SQL Server databases using connection strings configured in appsettings.json, making it particularly valuable for developers who need to understand database structures or generate database-related code without leaving their AI assistant interface.

## Trust

- **Trust score (0–1):** 0.30
- **Verification tier:** unverified
- **Last scanned:** 2026-09-02

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-02

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/jdlemes-sql-server-schema-explorer)
- **Repository:** <https://github.com/jdlemes/mssqlmcp>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "jdlemes-sql-server-schema-explorer"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/jdlemes-sql-server-schema-explorer` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/jdlemes-sql-server-schema-explorer/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt