About sqlInspector
Paste SQL from an AI chat, a colleague or an old script. It is parsed for your database's dialect (syntax errors with line and column), read back in plain words (what it reads, what it changes), and checked for the mistakes that run cleanly and still give a wrong result: UPDATE or DELETE without WHERE, sums over a join that counts rows twice, BETWEEN on timestamps, NOT IN with a subquery, whole-number division, a LEFT JOIN undone by WHERE. Every table and column is listed so you can tick them against your schema, and the EXPLAIN statement for the next step is ready to copy into explainViewer. Paste a PostgreSQL migration and it also flags the index and constraint changes that take a long lock on a big table (CREATE or DROP INDEX without CONCURRENTLY, CONCURRENTLY inside a transaction, SET NOT NULL, a foreign key or CHECK without NOT VALID), each with the lock it takes and the safer form. Paste a MySQL migration and each ALTER TABLE is marked INSTANT, INPLACE or COPY the way MySQL 8.4 runs it (a COPY stops every write until it ends), with the ALGORITHM and LOCK clause that makes MySQL refuse instead of copying.
Runs entirely in your browser: your SQL and files are not uploaded. Signed-in members can keep a history of runs and results.
Built on open-source libraries: node-sql-parser.
From the makers
Pilotbase: one client for every database you run (PostgreSQL, MySQL, MongoDB, Redis and more), with an AI agent built in.
Get Pilotbase freeMore free data tools
sqlBeautify
Format, highlight and fix SQL as you type
sqlCompare
Diff two SQL files like git, after formatting both
downtimeAlert
We check your URL, API or stats page every 30 seconds and email you when it's down
sqlTranslate
Convert SQL between 14 dialects
explainViewer
See where a Postgres query spends its time
keysetBuilder
Keyset pagination queries from your ORDER BY