Design SurrealDB schemas with permissions, row-level security, and indexing.
npx skills add https://github.com/twarogowski/trauma2 --skill surrealdb-expert
Please help me install this Agent Skill. Skill: surrealdb-expert Source: https://github.com/twarogowski/trauma2/tree/main/.claude/skills/surrealdb-expert Command: npx skills add https://github.com/twarogowski/trauma2 --skill surrealdb-expert
SurrealDB Expert helps teams design secure, scalable multi-model schemas and efficient queries, reducing security risks and development time by providing best-practice patterns.
Start by outlining a SurrealDB schema for a sample domain (e.g., users, posts, and comments) with a typed relationship edge, apply row-level security, and add relevant indexes. Then refine the model to support RBAC roles and live subscription needs.
High-intent search queries and answers about installing and using this skill.
To implement row-level security and RBAC in SurrealDB, define explicit PERMISSIONS within your SCHEMAFULL table definitions. This enforces least privilege access by restricting data visibility based on assigned user roles and parameterized query conditions.
Modeling graph and document schemas in SurrealDB involves combining typed relationship edges with document records. You define SCHEMAFULL tables for nodes and edges, apply indexing strategies, and use optimized graph traversal queries for efficient data retrieval.
Live queries and real-time subscriptions in SurrealDB are set up using the LIVE query feature to push updates to connected clients. You establish subscriptions with proper cleanup patterns and monitoring to maintain responsive real-time dashboards.
Avoid N+1 query problems and optimize SurrealDB performance by using the FETCH clause to eager-load related graph edges and document records. Combine this with proper indexing strategies and optimized graph traversals to reduce query overhead.
You can architect a multi-tenant application in SurrealDB by combining SCHEMAFULL definitions, RBAC, and row-level security. This approach isolates tenant data through explicit PERMISSIONS while supporting audit trails and real-time live query dashboards.
tyrchenplaceholder
ConnectiveTCSDesign secure SurrealDB schemas with RBAC, row-level security, and live queries.
gdurandvadasEnforce security-focused SurrealDB schema design with RBAC patterns.
martinholovskyGuide SurrealDB development with SurrealQL optimization and row-level security.
