Can this skill help me migrate from SQL to SurrealDB?

Yes, it provides guidance and query patterns for translating traditional SQL relational models into SurrealDB's multi-model structure, including document and graph patterns.

Does it support SurrealDB's graph features?

Absolutely. It includes specialized instructions for defining edge tables, using the RELATE statement, and performing multi-hop graph traversals with metadata.

Can I use it for schema-less development?

Yes, the skill supports both SCHEMAFULL and SCHEMALESS strategies, allowing for rapid prototyping or strict production validation depending on your needs.

How does it handle security and authentication?

It provides templates for DEFINE ACCESS, SCOPE, and record-level permissions to build secure, scalable authentication systems directly within the database.

SurrealDB Query Assistant

Name: SurrealDB Query Assistant
Author: tyrchen

bytyrchen

•

数据库管理

Generates production-ready SurrealQL queries and schemas for multi-model database applications including document, graph, and relational patterns.

关于

This skill provides a comprehensive suite of capabilities for SurrealDB developers, enabling the generation of solid, high-quality SurrealQL for document, graph, and relational patterns. It guides users through complex database tasks such as defining schemafull or schemaless tables, implementing record-level security and RBAC, modeling intricate graph edges, and optimizing performance through strategic indexing and custom functions. Whether you're migrating from traditional SQL/NoSQL systems or building real-time applications with LIVE queries, this skill ensures your database layer follows industry best practices for consistency and scalability.

主要功能

Generate production-ready SurrealQL for CRUD and complex graph traversals
11 GitHub stars
Design robust database schemas with SCHEMAFULL validation and type safety
Implement advanced authentication systems using record-level access and RBAC
Optimize query performance with specialized indexes, analyzers, and EXPLAIN plans
Model complex relationships using record links, graph edges, and embedded documents

使用场景

Designing e-commerce platforms with nested document structures and strict schema validation
Implementing secure, record-based authentication and authorization for high-performance applications
Building a multi-tenant social network with complex graph relationships and real-time updates

关于

主要功能

Generate production-ready SurrealQL for CRUD and complex graph traversals
11 GitHub stars
Design robust database schemas with SCHEMAFULL validation and type safety
Implement advanced authentication systems using record-level access and RBAC
Optimize query performance with specialized indexes, analyzers, and EXPLAIN plans
Model complex relationships using record links, graph edges, and embedded documents

使用场景

Designing e-commerce platforms with nested document structures and strict schema validation
Implementing secure, record-based authentication and authorization for high-performance applications
Building a multi-tenant social network with complex graph relationships and real-time updates