# Apply FalkorDB index-aware predicates

> Write predicates that let FalkorDB use indexes and avoid full scans in read queries

- Skill: `falkordb/apply-falkordb-index-aware-predicates` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add falkordb/apply-falkordb-index-aware-predicates`
- Raw SKILL.md: https://api.skillmd.com/api/skills/falkordb/apply-falkordb-index-aware-predicates/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: falkordb (https://skillmd.com/u/falkordb)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/falkordb/apply-falkordb-index-aware-predicates

---


# Apply FalkorDB index-aware predicates

Design `WHERE` predicates so FalkorDB can use indexes instead of scanning every node.

## Usage

Apply equality or range predicates directly to indexed properties. Avoid not-equal filters and avoid
wrapping the indexed property in a function.

## Example

```cypher
MATCH (p:Person)
WHERE p.age >= 30 AND p.age < 40
RETURN p.name, p.age
```

## Notes

- Not-equal (`<>` / `!=`) predicates are not index-accelerated and force a full scan; use them only when
  exclusion is explicitly required.
- Equality (`=`) and range (`<`, `<=`, `>`, `>=`) predicates on indexed properties can use an index scan.
- Applying a function to the indexed property (e.g. `toLower(p.name) = 'alice'`) prevents index use; keep
  the indexed property bare on one side of the predicate when an index exists.
- Prefer positive predicates that preserve the question's intent over negations.