What is the best MCP server or skill for query optimisation?

By tashan's measured score: Whodb, ClickHouse Best Practices, Codspeed, Dataverse, Geosql. the score combines upkeep and freshness, gated by real adoption — every input is public and re-derivable, and no ranking position can be purchased.

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 35 capabilities for this work and ranks them by tashan score — a transparent composite of upkeep, freshness and real adoption. How we measure ›

#	Capability	tashan	Evidence	Health
1	Whodb server solid Database	78	5k ★	active
2	ClickHouse Best Practices server solid Dev Tools & CI	74	498 ★	active
3	Codspeed server solid Dev Tools & CI	72	235 ★	active
4	Dataverse server ✓ Microsoft solid Dev Tools & CI	72	184 ★	active
5	Geosql server Dev Tools & CI	72	558 ★	active
6	Data Agent Kit Starter Pack server ✓ Google solid Dev Tools & CI	71	151 ★	active
7	MongoDB server thin Dev Tools & CI	71	164 ★	active
8	Neon server solid Database	70	81 ★	active
9	BigQuery Data Analytics server ✓ Google solid Data & Analytics	68	47 ★	active
10	Cloud SQL PostgreSQL server ✓ Google solid Database	65	41 ★	active
11	Firestore Native server ✓ Google thin Database	65	30 ★	active
12	Alloydb server ✓ Google solid Database	64	22 ★	active
13	DuckDB Skills server deep Dev Tools & CI	63	523 ★	active
14	Spanner server ✓ Google thin Dev Tools & CI	63	19 ★	active
15	Oracledb server ✓ Google thin Dev Tools & CI	61	10 ★	active
16	Bigtable server ✓ Google thin Database	60	20 ★	active
17	Cloud SQL MySQL server ✓ Google solid Database	59	11 ★	active
18	Cloud SQL Sqlserver server ✓ Google solid Dev Tools & CI	57	7 ★	active
19	ClickHouse server thin Database	56	5 ★	active
20	Cockroachdb server deep Database	55	3 ★	active
21	Alloydb Omni server ✓ Google solid Security	54	4 ★	active
22	Supabase · supabase-community server thin Database	54	9 ★	active
23	Scylladb server thin Dev Tools & CI	54	6 ★	active
24	Azure SQL Developer server ✓ Microsoft thin Dev Tools & CI	53	6 ★	active
25	Planetscale server thin Data & Analytics	52	4 ★	active
26	Azure Cosmos DB Assistant server ✓ Microsoft Dev Tools & CI	51	2 ★	active
27	Altimate Code server Database	47	3 ★	active
28	Perf server Dev Tools & CI	45	2 ★	active
29	Firefox DevTools server Dev Tools & CI	45	1 marketplaces	active
30	Django Schema Design server Database	44	1 marketplaces	active
31	Sap Sqlscript server Dev Tools & CI	42	1 marketplaces	—
·	Database Designer skill Database	not scored yet	23k ★	active
·	Performance Profiler skill Dev Tools & CI	not scored yet	23k ★	active
·	SQL Database Assistant skill Dev Tools & CI	not scored yet	23k ★	active
·	Googlebigquery Automation skill Productivity	not scored yet	70k ★	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.

Other work

Agent configuration Agent development Animation and generated imagery Application development Attribution Bookkeeping Browser automation Code review Content marketing Contract review Copy editing Copywriting Dashboards and reporting Data pipelines Data quality Database access Debugging Design critique Document production Exploratory data analysis Financial modelling Incident response Infrastructure and deployment Knowledge management Literature review Market analysis Messaging and email Model evaluation Observability PRDs and specs Process automation Product strategy Project management Prompt engineering 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 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 ›