SQL Optimizer Agent

Agent

byTomas Rivera·Datadog

Explains slow queries and rewrites them with the right indexes.

4.7(128)46.3k installs1.7k likesUpdated 27 days ago

Medium riskMITOpen Source

SQL Optimizer Agent

Make slow queries fast. Paste a query and its EXPLAIN (ANALYZE, BUFFERS) output and get a concrete plan.

What it does

Reads the query plan and finds the real bottleneck (seq scans, bad join order, spills)
Recommends indexes with the exact CREATE INDEX statements
Rewrites the query (CTEs, window functions, lateral joins) where it helps
Estimates before/after cost

Dialects

Postgres · MySQL · SQLite

Install

bash

npx nuclexa install sql-optimizer-agent --target claude-code

Demo

sql-optimizer-agent — preview

Interactive demo coming soon

A short walkthrough of SQL Optimizer Agent in action will appear here.

Supported platforms

CCClaude CodeCuCursorOAOpenAI Agents

Installation

Install or export SQL Optimizer Agent for any platform it supports.

Claude Code

$ npx nuclexa install sql-optimizer-agent --target claude-code

Cursor

$ npx nuclexa install sql-optimizer-agent --target cursor

OpenAI Agents

$ npx nuclexa export sql-optimizer-agent --target openai-agents

Required permissions

Medium risk

Read files
Read files in the workspace.
Write files
Create or modify files in the workspace.
Run shell commands
Execute commands in your shell.
Network access
Make outbound network requests.
Access environment variables
Read process environment variables.
Access browser
Control a browser session.
Access git history
Read commit history and diffs.
Access secrets
Read configured secrets and tokens.

Compatibility

How SQL Optimizer Agent behaves across supported runtimes.

Platform	Status	Install method
CCClaude Code	Supported	CLI install
CuCursor	Supported	Cursor rule
OAOpenAI Agents	Exportable	agent.json export

License & safety

License

MITOpen source — free for commercial use.

Safety note

Every install shows its full permission scope before it runs. Review the requested permissions and source repository before installing.

Platform

Status

Install method

CCClaude Code

Supported

CLI install

CuCursor

Supported

Cursor rule

OAOpenAI Agents

Exportable

agent.json export