spacetimedb-sql

Stars13

Forks2

UpdatedMay 7, 2026 at 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

Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.

Source

DanMossa

DanMossa/spacetimedb-skills

View GitHub Repository View Creator Repositories

Download

Related occupationsSOC

Based on SOC occupation classification

Database ArchitectsComputer and Mathematical Occupations·SOC 15-1243

File Explorer

2 files

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.

More from this repository

same 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.