# `PhoenixKit.Migrations.Postgres.V93`
[🔗](https://github.com/BeamLabEU/phoenix_kit/blob/v1.7.164/lib/phoenix_kit/migrations/postgres/v93.ex#L1)

V93: Add prefix index on settings key column for integration queries.

The integrations system queries settings by key prefix
(e.g., `LIKE 'integration:google:%'`). Without a supporting index,
these queries cause full table scans. This migration adds a
`text_pattern_ops` B-tree index that PostgreSQL can use for
prefix LIKE queries.

All operations are idempotent.

# `down`

# `up`

---

*Consult [api-reference.md](api-reference.md) for complete listing*