# io.github.deepeshd87/mcp-sql-querystore (pypi · mcp-sql-querystore)

Read-only SQL Server diagnostics for LLM agents: Query Store, waits, plans, indexes

- Trust score: 63/100 (medium)
- Change this week: +7
- Registry status: active
- Liveness: live
- Owner verified: no
- Last scored: 2026-10-17

## Components

- pypi · `mcp-sql-querystore`: 63/100 (this document), [markdown](https://verifymcp.io/servers/deepeshd87-mcp-sql-querystore/mcp-sql-querystore.md), [page](https://verifymcp.io/servers/deepeshd87-mcp-sql-querystore/mcp-sql-querystore)

## Channel facts

- Registry: `pypi`
- Package: `mcp-sql-querystore`
- Version: `0.1.1`
- Transport: `stdio`

## Trust breakdown

How this component scores in each security and reliability category. Every signal is checked automatically from public evidence about the published package, including repeated runs of it in an isolated sandbox, and we only credit what we can confirm. Scores are 0–100 per category. Scoring method: https://verifymcp.io/docs/scoring (what has changed: https://verifymcp.io/docs/scoring/changelog)

Scored 2026-10-17.

- **Supply Chain Security**: 50/100
  - Malware scan not yet available for this package.
  - No known CVEs affecting this package version or its production dependencies.
  - Runs hatchling.build at install time, a recognised build step with no custom scripting around it.
  - 0 of 29 dependencies flagged as unhealthy.
- **Provenance & Transparency**: 45/100
  - Source repository is publicly reachable at the declared URL.
  - Provenance check failed: no build-provenance attestation is published.
  - Clear OSI-approved license (MIT).
  - Actively maintained (last published 13 days ago).
  - Disclosure check failed: no security disclosure policy was found in the source repository.
- **Schema Quality & AI Usability**: 79/100
  - AI-judged instruction clarity (excellent).
  - Tool/resource definitions use about 678 tokens (~113/item across 6 items; 6 tools + 0 resources), lean.
  - Usage-examples check failed: none of the tools include examples.
- **Stability & Change Management**: 47/100
  - Stability observed for 14 of 30 days with no destabilising changes; credit accrues until the full window elapses.
- **Tool Coverage**: 100/100
  - 100% of tools have a non-trivial description (not blank, and not just the tool's name).
  - 100% of tool parameters carry a description.
- **Tool Safety**: 100/100
  - No prompt-injection markers were found in the server instructions, tool names or descriptions we captured.
  - We read all 6 captured tool definition(s), and no name or description among them implies an irreversible operation.
  - An AI judge read all 6 captured unit(s) of tool text and found none that tries to manipulate the model reading it.
- **Capabilities**: 100/100
  - Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.

## Install

### How do I install the io.github.deepeshd87/mcp-sql-querystore server?

io.github.deepeshd87/mcp-sql-querystore runs locally as a PyPI package, launched with uvx mcp-sql-querystore. Ready-made configuration for Claude, Cursor, VS Code, Codex and 5 more is on this page, copied from each client's own documentation.

### Claude

```bash
claude mcp add deepeshd87-mcp-sql-querystore -- uvx mcp-sql-querystore
```

### Cursor

```json
{
  "mcpServers": {
    "deepeshd87-mcp-sql-querystore": {
      "command": "uvx",
      "args": [
        "mcp-sql-querystore"
      ]
    }
  }
}
```

### VS Code

```json
{
  "servers": {
    "deepeshd87-mcp-sql-querystore": {
      "command": "uvx",
      "args": [
        "mcp-sql-querystore"
      ]
    }
  }
}
```

### Codex

```bash
codex mcp add deepeshd87-mcp-sql-querystore -- uvx mcp-sql-querystore
```

### opencode

```json
{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "deepeshd87-mcp-sql-querystore": {
      "type": "local",
      "command": [
        "uvx",
        "mcp-sql-querystore"
      ],
      "enabled": true
    }
  }
}
```

### OpenClaw

```bash
openclaw mcp add deepeshd87-mcp-sql-querystore --command uvx --arg mcp-sql-querystore
```

### Hermes

```yaml
mcp_servers:
  deepeshd87-mcp-sql-querystore:
    command: "uvx"
    args: ["mcp-sql-querystore"]
```

### Netclaw

```json
{
  "McpServers": {
    "deepeshd87-mcp-sql-querystore": {
      "Transport": "stdio",
      "Command": "uvx",
      "Arguments": [
        "mcp-sql-querystore"
      ]
    }
  }
}
```

### Vellum

```bash
assistant mcp add deepeshd87-mcp-sql-querystore -t stdio -c uvx -a mcp-sql-querystore
```

### Other

```json
{
  "mcpServers": {
    "deepeshd87-mcp-sql-querystore": {
      "command": "uvx",
      "args": [
        "mcp-sql-querystore"
      ]
    }
  }
}
```

## Changelog

Every change recorded for this component, newest first. Days that predate change tracking, or that we cannot explain, say so: "we were watching and nothing happened" and "we were not watching" are different claims.

### 2026-10-17 (score 63, +1)

No change was recorded against any check on this day. Stability & Change Management went from 43 to 47. That category is still filling its 30-day observation window: 13 days of observed history at the previous scan, 14 at this one. The score rises as the window fills, whether or not the server changes.

### 2026-10-15 (score 62, +1)

No change was recorded against any check on this day. Stability & Change Management went from 37 to 40. That category is still filling its 30-day observation window: 11 days of observed history at the previous scan, 12 at this one. The score rises as the window fills, whether or not the server changes.

### 2026-10-14 (score 61, −15)

- [security regression] Malware scan: pass → unverified

### 2026-10-13 (score 76, +5)

- [functional improvement] Stability: unverified → 0.33

### 2026-10-12 (score 71, +15)

- [security improvement] Malware scan: unverified → pass

### 2026-10-03 (score 56)

First indexed and scored.

## MCP tools (6)

### `get_regressed_queries` (~155 tokens)

Detect queries whose performance regressed by comparing a recent period against an earlier baseline period from Query Store.

Input parameters:

- `baseline_hours` (integer): Length of the baseline window preceding the recent window, in hours (default 7 days).
- `database_name` (string, required): Target SQL Server database name.
- `metric` (string): Metric to evaluate regression against.
- `min_executions` (integer): Ignore queries with fewer executions than this in either period (filters noise).
- `recent_hours` (integer): Length of the recent window, in hours.
- `regression_threshold` (number): Minimum fractional worsening to flag (0.5 = 50% worse than baseline).
- `top_n` (integer): Max rows to return.

### `get_query_execution_plan` (~80 tokens)

Fetch execution plan(s) for a Query Store query_id and return a compact summary (missing indexes, warnings, lookups) plus optional raw XML.

Input parameters:

- `database_name` (string, required): Target SQL Server database name.
- `include_xml` (boolean): Include raw showplan XML alongside summary.
- `query_id` (integer, required): Query Store Query ID.

### `analyze_parameter_sniffing` (~94 tokens)

Detect queries whose runtime varies widely across multiple compiled plans — the classic parameter-sniffing signature. Ranks by the ratio of slowest to fastest plan mean duration.

Input parameters:

- `database_name` (string, required): Target SQL Server database name.
- `min_plan_count` (integer): Minimum distinct plans for a query to be considered (2 = at least two plans).
- `top_n` (integer): Max rows to return.

### `get_missing_index_impact` (~92 tokens)

Aggregate missing-index recommendations found in Query Store plans, ranked by the optimizer's estimated impact score. Groups duplicate recommendations across queries.

Input parameters:

- `database_name` (string, required): Target SQL Server database name.
- `plan_scan_limit` (integer): How many recent plans (that contain missing indexes) to scan and aggregate. Higher = more thorough, slower.
- `top_n` (integer): Max index recommendations to return.

### `get_wait_stats` (~90 tokens)

Aggregate query wait time by wait category over a time window — shows WHY queries are slow (CPU, blocking/locks, IO, memory, etc.) rather than which are slow. Ranked by total wait time.

Input parameters:

- `database_name` (string, required): Target SQL Server database name.
- `recent_hours` (integer): Lookback window in hours.
- `top_n` (integer): Max wait categories to return.

### `sweep_regressions` (~167 tokens)

Run regression detection across ALL online databases that have Query Store enabled, and return the worst regressions found per database. Use this to triage a whole instance instead of one database at a time.

Input parameters:

- `baseline_hours` (integer): Length of the baseline window, in hours.
- `database_names` (array): Optional explicit list of databases to sweep. If omitted, sweeps all Query Store-enabled online databases.
- `metric` (string): Metric to evaluate regression against.
- `min_executions` (integer): Ignore queries below this execution count.
- `recent_hours` (integer): Length of the recent window, in hours.
- `regression_threshold` (number): Minimum fractional worsening to flag.
- `top_n_per_db` (integer): Max regressed queries to return per database.

## Diagnostics

Captured diagnostic sections: Provenance, Install scripts, Dependencies. The full working is on the page: https://verifymcp.io/servers/deepeshd87-mcp-sql-querystore/mcp-sql-querystore#diagnostics

## Score history

- 2026-10-17: 63
- 2026-10-16: 62
- 2026-10-15: 62
- 2026-10-14: 61
- 2026-10-13: 76
- 2026-10-12: 71
- 2026-10-07: 56
- 2026-10-06: 56
- 2026-10-04: 56
- 2026-10-03: 56

## Common questions

### What is the io.github.deepeshd87/mcp-sql-querystore server?

io.github.deepeshd87/mcp-sql-querystore is listed in the public MCP registry as io.github.deepeshd87/mcp-sql-querystore. Read-only SQL Server diagnostics for LLM agents: Query Store, waits, plans, indexes. This page covers its PyPI package (mcp-sql-querystore).

### Is the io.github.deepeshd87/mcp-sql-querystore server safe to use?

io.github.deepeshd87/mcp-sql-querystore scores 63 out of 100 on VerifyMCP. We found no known CVEs affecting it as of 17 October 2026. That is a record of what we were able to check automatically, not an endorsement. The category breakdown on this page shows every signal behind the number, including the ones we could not confirm.

### What tools does the io.github.deepeshd87/mcp-sql-querystore server expose?

io.github.deepeshd87/mcp-sql-querystore exposes 6 tools: get_regressed_queries, get_query_execution_plan, analyze_parameter_sniffing, get_missing_index_impact, get_wait_stats, sweep_regressions. Their descriptions and schemas cost roughly 678 tokens of context every time the server is loaded.

### Is the io.github.deepeshd87/mcp-sql-querystore server still maintained?

io.github.deepeshd87/mcp-sql-querystore is still listed as active in the MCP registry. We last reached this channel on 17 October 2026. Those dates come from our own scans of the registry and the channel itself, not from anything the publisher announced.

### What licence is the io.github.deepeshd87/mcp-sql-querystore server under?

io.github.deepeshd87/mcp-sql-querystore declares the MIT licence, which is OSI-approved. That covers the source only, and says nothing about the cost of any service it calls.

## Links

- PyPI project: https://pypi.org/project/mcp-sql-querystore/
- Socket report: https://socket.dev/pypi/package/mcp-sql-querystore
- Repository: https://github.com/deepeshd87/mcp-sql-querystore
- Changelog RSS feed: https://verifymcp.io/servers/deepeshd87-mcp-sql-querystore/mcp-sql-querystore.xml
- Changelog JSON feed: https://verifymcp.io/servers/deepeshd87-mcp-sql-querystore/mcp-sql-querystore.json
- HTML version of this page: https://verifymcp.io/servers/deepeshd87-mcp-sql-querystore/mcp-sql-querystore