Is SproutDB syntax the same as SQL?

No, SproutDB uses a unique syntax. For example, it uses GET instead of SELECT, UPSERT instead of INSERT/UPDATE, and FOLLOW instead of JOIN. This skill ensures you use the correct syntax.

Can I use semicolons or standard comments in SproutDB?

No, SproutDB queries do not use semicolons as terminators, and comments must use the '##' prefix instead of standard SQL or C# comment styles.

Does this skill help with C# development?

Yes, it includes comprehensive references for C# integration, including ISproutDatabase usage, dependency injection, and handling database responses.

How do I handle relationships in SproutDB?

SproutDB does not use traditional foreign keys. Relationships are managed at query time using the FOLLOW command, and many-to-many relationships are handled via junction tables.

SproutDB Reference & C# Integration

Name: SproutDB Reference & C# Integration
Author: BernhardPollerspoeck

byBernhardPollerspoeck

0•

Gestión de Bases de Datos

Provides specialized syntax guidance and implementation patterns for the SproutDB custom database engine and its C# integration.

The sproutdb skill is an essential reference for developers working with SproutDB, a custom embedded or networked database that utilizes a proprietary query language instead of standard SQL. It ensures Claude provides accurate syntax for unique commands like GET, UPSERT, and FOLLOW, while preventing common mistakes like using SQL-style JOINs or semicolons. The skill covers the full lifecycle of database management, including schema design without foreign keys, C# integration via ISproutDatabase, migration handling, and optimized indexing, making it indispensable for maintaining data integrity in SproutDB-powered applications.

Características Principales

01Relationship modeling using the FOLLOW command

02C# integration patterns for ISproutDatabase and ISproutServer

03Accurate SproutDB query syntax (GET, UPSERT, DELETE)

04Database migration and indexing strategies

050 GitHub stars

06Schema design and table modeling guidance

Casos de Uso

01Writing and debugging SproutDB-specific queries in C# backends

02Configuring database migrations and TTL settings for automated data cleanup

03Designing database schemas that utilize junction tables instead of arrays

Características Principales

01Relationship modeling using the FOLLOW command

02C# integration patterns for ISproutDatabase and ISproutServer

03Accurate SproutDB query syntax (GET, UPSERT, DELETE)

04Database migration and indexing strategies

050 GitHub stars

06Schema design and table modeling guidance

Casos de Uso

01Writing and debugging SproutDB-specific queries in C# backends

02Configuring database migrations and TTL settings for automated data cleanup

03Designing database schemas that utilize junction tables instead of arrays