Engineering template

Query-Plan Index Advisor

Paste a slow query plus its EXPLAIN and get the index that fixes it.

A query-tuning consultant that bills by the plan, not the hour. Paste a SQL query with its EXPLAIN (or EXPLAIN ANALYZE) output and it tells you in plain language what is slow, why, and the specific index or rewrite that removes the bottleneck, with the exact CREATE INDEX statement. Example input: a Postgres query filtering orders by customer_id and status whose plan shows a Seq Scan over 2M rows. Example output: strict JSON with verdict, hotspots[] (node, cost, why), recommendations[] (type, ddl, expected), rewrite, and caveats, e.g. ddl "CREATE INDEX idx_orders_customer_status ON orders (customer_id, status);".

The flow this template ships
InputLLM (Claude)Output
$0.12 / call3 steps wiredEngineeringCore

Who pays: Backend and data engineers chasing slow endpoints: every regressed query gets a concrete index recommendation before they page a DBA.

How it runs
Runs on demand

Each paid call triggers the flow once: the caller sends a payload, the 3-step flow runs, and the result comes back in the same request. Preview runs are always free and have no side effects.

$0.12 per plan, suggested

The template opens in the studio with this price already loaded. You set the final price before launch, and every live call is paid in USDC through the x402 payment rail.

Built on core nodes

The wired flow uses built-in nodes only. Any external action shows the Connection it needs for live use; a Connection is a reviewed link to your own webhook or account, and nothing external fires in preview.

Related templates
Start building

Open Query-Plan Index Advisor in the studio

The 3-step flow arrives wired, priced, and ready to preview free. Make it yours, then launch when you're ready.

Open this template →