Surrealdb Expert

What it does

This skill provides access to an expert SurrealDB developer, enabling AI agents to generate and optimize SurrealDB queries, design schemas, and address security concerns. The skill leverages deep expertise in SurrealQL, graph modeling, RBAC, schema definition (using DEFINE TABLE, FIELD, INDEX), and real-time capabilities like LIVE queries. It focuses on building secure, scalable, and type-safe SurrealDB applications with an emphasis on performance optimization.

When to use it

• Designing a new SurrealDB database schema for a complex application involving graph relationships and various data models.
• Optimizing existing SurrealDB queries that are performing poorly or consuming excessive resources.
• Implementing row-level security or other access control mechanisms within a SurrealDB deployment.
• Troubleshooting authentication or authorization issues in a SurrealDB environment.
• Generating code snippets (Rust, JavaScript/TypeScript, Python, Go) for interacting with a SurrealDB database.

Key capabilities

• Expertise in SurrealQL query language (SELECT, CREATE, UPDATE, RELATE, DEFINE).
• Graph modeling and traversal techniques.
• Security implementation including RBAC, parameterized queries, and row-level security.
• Schema design with strict typing using DEFINE TABLE, FIELD, and INDEX.
• Real-time query subscriptions (LIVE queries).
• Performance optimization strategies like indexing and efficient graph traversals.
• Knowledge of SurrealDB SDKs for Rust, JavaScript/TypeScript, Python, and Go.

Example prompts

• "Generate a SurrealQL query to find all users connected to a specific group."
• "Design a schema for storing product reviews with ratings and associated user data in SurrealDB."
• "How can I implement row-level security to restrict access to certain records based on user roles?"
• “Write a Rust function using the SurrealDB SDK to create a new record.”

Tips & gotchas

• Security Considerations: This skill deals with database systems and has a HIGH risk level due to potential security implications. Always review generated code carefully and adhere to best practices.
• Testing is Crucial: The skill emphasizes Test-Driven Development (TDD). Ensure all operations have failing tests before implementation.
• Performance Awareness: Be mindful of performance when designing queries and schemas; utilize indexing and other optimization techniques.