SQL Index Advisor

Analyze SQL queries and suggest indexes

SQL Index Advisor is a free online Developer tool. Analyze SQL queries and suggest indexes Related terms: 索引 · index · SQL · 优化 · 查询 · 建议. Use it on this page without signing in.

基于启发式规则分析，适用于 MySQL / PostgreSQL / SQLite。SQL 文本仅在浏览器本地处理，不会上传。实际优化效果请结合 EXPLAIN 执行计划验证。

Help

使用说明

  1. 粘贴 SQL 查询语句（SELECT/JOIN/WHERE/ORDER BY）
  2. 自动分析哪些列需要索引、是否可建复合索引
  3. 检测常见性能反模式（SELECT 、LIKE 前缀通配、隐式类型转换等）
  4. 生成 CREATE INDEX 建议语句

常见问题

  • 支持哪些数据库？ 分析规则通用，适用于 MySQL/PostgreSQL/SQLite
  • 结果准确吗？ 基于启发式规则，实际效果需结合 EXPLAIN 执行计划判断
  • 数据上传吗？ 不会，SQL 文本在浏览器本地分析

More Developer

View all

JSON Formatter

Format, minify, validate JSON, convert to Go struct / TS interface

JSON Field Search

Search JSON by field, value or path with highlights, supports jq expressions

Timestamp Converter

Convert between Unix timestamps and dates, seconds and milliseconds

Cron Expression

Generate and parse cron expressions, preview next run time

UUID Generator

Generate UUID v4 / v7 / ULID / NanoID

Hash Calculator

Compute MD5 / SHA1 / SHA256 / SHA512 of text or files

JWT Decoder

Decode JWT header and payload, view expiry time

URL Encoder / Decoder

Encode and decode URL / URI components

FAQ about SQL Index Advisor

What can SQL Index Advisor do?

SQL Index Advisor is a Developer tool. Analyze SQL queries and suggest indexes You can finish the job on this page.

Who should use SQL Index Advisor?

Anyone handling 索引 · index · SQL · 优化 · 查询 · 建议 who does not want to install desktop software can use SQL Index Advisor in the browser.

Is SQL Index Advisor safe? Is my data uploaded?

This tool runs in your browser. We do not collect the content you enter into SQL Index Advisor just because you used it.

What similar tools exist?

Related tools in the same Developer group are listed at the bottom of this page.