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-sqlIs 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 *orSELECT 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:
SELECTwith column projections,COUNT(*), joins,WHERE, andLIMIT.INSERT INTO table (columns...) VALUES (...).DELETE FROM table [WHERE ...]; no joins.UPDATE table SET column = literal [WHERE ...]; no joins.- Experimental
SETandSHOWsystem-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.
How can the creator link this skill?
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>