Skip to content
Agentmart
Submit a tool

MCP SQL Querystore

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

Connector by deepeshd87 · GitHub account verified by the MCP Registry

IndexedMITLocal (stdio)
Write a review

Install

Works with Claude Code, Codex, VS Code, Cursor, Windsurf, Claude Desktop. Read the repository before you give any tool access to your data.

npx agentmarket install connector/deepeshd87-mcp-sql-querystore

Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.

Get the weekly diff

The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.

We use your email only for this newsletter. Privacy

About

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

Reviews

Write a review

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this server can do and what it asks for, from its tool list and install config. Checked Oct 25, 2026.

Tools
5 read · 1 write · 0 delete
Secrets
None asked for
Install scripts
Not scanned yet
Runs as
Python package

Tools by what they do 6

Read from the source code; the running server may list different tools.

Read 5 · Look things up without changing anything.

  • analyze_parameter_sniffing
  • get_missing_index_impact
  • get_query_execution_plan
  • get_regressed_queries
  • get_wait_stats

Write 1 · Create, change, send or run things.

  • sweep_regressions

Tools (6)

Read from the source code; the running server may differ. Descriptions are the server’s own words; hidden characters are shown as [U+…].

  • analyze_parameter_sniffing

    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.

  • get_missing_index_impact

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

  • get_query_execution_plan

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

  • get_regressed_queries

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

  • get_wait_stats

    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.

  • sweep_regressions

    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.

Signals

Stars
0
Forks
0
Open issues
0
Weekly downloads
39
Last commit
Oct 3, 2026 (25 days ago)
Last release
Oct 3, 2026 (25 days ago)
Last package publish
Oct 3, 2026 (25 days ago)

From GitHub (fetched Oct 24, 2026) and the package registry.

Details

Registry name
io.github.deepeshd87/mcp-sql-querystore
Version
0.1.1
Auth
No auth
Packages
pypi mcp-sql-querystore
License
MIT
Repository
github.com/deepeshd87/mcp-sql-querystore
First seen
Oct 24, 2026
Last checked
Oct 25, 2026
Source
Official MCP Registrygithub-graphql
Cite this page

MCP SQL Querystore. Agent Mart. https://agentmart.dev/connectors/deepeshd87-mcp-sql-querystore (last updated 2026-10-25)