spacetimedb-sql

Sterne13

Forks2

Aktualisiert7. Mai 2026 um 20:25

Use when writing SpacetimeDB SQL for subscriptions, CLI queries, HTTP SQL, SELECT/FROM/WHERE, DML, system variables, data types, literals, identifiers, or performance. Triggers on: SQL, spacetime sql, subscription query, SELECT, WHERE, INSERT, DELETE, UPDATE, SHOW, identifier, literal.

Installation

Mit Codex oder Claude installieren Kopieren Sie diesen Prompt, fügen Sie ihn in Codex, Claude oder einen anderen Assistant ein und lassen Sie die Skill-Seite prüfen und installieren.

Quelle

DanMossa

DanMossa/spacetimedb-skills

GitHub-Repository öffnen Creator-Repositorys ansehen

Download

Verwandte BerufeSOC

Basierend auf der SOC-Berufsklassifikation

DatenbankarchitektenInformatik- und Mathematikberufe·SOC 15-1243

Datei-Explorer

2 Dateien

SKILL.md

readonly

name	spacetimedb-sql
description	Use when writing SpacetimeDB SQL for subscriptions, CLI queries, HTTP SQL, SELECT/FROM/WHERE, DML, system variables, data types, literals, identifiers, or performance. Triggers on: SQL, spacetime sql, subscription query, SELECT, WHERE, INSERT, DELETE, UPDATE, SHOW, identifier, literal.
license	MIT

Use this skill for SQL syntax and query behavior.

Core SQL split

Subscription SQL is stricter than ad hoc query/DML SQL:

Subscription form is SELECT projection FROM relation [WHERE predicate].
Subscriptions return full rows from one table only: SELECT * or SELECT table.*.
Subscriptions can reference at most two tables with one join, and join columns must be indexed.
Subscriptions do not support INSERT, UPDATE, DELETE, column projections, arithmetic expressions, or arbitrary joins.

Ad hoc SQL via CLI/HTTP supports:

SELECT with column projections, COUNT(*), joins, WHERE, and LIMIT.
INSERT INTO table (columns...) VALUES (...).
DELETE FROM table [WHERE ...]; no joins.
UPDATE table SET column = literal [WHERE ...]; no joins.
Experimental SET and SHOW system-variable statements.

Query guidance

Table names in SQL are the exact schema table names, not generated accessor names.
String literals use single quotes. Identifiers are case-sensitive; quote reserved words or unusual names with double quotes.
Hex literals can represent identities, connection IDs, or binary values when the context type is known.
Index filtered columns and join columns, especially for subscriptions.
Place the most selective table/filter first in join-heavy ad hoc queries.

Reference map

Need	Open
SpacetimeDB SQL reference	references/reference-sql.md

Guidance

Distinguish subscription SQL from mutation/query SQL when explaining allowed forms.
Check table and index definitions before recommending query changes for performance.
Route CLI execution details to spacetimedb-cli.

Mehr aus diesem Repository

gleiches Repository

spacetimedb-databases

DanMossa/spacetimedb-skills

Use when creating, developing, building, publishing, migrating, or reasoning about SpacetimeDB database modules. Covers local development, module build/publish flow, transactions, automatic migrations, incremental migrations, and the database cheat sheet. Triggers on: database module, spacetime publish, build module, migration, transaction, atomicity, developing module.

2026-06-1913

spacetimedb-reducers

DanMossa/spacetimedb-skills

Use when writing SpacetimeDB reducers, lifecycle reducers, scheduled reducers, reducer context code, table mutations, indexed lookups, reducer isolation logic, or reducer error handling. Triggers on: reducer, ReducerContext, ctx, sender, client_connected, client_disconnected, init, scheduled reducer, insert row, delete row, update row.

2026-06-1913

spacetimedb-upgrade

DanMossa/spacetimedb-skills

Use when migrating from SpacetimeDB 1.0 to 2.0 or fixing code affected by 2.0 breaking changes. Covers reducer callbacks, event tables, event type changes, subscription API, table accessor naming, database-name connections, `sender()` method, update methods, scheduled functions, private codegen, light mode, `CallReducerFlags`, and confirmed reads. Triggers on: upgrade, migrate, 1.0, 2.0, breaking changes.

2026-06-1913

spacetimedb-auth

DanMossa/spacetimedb-skills

Use when implementing SpacetimeDB authentication or authorization, including SpacetimeAuth, Auth0, Clerk, OIDC, auth claims, subject/issuer checks, custom claims, roles, row-level security, and rejecting client connections. Triggers on: auth, authentication, authorization, SpacetimeAuth, Auth0, Clerk, OIDC, claims, RLS, row-level security.

2026-05-0713

spacetimedb-cli

DanMossa/spacetimedb-skills

Use when running or explaining SpacetimeDB CLI commands and standalone configuration. Covers `spacetime init`, `build`, `publish`, `generate`, `call`, `sql`, `logs`, `describe`, `dev`, `server`, `start`, login/logout, and `config.toml`. Triggers on: spacetime CLI, spacetime publish, spacetime generate, spacetime sql, spacetime logs, spacetime server.

2026-05-0713

spacetimedb-client-c-sharp

DanMossa/spacetimedb-skills

Use when writing SpacetimeDB C# or Unity clients, generated C# bindings, connection setup, subscriptions, cache access, reducer invocation, callbacks, or identity handling. Triggers on: C#, CSharp, Unity, C# SDK, generated C# bindings, Unity SDK, C# subscription, C# reducer call.

2026-05-0713

name	spacetimedb-sql
description	Use when writing SpacetimeDB SQL for subscriptions, CLI queries, HTTP SQL, SELECT/FROM/WHERE, DML, system variables, data types, literals, identifiers, or performance. Triggers on: SQL, spacetime sql, subscription query, SELECT, WHERE, INSERT, DELETE, UPDATE, SHOW, identifier, literal.
license	MIT

Use this skill for SQL syntax and query behavior.

Core SQL split

Subscription SQL is stricter than ad hoc query/DML SQL:

Subscription form is SELECT projection FROM relation [WHERE predicate].
Subscriptions return full rows from one table only: SELECT * or SELECT table.*.
Subscriptions can reference at most two tables with one join, and join columns must be indexed.
Subscriptions do not support INSERT, UPDATE, DELETE, column projections, arithmetic expressions, or arbitrary joins.

Ad hoc SQL via CLI/HTTP supports:

SELECT with column projections, COUNT(*), joins, WHERE, and LIMIT.
INSERT INTO table (columns...) VALUES (...).
DELETE FROM table [WHERE ...]; no joins.
UPDATE table SET column = literal [WHERE ...]; no joins.
Experimental SET and SHOW system-variable statements.

Query guidance

Table names in SQL are the exact schema table names, not generated accessor names.
String literals use single quotes. Identifiers are case-sensitive; quote reserved words or unusual names with double quotes.
Hex literals can represent identities, connection IDs, or binary values when the context type is known.
Index filtered columns and join columns, especially for subscriptions.
Place the most selective table/filter first in join-heavy ad hoc queries.

Reference map

Need	Open
SpacetimeDB SQL reference	references/reference-sql.md

Guidance

Distinguish subscription SQL from mutation/query SQL when explaining allowed forms.
Check table and index definitions before recommending query changes for performance.
Route CLI execution details to spacetimedb-cli.