surrealql

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.