Pilotbase

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 free

More free data tools