NexQLMCP

Ask with SQL · stop 5 of 5

auto_tune_query

Suggests step-by-step fixes for a slow query.

Works in read modeTool sets: dba · full

You might ask

“Make this query faster.”

Your assistant may call auto_tune_query to answer.

How it works

  • Runs EXPLAIN ANALYZE, reads the statistics of the tables involved and looks for missing indexes.
  • Returns recommendations. It never creates an index or rewrites anything itself.

Parameters

sqlstringrequired
A single SELECT or WITH statement to tune. It executes for real.

What your assistant reads

The description nexql-mcp sends with the tool. It's how the assistant decides when to use it.

Autonomous query tuner: executes EXPLAIN ANALYZE, checks table statistics, evaluates missing indexes, and outputs step-by-step performance tuning recommendations.