Database Index Advisor

Analyze SQL queries and suggest optimal database indexes based on WHERE, JOIN, and ORDER BY clauses.

Developer & Code

This tool is being rebuilt

The earlier version did not work as described, so it is switched off until a tested version replaces it at this same address.

Tell us what you need it for

Tools that work today

SQL Playground (SQLite WASM) Run SQL queries against an in-browser SQLite database with table creation, import, and result display.
SQL Query Builder Build SQL SELECT queries visually with table joins, WHERE clauses, GROUP BY, and ORDER BY.
B-Tree Visualizer Wide, shallow, and always balanced.
SQL to MongoDB Query Converter Convert SQL SELECT queries to equivalent MongoDB find() syntax with projection and sort support.
SQL DDL to Prisma Schema Convert SQL CREATE TABLE statements to Prisma schema models with relations and field attributes.
Database Schema Designer Design database schemas visually with tables, columns, types, indexes, and relationship lines.

Web app by bee2.io

SCOUTb2

Website quality scanner

A Chrome extension that crawls a website and reports the accessibility, performance, and search problems it finds, page by page, with a shareable...

Open SCOUTb2

App by bee2.io

OhmQuill

Electrical toolkit

An offline electrical and workshop bench for component codes, wire sizing, threads, solar sizing, and unit and material math.

More Developer & Code tools

JSON Schema Validator Every error at its exact path, by the real rules.
CONTRIBUTING.md Generator Every command in it is one your project runs.
Changelog Generator from Git Log From commits to a checked changelog and version.
Commit Message Builder and Checker Proposed from the diff, checked against the spec.
README Generator from Your Project Your manifest, your scripts, your README.
AST Explorer Click the code, see the node; click the node, see the code.

What is it about?

What's missing Something isn't working Could be better Another tool I need Other

Your message (required)

0 / 2000 characters, at least 10

Name (optional)

Email (optional, for a reply)

Leave this field empty

Sent with your message: the address of this page, b2kit.com/tools/database-index-advisor/

Pressing Send gives your message and this page's address to bee2.io, the team behind b2KIT. Your name and email go along only if you enter them, and any reply goes to that email. How we handle feedback

Sent. Thank you.

This tool is being rebuilt

Help improve this tool Tell us what is missing, broken or worth adding. One minute.