Changes and migrations · stop 8 of 10
create_index_concurrently
Builds an index without blocking writes.
Needs admin modeTool sets: full
You might ask
“Add an index on orders(customer_id) without locking the table.”
Your assistant may call create_index_concurrently to answer.
How it works
- Needs admin mode. Accepts only
CREATE INDEX CONCURRENTLY, which Postgres can't run inside a transaction, so this tool runs it on its own.
Parameters
sqlstringrequired- A single CREATE INDEX CONCURRENTLY statement.
What your assistant reads
The description nexql-mcp sends with the tool. It's how the assistant decides when to use it.
Run CREATE INDEX CONCURRENTLY outside a transaction (non-blocking index build). Admin mode only.