skillZs
★ LIVE SKILL TAGS ★
>>> LIVE SKILLS INDEX <<<
* OPEN SOURCE *
NO LOGIN, NO TRACKING
※ REAL INSTALL DATA ※
← back to all skills
danmossa/spacetimedb-skills67 installs

spacetimedb-sql

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.

How do I install this agent skill?

npx skills add https://github.com/danmossa/spacetimedb-skills --skill spacetimedb-sql
view source ↗

Is this agent skill safe to install?

  • Gen Agent Trust Hubpass

    This skill provides documentation and syntax references for writing SpacetimeDB SQL queries and subscriptions. No security issues or malicious patterns were detected.

  • Socketpass

    No alerts

  • Snykpass

    Risk: LOW · No issues

What does this agent skill do?

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

NeedOpen
SpacetimeDB SQL referencereferences/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.

Add the canonical catalog link to the repository README so users can inspect current installs and available audits. The publishing guide covers the complete discovery path.

<a href="https://skillzs.dev/skills/danmossa/spacetimedb-skills/spacetimedb-sql">View spacetimedb-sql on skillZs</a>