Query Optimization
Tuning slow queries and indexes. As of 2026-11-21, 27 indexed products offer it (12 with full profiles), in 3 forms: 18 MCP servers, 6 Plugins, 3 Agent skills. 7 were published in the last 90 days, against 2 in the 90 days before. clickhouse-best-practices has the most GitHub stars, 32% of the total across 21 products with their own repository.
CapabilitySegment label: Thin DERScored as an opportunity
Available as
All in the directoryProfiled products grouped by product form. Within each form: own-repository products by GitHub stars, then products in a subfolder of a larger repository (they show that repository's stars), up to 10 each.
MCP servers 18 indexed · 4 profiled
Protocol-level reach: 36 of the 45 active platforms AgentSidekick tracks document support for MCP. DER Which platforms
| # | Product | Publisher | Capabilities | GitHub stars | Last push | Save and compare |
|---|---|---|---|---|---|---|
| 1 | PerformanceMonitorFree, open-source SQL Server and Postgres performance monitoring. Collectors, real-time alerts, graphical plan viewer, MCP server for AI analysis. Supports SQL 2016-2025, Azure SQL, AWS RDS, Postgres, Aurora Postgres. | erikdarlingdata | 541 | today | ||
| 2 | mcp-1cMCP server for 1С:Enterprise — AI assistant sees your configuration and generates accurate BSL code. One binary, zero dependencies, 19 tools. | feenlace | 257 | 2d ago | ||
| 3 | PerformanceStudioFree, open-source SQL Server execution plan analyzer — cross-platform GUI + CLI with 30 analysis rules, missing index detection, SSMS extension. Built-in MCP server for AI-assisted plan review. | erikdarlingdata | 252 | 1d ago | ||
| 4 | PostgreSQL MCP ServerPostgreSQL MCP server - query, schema introspection, explain, and health checks for AI assistants | YawLabs | 12 | 1d ago |
Plugins 6 indexed · 5 profiled
5 of these are Claude plugins, which Claude Code documents (protocol-level). DER
| # | Product | Publisher | Capabilities | GitHub stars | Last push | Save and compare |
|---|---|---|---|---|---|---|
| 1 | clickhouse-best-practices28 best practice rules for ClickHouse schema design, query optimization, and data ingestion — prioritized by impact | ClickHouse | 574 | 2d ago | ||
| 2 | apollo-skillsApollo GraphQL agent skills for Claude Code — Apollo Client, Server, Federation, Connectors, Router, Rover CLI, iOS, Kotlin, and the Apollo MCP server. Covers schema design, query optimization, and GraphQL best practices. | apollographql | 135 | 2d ago | ||
| 3 | planetscaleAn authenticated hosted MCP server that accesses your PlanetScale organizations, databases, branches, schema, and Insights data. Query against your data, surface slow queries, and get organizational and account information. | planetscale | 5 | 2mo ago | ||
| 4 | zillizZilliz Cloud management plugin with 14 skills covering cluster lifecycle, collection schema, vector search, index tuning, bulk import, RBAC, backups, and monitoring. | zilliztech | 3 | 29d ago | ||
| 5 | database-performance-optimizerUse this agent when you need to optimize database performance for B2B applications at enterprise scale. This agent specializes in multi-tenant database optimization, query performance tuning, indexing strategies, connection pooling, and database scaling for SaaS platforms. Handles PostgreSQL, MySQL, MongoDB, and cloud database optimizations. Examples: | ccplugins | — | 3mo ago |
Agent skills 3 indexed · 3 profiled
Protocol-level reach: 26 of the 45 active platforms AgentSidekick tracks document support for the Agent Skills format. DER Which platforms
| # | Product | Publisher | Capabilities | GitHub stars | Last push | Save and compare |
|---|---|---|---|---|---|---|
| 1 | cqrs-implementationImplement Command Query Responsibility Segregation for scalable architectures. Use when separating read and write models, optimizing query performance, or building event-sourced systems. | wshobson | — | 3d ago | ||
| 2 | projection-patternsBuild read models and projections from event streams. Use when implementing CQRS read sides, building materialized views, or optimizing query performance in event-sourced systems. | wshobson | — | 3d ago | ||
| 3 | sql-optimization-patternsMaster SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance. | wshobson | — | 3d ago |
Which platforms these forms can reach
All platformsProtocol-level: the platform documents support for the standard. No specific pairing has been tested.
MCP servers 18 indexed here
36 platforms document MCP support CUR.
ContinueOpenCodeClaude CodeCodexGemini CLIZedOpenHandsClineWarpgooseQwen CodeBolt (bolt.new)KiroAmazon Bedrock AgentCoreAmpApps in ChatGPT / Apps SDK (now ChatGPT Plugins)Augment CodeChatGPTClaude (claude.ai apps)Claude DesktopCursorDevinDevin Desktop (formerly Windsurf)Factory (Droid)Gemini (app)Gemini Enterprise Agent Platform (formerly Vertex AI / Vertex AI Agent Builder)GitHub CopilotGitHub Copilot cloud agent (formerly Copilot coding agent)Google AntigravityJetBrains AI AssistantJunieLovableMicrosoft Copilot StudioReplit AgentTabninev0
Agent skills 3 indexed here
26 platforms document Agent Skills support CUR.
OpenClawOpenCodeClaude CodeCodexGemini CLIOpenHandsWarpgooseBolt (bolt.new)KiroAmpApps in ChatGPT / Apps SDK (now ChatGPT Plugins)ChatGPTClaude (claude.ai apps)Claude DesktopCursorDevinDevin Desktop (formerly Windsurf)Factory (Droid)Gemini (app)GitHub CopilotGitHub Copilot cloud agent (formerly Copilot coding agent)Google AntigravityJunieReplit AgentTabnine
Platforms publishers name
| Platform | Profiled products naming it |
|---|---|
| Claude Code | 1 |
Integrations most often paired
Third-party services named by products with this capability, whole catalogue.
Keywords that trigger this capability
Matched as whole words, ignoring case, in a product's name, description and repository topics.
| Keyword | Products matched |
|---|---|
| query optimization | 14 |
| explain plan | 0 |
| slow queries | 4 |
| index tuning | 1 |
| query performance | 6 |
| explain analyze | 2 |
Segment statistics
Whole catalogue (27 indexed products). Calculated 2026-11-21.
Thin. Among the smallest 30% of capabilities, and launches are not outpacing the catalogue. Size is ranked against all capabilities; momentum compares launches in the last 90 days with the 90 before, relative to the catalogue’s own ratio (62 or more = faster, 38 or less = slower; under 5 dated launches it is not measured). The HHI of 0.240 means stars are spread as if across about 4 equally popular projects — moderately concentrated by the common 0.15 / 0.25 thresholds. Stars measure attention, not usage or quality.
Scored as an opportunity
Score breakdownCoverage gap: Query Optimization: score 57.6 HEU, competition High, confidence Low. Only 27 indexed products match "Query Optimization", against 605 in SQL Databases overall.
Limits
- Classification is by the keywords above. A product that offers this capability without using one of them is not counted; one that uses a keyword in another sense is counted wrongly. Methodology
- Platform reach is protocol-level: it says a platform documents the standard, not that any product here was tested on it. Platforms named by publishers are their own claims.
- Stars belong to repositories. Products in a subfolder of a large repository show that whole repository’s stars and are excluded from the concentration figures.
- Launch counts use each source’s publication date; for auto-discovered repositories that is the repository’s creation date.
Page data last updated .