What problem does it solve?
This Skill helps users write correct SurrealQL queries, manage SurrealDB schema definitions, and debug errors, preventing common pitfalls and ensuring efficient database operations.
Core Features & Use Cases
- SurrealQL Syntax: Provides guidance on correct SurrealQL syntax, differentiating it from standard SQL.
- Schema Management: Assists in defining tables, fields, indexes, and relations using
DEFINE statements.
- Query Debugging: Helps identify and fix errors in SurrealQL queries, especially concerning
UPSERT, VALUE vs COMPUTED, and FULLTEXT vs SEARCH analyzers.
- Use Case: You need to create a new table in SurrealDB 3.0 to store user preferences, ensuring it's
SCHEMAFULL and includes a FULLTEXT index for searching user-defined descriptions.
Quick Start
Use the surrealql skill to write a SurrealQL query to create a new table named 'preferences' with a 'user_id' field and a 'description' field that supports full-text search.