Permission aware query builder

Skill aborroy/aiup-alfresco/.cursor/skills/permission-aware-query-builder

Warns when CMIS or Alfresco Query Language queries may bypass ACLs. Suggests SearchService with authority context instead. Trigger when generating search or query code.From its SKILL.md

Install

npx -y skills add aborroy/aiup-alfresco --skill permission-aware-query-builder

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

13 stars13 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

SKILL.md

1.1 KB, 204 tokens by cl100k_base, as published. Nobody here has run it

Permission-Aware Query Builder

Review generated query code for potential ACL bypass issues.

Rules

Never use direct JDBC/Hibernate queries to access nodes — these bypass the permission model entirely
CMIS queries run in the context of the authenticated user by default — this is safe
SearchService queries — verify SearchParameters includes authority context when needed
AuthenticationUtil.runAsSystem — flag any query executed inside runAsSystem as a potential security issue unless explicitly justified
sys_acl / sys_racl — when using Search Enterprise (Elasticsearch), verify that ACL fields are included in the search index configuration
Solr AFTS queries — respect fts.alfresco.defaultNamespace setting; warn if queries hardcode node refs

Output

Flag each potential ACL bypass with severity (high/medium/low), explanation, and suggested fix.

What ships with it

Read from the repository

Just SKILL.md. No reference files, no scripts.