What is the best MCP servers and plugin for query optimisation?

By tashan's measured score: DuckDB Skills, Cockroachdb, Whodb, ClickHouse Best Practices, Codspeed. the score combines upkeep and freshness, gated by real adoption — every input is public and linked to its source.

Who does query optimisation as part of their job?

This is a process step performed by Database Administrators, Database Architects, per the O*NET 30.3 occupational database.

How is the ranking calculated?

From public signal only: npm download volume and publish cadence, GitHub push/release recency, contributor count, registry status, and how often a capability appears in real public agent configs. Nobody can pay to change a score, rank, or listing.

The Index · Query optimisation

Query optimisation

'Tuning'; the artifact is an EXPLAIN plan. NOT plain database access — see `database-access`. tashan measures 33 capabilities for this work. Ranked on upkeep, freshness and real adoption, every input public. How we measure ›

#	Capability	tashan	Evidence	Health
1	DuckDB Skills primary plugin deep	58	523 ★	active
2	Cockroachdb primary plugin deep	53	3 ★	active
3	Whodb primary plugin solid	73	5k ★	active
4	ClickHouse Best Practices primary plugin solid	71	498 ★	active
5	Codspeed primary plugin solid	69	235 ★	active
6	Data Agent Kit Starter Pack primary plugin ✓ Google solid	68	151 ★	active
7	Dataverse · microsoft primary plugin ✓ Microsoft solid	68	184 ★	active
8	Geosql primary plugin solid	68	558 ★	active
9	Neon primary plugin solid	66	81 ★	active
10	BigQuery Data Analytics primary plugin ✓ Google solid	60	47 ★	active
11	Cloud SQL PostgreSQL primary plugin ✓ Google solid	60	41 ★	active
12	Alloydb primary plugin ✓ Google solid	59	22 ★	active
13	Cloud SQL MySQL primary plugin ✓ Google solid	55	11 ★	active
14	Cloud SQL Sqlserver primary plugin ✓ Google solid	53	7 ★	active
15	Alloydb Omni primary plugin ✓ Google solid	50	4 ★	active
16	Azure Cosmos DB Assistant primary plugin ✓ Microsoft solid	48	2 ★	active
17	Sap Sqlscript primary plugin	42	1 marketplaces	—
18	Perf · agent-sh primary plugin	40	2 ★	active
19	Firefox DevTools · mozilla primary plugin	40	1 marketplaces	active
20	Django Schema Design primary plugin	39	1 marketplaces	active
21	MongoDB · mongodb primary plugin thin	68	164 ★	active
22	Firestore Native primary plugin ✓ Google thin	60	30 ★	active
23	Spanner primary plugin ✓ Google thin	58	19 ★	active
24	Oracledb primary plugin ✓ Google thin	56	10 ★	active
25	ClickHouse · clickhouse primary plugin thin	54	5 ★	active
26	Bigtable primary plugin ✓ Google thin	53	20 ★	active
27	Azure SQL Developer primary plugin ✓ Microsoft thin	50	6 ★	active
28	Planetscale primary plugin thin	49	4 ★	active
29	Supabase · supabase-community primary plugin thin	49	9 ★	active
30	Scylladb primary plugin thin	48	6 ★	active
31	Altimate Code primary plugin thin	44	3 ★	active
32	Prodcheck supporting npm	69	2k/wk	active
33	Sqlserver supporting npm	51	82/wk	active

Who does this work

O*NET records this as a core process step for 2 occupations, including Database Administrators, Database Architects.

Recorded there as: "Assess database performance" / "Develop database parameters or specifications". We publish it under the name practitioners use.

Recently changed in Query optimisation

4 changes recorded here in the last 45 days, newest and most serious first.

2026-08-19 ClickHouse Best Practices — the tashan score for clickhouse-best-practices fell to 48.0, from 73.0
2026-08-20 ClickHouse Best Practices — the tashan score for clickhouse-best-practices rose to 73.0, from 48.0
2026-08-27 ClickHouse Best Practices — the tashan score for clickhouse-best-practices fell to 47.0, from 72.0
2026-09-13 ClickHouse Best Practices — the tashan score for clickhouse-best-practices rose to 71.0, from 47.0

This page cannot know what you run. tashan doctor reads your own config and names which of these you have — Pro adds the history behind each, and what to move to.

tashan Pro — $6/mo ›

Other work

Agent configuration Agent development Animation and generated imagery Application development Attribution Audio production Audit Bookkeeping Browser automation CAD modelling Career development Code review Content marketing Contract review Copy editing Copywriting Customer support Dashboards and reporting Data pipelines Data quality Database access Debugging Design critique Document production Exploratory data analysis Financial modelling Hardware design Incident response Infrastructure and deployment Knowledge management Literature review Logistics and fulfilment ML engineering Market analysis Messaging and email Model evaluation Observability PRDs and specs Performance optimisation Process automation Product strategy Project management Prompt engineering Recruiting and hiring Regulatory compliance Retrieval systems Risk assessment SEO Sales pipeline Scientific research Security review Software architecture Statistical modelling Technical documentation Test automation Training material User research Version control Video editing Visual design Web development Web research Web scraping

Occupational data from the O*NET 30.3 Database by the U.S. Department of Labor, Employment and Training Administration, used under CC BY 4.0. tashan consolidated its process steps into the terms practitioners use; O*NET does not endorse this site.

See the full Index ›

tashan Pro$6/mo

4 changes across Query optimisation in the last 45 days. A new advisory, an install script appearing, a maintainer leaving. All listed free above. Pro keeps the series behind each row, so a number today comes with a direction.

The whole series behind any row, back to the first day we measured it
The replacement, named — not just the news that something died
tashan doctor over your own config, on your own machine

Start a 7-day trial › Everything measured on this page stays free.