NexQLMCP

Changes and migrations · stop 3 of 10

check_ddl_safety

Warns about schema changes that would lock or rewrite a table.

Works in read modeTool sets: dba · full

You might ask

“Is it safe to run this ALTER TABLE on production?”

Your assistant may call check_ddl_safety to answer.

How it works

  • Reads the DDL without running it and scores the risk: non-concurrent index builds, column drops, table rewrites and other exclusive locks.
  • Suggests the zero-downtime alternative where there is one. CREATE DATABASE / DROP DATABASE always rate CRITICAL.

Parameters

ddlstringrequired
One or more DDL statements to inspect for locking risk. Not executed.

What your assistant reads

The description nexql-mcp sends with the tool. It's how the assistant decides when to use it.

Safety guard for migration DDL: inspects SQL for dangerous exclusive locks (e.g. non-concurrent index builds, column drops, table rewrites) and outputs risk scores and safe zero-downtime alternatives.