AgentSidekick

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 directory

Profiled 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

Query Optimization: MCP servers by GitHub stars
#ProductPublisherCapabilities GitHub stars Last push Save and compare
1PerformanceMonitorFree, 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.erikdarlingdata541today
2mcp-1cMCP server for 1С:Enterprise — AI assistant sees your configuration and generates accurate BSL code. One binary, zero dependencies, 19 tools.feenlace2572d ago
3PerformanceStudioFree, 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.erikdarlingdata2521d ago
4PostgreSQL MCP ServerPostgreSQL MCP server - query, schema introspection, explain, and health checks for AI assistantsYawLabs121d ago

Plugins 6 indexed · 5 profiled

5 of these are Claude plugins, which Claude Code documents (protocol-level). DER

Query Optimization: Plugins by GitHub stars
#ProductPublisherCapabilities GitHub stars Last push Save and compare
1clickhouse-best-practices28 best practice rules for ClickHouse schema design, query optimization, and data ingestion — prioritized by impactClickHouse5742d ago
2apollo-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.apollographql1352d ago
3planetscaleAn 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.planetscale52mo ago
4zillizZilliz Cloud management plugin with 14 skills covering cluster lifecycle, collection schema, vector search, index tuning, bulk import, RBAC, backups, and monitoring.zilliztech329d ago
5database-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

Query Optimization: Agent skills by GitHub stars
#ProductPublisherCapabilities GitHub stars Last push Save and compare
1cqrs-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
2projection-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
3sql-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 platforms

Protocol-level: the platform documents support for the standard. No specific pairing has been tested.

Platforms publishers name

PlatformProfiled products naming it
Claude Code1

Integrations most often paired

Third-party services named by products with this capability, whole catalogue.

IntegrationProducts Share
PostgreSQL1037.0%
Azure27.4%
MySQL27.4%
AWS13.7%
GraphQL13.7%
MongoDB13.7%

Keywords that trigger this capability

Matched as whole words, ignoring case, in a product's name, description and repository topics.

KeywordProducts matched
query optimization14
explain plan0
slow queries4
index tuning1
query performance6
explain analyze2

Segment statistics

Whole catalogue (27 indexed products). Calculated 2026-11-21.

27DERIndexed products12 with full profiles
7DERLaunched, last 90 days2 in the 90 days before
42DERMomentum vs catalogue50 = same pace as the catalogue
32%DERLargest project's share of starsAcross 21 products with their own repository
0.240DERConcentration (HHI)About 4 equal-sized projects’ worth; moderately concentrated
2SRCMedian starsPer product with its own repository
93%DEROpen sourceMarked open source; unknown counts as not

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 breakdown

Coverage 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 .