The request is about SQL optimization patterns, so the most relevant products are those whose sources describe SQL query tuning or database performance. ClickHouse 2 publishes 28 query optimization best-practice rules and an architecture advisor 12, Supabase's Postgres platform 3 ships Postgres best-practices guidance 13, MongoDB 5 offers a query optimizer skill 15, and GitHub 1 lists a universal SQL performance optimization assistant 11.
- 1
ClickHouseclickhouse.comverified and signed
ClickHouse publishes 28 best-practice rules for query optimization, schema design and data ingestion, prioritized by impact 12.
official:MCP server · ClickHouseSDK · @clickhouse/clientskill · buildskill · install-skillsskill · clickhouse-best-practices+28 community tools built for it
for agents: clickhouse-best-practices · clickhouse-best-practices · clickhouse-architecture-advisor
- 2
Supabasesupabase.comverified and signed
Supabase provides Postgres best practices for query and schema work, maintained by Supabase and loaded as a skill before writing or changing database code 13.
official:SDK · @supabase/supabase-jsCLI · supabasepackage · Supabaserepository · supabaseskill · supabase-postgres-best-practices+103 community tools built for it
for agents: vercel-composition-patterns · supabase-postgres-best-practices · search_rows
- 3
MongoDBmongodb.comverified and signed
MongoDB offers a query optimizer skill for query optimization and indexing, used when the user asks for performance help 15.
official:SDK · mongodbskill · mongodb-query-optimizerskill · mongodb-schema-designskill · mongodb-connectionskill · mongodb-natural-language-querying+57 community tools built for it
for agents: mongodb-query-optimizer · mongodb-schema-design · mongodb-natural-language-querying
- 4
GitHubgithub.comverified and signed
GitHub lists a universal SQL performance optimization assistant for query tuning, indexing strategies and database performance analysis 11.
official:CLI · github-mcp-serverskill · add-community-extensionskill · git-commitskill · acquire-codebase-knowledge+2,563 community tools built for it
for agents: sql-optimization · power-bi-dax-optimization · dataverse-python-advanced-patterns
- 5
Alibaba Cloud Documentation Center Aliyunalibabacloud.comfound in code, not yet checked
Alibaba Cloud offers an optimizeSql action that analyzes and optimizes SQL performance from a given SQL statement 17.
+10 community tools built for it
for agents: optimizeSql · describe_sql_patterns · describe_available_advices
Sources
- 1GitHub · Change is constant. GitHub keeps you ahead. · GitHub · GitHubgithub.com · read 2026-10-29
- 2Fast Open-Source OLAP DBMS | ClickHouseclickhouse.com · read 2026-10-29
- 3Supabase | The Postgres Development Platformsupabase.com · read 2026-10-29
- 5MongoDB | The Intelligent Data Platform for the AI Era | MongoDBmongodb.com · read 2026-10-29
- 7MaxCompute client (odpscmd): Download, install, configure, and run - MaxCompute - Alibaba Cloud Documentation Centeralibabacloud.com · read 2026-10-29
- 11sql-optimization: declares "sql-optimization" (the record we read and signed)unfragile.ai · read 2026-10-24
- 12clickhouse-best-practices: declares "clickhouse-best-practices" (the record we read and signed)unfragile.ai · read 2026-10-24
- 13vercel-composition-patterns: declares "vercel-composition-patterns" (the record we read and signed)unfragile.ai · read 2026-10-24
- 15mongodb-query-optimizer: declares "mongodb-query-optimizer" (the record we read and signed)unfragile.ai · read 2026-10-24
- 17Alibaba Cloud DMS MCP Server: declares "optimizeSql" (the record we read)github.com · read 2026-10-24
For agents: the 10 actions behind this answer
sql-optimization · sql-optimization verified and signed
Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monit
clickhouse-best-practices · clickhouse-best-practices verified and signed
28 best practice rules for ClickHouse schema design, query optimization, and data ingestion — prioritized by impact
vercel-composition-patterns · vercel-composition-patterns verified and signed
React composition patterns that scale. Use when refactoring components with boolean prop proliferation, building flexible component libraries, or designing reusable APIs. Triggers on tasks involving compound components, render props, context providers, or component architecture. Includes React 19 AP
find_rows · MySQL (Activepieces) verified and signed
Find Rows — Reads rows from a table
mongodb-query-optimizer · mongodb-query-optimizer verified and signed
Help with MongoDB query optimization and indexing. Use only when the user asks for optimization or performance: "How do I optimize this query?", "How do I index this?", "Why is this query slow?", "Can you fix my slow queries?", "What are the slow queries on my cluster?", etc. Do not invoke for gener
runQuery · Snowflake (Activepieces) verified and signed
Run Query — Execute a SQL query against your Snowflake database and return the results as rows.
optimizeSql · Alibaba Cloud DMS MCP Server found in code, not yet checked
Analyze and optimize SQL performance based on the provided SQL statement
· SQLAlchemy website read, tools not yet checked
The Database Toolkit for Python
prompt-optimizer · prompt-optimizer verified and signed
Creates, optimizes, and iteratively refines agent prompts, system prompts, developer prompts, and reusable prompt templates. Use when asked to improve a prompt, optimize a system prompt, rewrite an agent prompt, tune prompt wording, make a prompt more reliable, port prompts between OpenAI, Claude, o
instrumentation · prometheus-client verified and signed
Labels are the instruments' verdict and are never changed by ranking. Agents and robots get this same answer as JSON at /api/v1/find?q=…&answer=1 and through the MCP server.