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

spacetimedb-tables

Use when defining or changing SpacetimeDB tables, columns, constraints, primary keys, unique constraints, indexes, auto-increment fields, default values, event tables, schedule tables, access permissions, file storage, or table performance. Triggers on: table, column, primary key, unique, index, btree, direct index, event table, schedule table.

How do I install this agent skill?

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

Is this agent skill safe to install?

  • Gen Agent Trust Hubpass

    The skill provides comprehensive documentation and best practices for managing data structures in SpacetimeDB. It includes code examples for schema definition, access control, and performance optimization across multiple programming languages. No security risks or malicious behaviors were detected.

  • Socketpass

    No alerts

  • Snykpass

    Risk: LOW · No issues

What does this agent skill do?

Use this skill for module schema and table performance.

Core table patterns

TypeScript tables use table(options, columns) and must be passed to schema() as an object:

import { schema, table, t } from "spacetimedb/server";

const player = table(
  { name: "player", public: true },
  {
    id: t.u64().primaryKey().autoInc(),
    identity: t.identity().unique(),
    name: t.string().index("btree"),
  },
);

export default schema({ player });

Language-specific table declarations:

  • TypeScript: { name: "player_score" } creates ctx.db.playerScore.
  • C#: [SpacetimeDB.Table(Accessor = "Player", Public = true)] creates ctx.Db.Player; the type must be partial.
  • Rust: #[spacetimedb::table(accessor = player, public)] creates ctx.db.player(); pub struct does not make a table public.
  • C++: SPACETIMEDB_TABLE(Type, player, Public) creates ctx.db[player].

Design rules

  • Organize data by access/update pattern. Split hot, frequently updated state from rarely changed profile, settings, or stats fields.
  • Public tables are visible to clients through subscriptions. Keep server-only state private and expose derived subsets through views when needed.
  • Primary keys and unique constraints automatically create indexes; do not add duplicate indexes for them.
  • Add indexes only for frequent equality, range, subscription, or join paths. Use B-tree by default; direct indexes are for dense unsigned integer keys and are not universally supported in every language.
  • New columns in existing published tables need defaults and must be appended at the end. Check database migration rules before changing existing schemas.
  • Auto-increment values are generated by the database and can have gaps after failed transactions.
  • Use event tables for append-only client notifications; the event flag cannot be changed after publish.
  • Schedule tables need a ScheduleAt column and a linked scheduled reducer. In TypeScript, import ScheduleAt from spacetimedb, not spacetimedb/server.

Reference map

NeedOpen
Table definitions and core patternsreferences/tables.md
Access controlreferences/tables-access-permissions.md
IDs and defaultsreferences/tables-auto-increment.md, references/tables-default-values.md
Types and constraintsreferences/tables-column-types.md, references/tables-constraints.md
Index designreferences/tables-indexes.md
Event and schedule tablesreferences/tables-event-tables.md, references/tables-schedule-tables.md
Storage and performancereferences/tables-file-storage.md, references/tables-performance.md

Guidance

  • Check migration implications in spacetimedb-databases before changing existing schemas.
  • Favor indexed lookups for reducer paths that run often or touch large tables.
  • Use event tables for append-only client notifications, especially when replacing reducer result callback patterns.

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-tables">View spacetimedb-tables on skillZs</a>