spacetimedb-sql

Estrellas13

Forks2

Actualizado7 de mayo de 2026 a las 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.

Instalación

Instalar con Codex o Claude Copia este prompt, pégalo en Codex, Claude u otro asistente, y deja que revise la página de la skill y la instale por ti.

Fuente

DanMossa

DanMossa/spacetimedb-skills

Abrir repositorio de GitHub Ver repositorios del creador

Descarga

Ocupaciones relacionadasSOC

Basado en la clasificación ocupacional SOC

Arquitectos de bases de datosOcupaciones informáticas y matemáticas·SOC 15-1243

Explorador de archivos

2 archivos

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.

Más de este repositorio

mismo repositorio

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.