spacetimedb-sql

Estrelas13

Forks2

Atualizado7 de maio de 2026 às 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.

Instalação

Instalar com Codex ou Claude Copie este prompt, cole no Codex, Claude ou outro assistente e deixe que ele revise a página da skill e instale para você.

Fonte

DanMossa

DanMossa/spacetimedb-skills

Abrir repositório GitHub Ver repositórios do creator

Download

Ocupações relacionadasSOC

Baseado na classificação ocupacional SOC

Arquitetos de banco de dadosInformática e Matemática·SOC 15-1243

Explorador de arquivos

2 arquivos

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.

Mais deste repositório

mesmo repositório

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-1914

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-1914

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-1914

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-0714

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-0714

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-0714

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.