Configuring Horizon
coollabsio/coolify
A skill your agent uses whenever the user mentions Horizon by name in a Laravel context.
Core architecture invariants for Celeriant. An agent skill from celeriant/celeriant-db.
$ npx skills add celeriant/celeriant-db --skill database-architecture -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install celeriant/celeriant-db database-architecture --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/celeriant/celeriant-db.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.claude/skills/database-architecture .claude/skills/database-architecture && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "database-architecture" agent skill from https://github.com/celeriant/celeriant-db/tree/main/.claude/skills/database-architecture into .claude/skills/database-architecture/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-architecture", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/celeriant/celeriant-db/tree/main/.claude/skills/database-architectureType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add celeriant/celeriant-db --skill database-architecture -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install celeriant/celeriant-db database-architecture --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/celeriant/celeriant-db.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.claude/skills/database-architecture .agents/skills/database-architecture && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "database-architecture" agent skill from https://github.com/celeriant/celeriant-db/tree/main/.claude/skills/database-architecture into .agents/skills/database-architecture/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-architecture", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add celeriant/celeriant-db --skill database-architecture -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install celeriant/celeriant-db database-architecture --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/celeriant/celeriant-db.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.claude/skills/database-architecture .cursor/skills/database-architecture && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "database-architecture" agent skill from https://github.com/celeriant/celeriant-db/tree/main/.claude/skills/database-architecture into .cursor/skills/database-architecture/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-architecture", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/celeriant/celeriant-db.git --path .claude/skills/database-architecture--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add celeriant/celeriant-db --skill database-architecture -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install celeriant/celeriant-db database-architecture --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/celeriant/celeriant-db.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.claude/skills/database-architecture .gemini/skills/database-architecture && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "database-architecture" agent skill from https://github.com/celeriant/celeriant-db/tree/main/.claude/skills/database-architecture into .gemini/skills/database-architecture/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-architecture", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install celeriant/celeriant-db database-architectureInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add celeriant/celeriant-db --skill database-architecture -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/celeriant/celeriant-db.git skills-src && mkdir -p .github/skills && cp -r skills-src/.claude/skills/database-architecture .github/skills/database-architecture && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "database-architecture" agent skill from https://github.com/celeriant/celeriant-db/tree/main/.claude/skills/database-architecture into .github/skills/database-architecture/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-architecture", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add celeriant/celeriant-db --skill database-architecture -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install celeriant/celeriant-db database-architecture --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/celeriant/celeriant-db.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.claude/skills/database-architecture .opencode/skills/database-architecture && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "database-architecture" agent skill from https://github.com/celeriant/celeriant-db/tree/main/.claude/skills/database-architecture into .opencode/skills/database-architecture/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-architecture", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
database-architectureCore architecture invariants for Celeriant. An agent skill from celeriant/celeriant-db.
Database Architecture is an agent skill from celeriant/celeriant-db. Core architecture invariants for Celeriant. Memory bounds, WAL durability, write pipeline, storage layout, and tracing rules. Use when implementing features, reviewing code, or understanding why patterns exist.
Its SKILL.md is about 1.5k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.
It sits in Backend & APIs. The repository describes itself as: Fast, distributed per-aggregate event log with strict ordering and optimistic concurrency control. The licence is Apache-2.0.
Read from SKILL.md and the folder at commit d071a6d. It shows what the files ask for, not the result of running them.
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
No scripts in the folder and no shell commands in SKILL.md.
From the folder's file list and the shell code blocks in SKILL.md.
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Database Architecture loads about 1.5k tokens when it runs. Until then it costs about 58 tokens; SKILL.md has 745 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
The full file from celeriant/celeriant-db at commit d071a6d, republished under its Apache-2.0 licence (© celeriant). 745 words, ~1,458 tokens.
.claude/skills/database-architecture/SKILL.md (or your agent's skills folder).Celeriant supports millions of aggregates per shard. No data structure grows proportional to cardinality.
All long-lived caches use LruCache with byte-based capacity derived from a per-shard memory budget. Total memory = detected_memory * CELERIANT_MEMORY_CONSUMPTION_PERCENT / 100 (default 80%, respects cgroup limits). Divided equally across shards, then split into fixed ratios: recent_write 71.5%, aggregate_snapshots 9%, client_snapshots 9%, schema_cache 9%, WAL sequence 1.5%.
Scan pollution prevention: entries from WAL scans insert at low priority, only into spare capacity, immediately demoted to LRU tail. A list operation can't flush the hot working set.
Intentionally unbounded exceptions: pending_append_queue and aggregate_queue_positions are transient in-flight state that drains every fsync cycle (milliseconds). pending_replication_batches is bounded indirectly by pending_replication_high_water_bytes triggering S3 fallback.
Periodically shrink collections that grew temporarily - shrink_to_fit() when capacity > 2x length.
queue -> fsync (amortised) -> replication (amortised) -> ACK
Multiple concurrent writers coalesce into a single fsync, then a single replication round. Under low load, the fast path executes immediately. Under high load, delay-based batching kicks in. One fsync and one TCP round-trip can serve hundreds of writers.
The fsync coordinator's two phases: capture snapshot first, then clear queue. This ordering prevents a race where a new leader finds an empty queue.
Never acknowledge a write before it's durable. The disk write order within a single fsync: datablocks first (offsets known), metablocks (referencing those offsets), dual headers, then fdatasync(). In-memory state updates only after fsync succeeds.
Both primary header (offset 0) and backup header (end of file) are written on every fsync. If the primary is corrupt on recovery, the backup is used. CRC32C validates before deserialisation.
All I/O uses Direct I/O (O_DIRECT via glommio DmaFile). Bypasses the kernel page cache entirely. Buffered I/O is vulnerable to silent data loss on fsync failure. DMA writes aligned to 4096 bytes, with carry-over buffers for unaligned datablock positions.
Replication is synchronous. Client gets an ACK only after both leader and follower have fsynced. If replication fails (follower and S3 both down), rollback fires: revert write cursor to read cursor, clear all un-replicated in-memory state, rewrite headers at rolled-back positions, fsync. Durable before any new writes.
File layout: [Header 512KB] [Metablocks growing down ->] [Free space] [<- Datablocks growing up] [Header 512KB].
Metablocks are fixed 1024 bytes. Datablocks grow backwards from the bottom. File rotates when they meet. Log segments are preallocated at creation (minimum 1.5MB).
Small events (<= 512 bytes serialised) live inline in the metablock itself, avoiding a separate disk seek. Auto-selected transparently.
Each segment carries a 256KB bloom filter (10 hashes, <1% FP at 200k aggregates). The reverse WAL scanner skips entire segments with a single bloom check. This is how unlimited cardinality works without unlimited index memory.
The small-metablock compile-time feature halves metablock size (1024 -> 512 bytes) and inline threshold (512 -> 128 bytes). Affects the on-disk format and replication wire format only. Client request/response protocol is unaffected. Both cluster nodes must be compiled with the same setting.
Two separate LRU caches: write snapshots (updated after fsync, used for OCC/idempotency) and read snapshots (updated after replication on leader, used by reads). On leader, writes are invisible to readers until replication completes.
Recent write cache entries carry WAL sequence. Reads filter by visible_wal_seq, excluding un-replicated data. The hot cache can hold speculative data without leaking it.
Read operations are never rejected based on node status. A fenced or catching-up node serves stale reads silently.
OCC checks use the write-ahead snapshot, not the read snapshot. A write fsynced but not yet replicated still triggers OCC conflict.
Check ordering matters: OCC first, then idempotency. If OCC fails, client retries with fresh state. If OCC passes but idempotency fails, the exact write already landed (crash recovery scenario, treat as success). Reversing this order creates false-positive "already landed" results from concurrent writers that use the same client event index source.
No info! or debug! in hot paths. This generates gigabytes of logs and degrades performance.
error!: unrecoverable failures, data integrity issues (fsync failure, corruption)warn!: recoverable issues (client disconnect, timeout, retry)info!: startup, shutdown, configuration, rare eventstrace!: per-request detail, disabled by defaultUse structured fields (aggregate_key = ?key, error = %err, "Write failed") not string interpolation.
Every new metric must get a describe_counter!/describe_gauge!/describe_histogram! line in register_metric_descriptions() at celeriant_runtimes/src/sidecar/metrics_server.rs. Prometheus exposes the metric without it, but the /metrics HELP text — and Grafana's tooltips/autocomplete — go missing. This is the single source of truth for what the cluster ships; if a metric is fired anywhere, it has a line here.
© celeriant, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Just SKILL.md in .claude/skills/database-architecture of celeriant/celeriant-db.
Open the folder on GitHubat commit d071a6d
Database Architecture next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Database Architecture this skillceleriant/celeriant-db | 114 | — | ~1.5k | Automated safety check: Pass | Apache-2.0 | |
| Configuring Horizoncoollabsio/coolify | 63k | 4 repos | ~898 | Automated safety check: Pass | MIT | |
| Nestjs Best Practicesrolling-scopes/rsschool-app | 10k | 6 repos | ~1.2k | Automated safety check: Pass | MIT | |
| Sub2API AdminWei-Shaw/sub2api | 43k | 1 repos | ~717 | Automated safety check: Pass | LGPL-3.0 | |
| Firecrawl Build Onboardingfirecrawl/firecrawl | 189k | 1 repos | ~1.4k | Automated safety check: Notes | ISC | |
| Obsidian BasesAtmosphere/atmosphere | 3.8k | 22 repos | ~3.2k | Automated safety check: Pass | Apache-2.0 |
coollabsio/coolify
A skill your agent uses whenever the user mentions Horizon by name in a Laravel context.
rolling-scopes/rsschool-app
NestJS best practices and architecture patterns for building production-ready applications.
Wei-Shaw/sub2api
Manages a Sub2API deployment from the command line: accounts, redeem and invitation codes, groups, proxies, imports, exports and raw admin API calls.
firecrawl/firecrawl
Gets Firecrawl working in a project: signs you in through the browser, saves FIRECRAWL_API_KEY to .env and picks the first SDK or REST path.
Atmosphere/atmosphere
Create and edit Obsidian Bases (.base files) with views, filters, formulas, and summaries.
coollabsio/coolify
ACTIVATE when the user works on authentication in Laravel. An agent skill from coollabsio/coolify.
celeriant/celeriant-db
Error handling patterns in Celeriant. An agent skill from celeriant/celeriant-db.
celeriant/celeriant-db
How to write and run tests in Celeriant. An agent skill from celeriant/celeriant-db.
celeriant/celeriant-db
Celeriant codebase architecture, crate responsibilities, and how they fit together.
celeriant/celeriant-db
Refactor a named Rust type or its surrounding code with an agreed scope.
celeriant/celeriant-db
Celeriant's client-server protocol invariants, network behavior, failure modes, and shard routing.
celeriant/celeriant-db
Locking patterns for Glommio's single-threaded async executors.
Categories
Core architecture invariants for Celeriant. An agent skill from celeriant/celeriant-db. Database Architecture is an agent skill from celeriant/celeriant-db. Core architecture invariants for Celeriant.
Database Architecture fits situations like: implementing features; understanding why patterns exist.
Run `npx skills add celeriant/celeriant-db --skill database-architecture -a claude-code`. Or copy the skill folder (.claude/skills/database-architecture in celeriant/celeriant-db) into .claude/skills/database-architecture in your project. Claude Code loads it when a task matches its description.
Run `npx skills add celeriant/celeriant-db --skill database-architecture -a codex`. Or copy the skill folder (.claude/skills/database-architecture in celeriant/celeriant-db) into .agents/skills/database-architecture in your project. Codex loads it when a task matches its description.
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add celeriant/celeriant-db --skill database-architecture -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/database-architecture, .gemini/skills/database-architecture, .github/skills/database-architecture and .opencode/skills/database-architecture in your project.
SKILL.md names no scripts, command-line tools or credentials: Database Architecture is instructions for the agent only.
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
Database Architecture is published under the Apache-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
About 1.5k tokens (SKILL.md is roughly 5.8k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
Skills that share tags, products or a category with Database Architecture: Configuring Horizon (coollabsio/coolify, 63k stars), Nestjs Best Practices (rolling-scopes/rsschool-app, 10k stars), Sub2API Admin (Wei-Shaw/sub2api, 43k stars) and Firecrawl Build Onboarding (firecrawl/firecrawl, 189k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
celeriant (a GitHub organization) maintains it in celeriant/celeriant-db, which has 114 GitHub stars. The repository holds 13 skills in this directory. The repository was last updated on September 28, 2026.
Source: celeriant/celeriant-db on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.