New: 97,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Agent skill

Sqlite Minimal Persistence

by muratgur in muratgur/ordinus

Extend Ordinus SQLite persistence conservatively. An agent skill from muratgur/ordinus.

MITAuto-check passedDatabases

Install Sqlite Minimal Persistence

skills CLI
$ npx skills add muratgur/ordinus --skill sqlite-minimal-persistence -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install muratgur/ordinus sqlite-minimal-persistence --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/muratgur/ordinus.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.codex/skills/sqlite-minimal-persistence .claude/skills/sqlite-minimal-persistence && rm -rf skills-src

Use ~/.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/

Facts

Skill name
sqlite-minimal-persistence
GitHub stars
109
Token cost
~480 tokens
SKILL.md length
234 words
Files
2
Skills in repo
7
Repo updated
First seen
Licence
MIT

At a glance

Extend Ordinus SQLite persistence conservatively. An agent skill from muratgur/ordinus.

  • Works in 7 steps: Confirm the requested behavior truly… → Check whether existing app_meta or… → If a table is necessary, define the… → …
  • Touching better-sqlite3
  • SKILL.md covers Objective, Current Policy, Workflow and Design Guidance, plus 1 more section
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Sqlite Minimal Persistence is an agent skill from muratgur/ordinus. Extend Ordinus SQLite persistence conservatively. Use when touching better-sqlite3, Drizzle schema, database bootstrap, appmeta, migrations, durable state, persistence boundaries, or proposals to add new product tables.

Its SKILL.md is about 480 tokens, which your agent loads only when the skill is triggered. The skill folder holds 2 other files (for example `agents/openai.yaml`).

It sits in Databases, covering ORMs and data access, Agent memory and Proposals and quotes. It works with SQLite. The repository describes itself as: Your local-first command center for working with AI agents like a real team. The licence is MIT.

When your agent uses it

  • Touching better-sqlite3
  • Database bootstrap
  • Persistence boundaries
  • Proposals to add new product tables

Example prompts

  • “/sqlite-minimal-persistence”

Workflow steps

7 steps, taken from the first numbered list in SKILL.md.

  1. Confirm the requested behavior truly needs persistence.
  2. Check whether existing app_meta or settings-level storage is sufficient.
  3. If a table is necessary, define the smallest schema that supports the current behavior.
  4. Add Drizzle schema and bootstrap/migration logic together.
  5. Keep data access behind main-process services.
  6. Update db.getStatus only if the status surface needs to show new bootstrap information.
  7. Run typecheck, lint, build, and a runtime smoke test that opens the app.

What it can do on your machine

Read from SKILL.md and the folder at commit c27f289. It shows what the files ask for, not the result of running them.

  • Tool permissions

    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.

  • Runs code

    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.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Sqlite Minimal Persistence loads about 480 tokens when it runs. Until then it costs about 62 tokens; SKILL.md has 234 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~62
When it runs · the whole SKILL.md, loaded when a task matches
~480

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.

Safety

Auto-check passed

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.

SKILL.md

The full file from muratgur/ordinus at commit c27f289, republished under its MIT licence (© muratgur). 234 words, ~480 tokens.

Download SKILL.mdSave it as .claude/skills/sqlite-minimal-persistence/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.
name
sqlite-minimal-persistence
description
Extend Ordinus SQLite persistence conservatively. Use when touching better-sqlite3, Drizzle schema, database bootstrap, app_meta, migrations, durable state, persistence boundaries, or proposals to add new product tables.

SQLite Minimal Persistence

Objective

Use SQLite as durable local app state without designing product tables before the workflow model is clear.

Current Policy

  • The minimum database starts with app_meta.
  • Add new tables only when the product behavior needs durable state now.
  • Avoid adding agent, task, provider, schedule, inbox, or run schemas speculatively.
  • Keep secrets out of ordinary product tables unless a secure storage decision has been made.
  • Treat SQLite as main-process owned. Renderer must access state only through typed IPC.

Workflow

  1. Confirm the requested behavior truly needs persistence.
  2. Check whether existing app_meta or settings-level storage is sufficient.
  3. If a table is necessary, define the smallest schema that supports the current behavior.
  4. Add Drizzle schema and bootstrap/migration logic together.
  5. Keep data access behind main-process services.
  6. Update db.getStatus only if the status surface needs to show new bootstrap information.
  7. Run typecheck, lint, build, and a runtime smoke test that opens the app.

Design Guidance

  • Prefer durable state for user-visible history, resumable work, and app configuration.
  • Prefer filesystem storage for large artifacts and generated files, with database metadata later when needed.
  • Prefer explicit timestamps and schema versioning for local migrations.
  • Keep schema names product-oriented and stable.

Red Flags

  • A table is added because a future module might need it.
  • Renderer imports database code.
  • Database writes are mixed into UI event handlers.
  • Migration behavior is not exercised by opening the app.

© muratgur, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 1 other file in .codex/skills/sqlite-minimal-persistence of muratgur/ordinus.

  • SKILL.md
  • agents/openai.yaml

Open the folder on GitHubat commit c27f289

Compare with similar skills

Sqlite Minimal Persistence 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.

Sqlite Minimal Persistence compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Sqlite Minimal Persistence this skillmuratgur/ordinus109—~480Automated safety check: PassMIT
Add Memory KindEverMind-AI/EverOS13k—~2.6kAutomated safety check: PassApache-2.0
Better Drizzlealmeidazs/better-drizzle347—~1.7kAutomated safety check: PassApache-2.0
Prisma Database Setupcurvenote/curvenote1693 repos~1.4kAutomated safety check: PassMIT
Create Auth Skilldeadlock-mod-manager/deadlock-mod-manager4734 repos~3.4kAutomated safety check: PassGPL-3.0
Drizzle Migrationsbretzel-app/crumbs1271 repos~2.6kAutomated safety check: PassMIT

Similar skills

  • Add Memory Kind

    EverMind-AI/EverOS

    Walks through adding a new persisted memory kind to EverOS: choose storage among Markdown, SQLite and LanceDB, pick a Markdown strategy, then wire schemas, repos and writers.

    13k GitHub stars~2.6k tokensUpdated yesterday
    DatabasesAuto-check passed

  • Better Drizzle

    almeidazs/better-drizzle

    Write, review, and debug code that uses better-drizzle, the typed repository layer over Drizzle ORM 1.x (better(db), client.users.findMany, paginate, cursor, upsertMany, relation include/connect…

    347 GitHub stars~1.7k tokensUpdated 2 days ago
    DatabasesAuto-check passed

  • Prisma Database Setup

    curvenote/curvenote

    Guides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, MongoDB, etc.).

    169 GitHub starsUsed in 3 repos~1.4k tokens
    DatabasesAuto-check passed

  • Create Auth Skill

    deadlock-mod-manager/deadlock-mod-manager

    Scaffold and implement authentication in TypeScript/JavaScript apps using Better Auth.

    473 GitHub starsUsed in 4 repos~3.4k tokens
    DatabasesAuto-check passed

  • Drizzle Migrations

    bretzel-app/crumbs

    Drizzle ORM schema management and SQLite migrations — adding tables, modifying columns, creating indexes, generating and running migrations, Drizzle query patterns.

    127 GitHub starsUsed in 1 repo~2.6k tokens
    DatabasesAuto-check passed

  • Database Expert

    cin12211/orca-q

    Database performance optimization, schema design, query analysis, and connection management across PostgreSQL, MySQL, MongoDB, and SQLite with ORM integration.

    223 GitHub stars~2.8k tokensUpdated 16 days ago
    DatabasesAuto-check passed

More from muratgur/ordinus

  • Shadcn Project Workflow

    muratgur/ordinus

    Work with shadcn/ui in Ordinus. An agent skill from muratgur/ordinus.

    109 GitHub stars~859 tokensUpdated 1 mo ago
    Auto-check passed

  • Electron Secure Boundary

    muratgur/ordinus

    Maintain Ordinus Electron security boundaries. An agent skill from muratgur/ordinus.

    109 GitHub stars~523 tokensUpdated 1 mo ago
    Auto-check passed

  • Ipc Contract Design

    muratgur/ordinus

    Design and maintain Ordinus typed IPC contracts. An agent skill from muratgur/ordinus.

    109 GitHub stars~509 tokensUpdated 1 mo ago
    Auto-check passed

  • Ordinus UI System

    muratgur/ordinus

    Build Ordinus renderer UI in the intended product style. An agent skill from muratgur/ordinus.

    109 GitHub stars~881 tokensUpdated 1 mo ago
    Auto-check passed

  • Provider Runtime Adapter

    muratgur/ordinus

    Design Ordinus provider runtime adapters for local AI CLIs. An agent skill from muratgur/ordinus.

    109 GitHub stars~587 tokensUpdated 1 mo ago
    Auto-check passed

  • Idea Discovery

    muratgur/ordinus

    Explore a new feature, product idea, technical design, workflow change, or ADR candidate before committing to an implementation plan.

    109 GitHub stars~851 tokensUpdated 1 mo ago
    Auto-check passed

Works with

Categories

Questions about Sqlite Minimal Persistence

What does Sqlite Minimal Persistence do?

Extend Ordinus SQLite persistence conservatively. An agent skill from muratgur/ordinus. Sqlite Minimal Persistence is an agent skill from muratgur/ordinus. Extend Ordinus SQLite persistence conservatively.

When should I use Sqlite Minimal Persistence?

Sqlite Minimal Persistence fits situations like: touching better-sqlite3; database bootstrap; persistence boundaries; proposals to add new product tables.

How do I install Sqlite Minimal Persistence in Claude Code?

Run `npx skills add muratgur/ordinus --skill sqlite-minimal-persistence -a claude-code`. Or copy the skill folder (.codex/skills/sqlite-minimal-persistence in muratgur/ordinus) into .claude/skills/sqlite-minimal-persistence in your project. Claude Code loads it when a task matches its description.

How do I install Sqlite Minimal Persistence in Codex?

Run `npx skills add muratgur/ordinus --skill sqlite-minimal-persistence -a codex`. Or copy the skill folder (.codex/skills/sqlite-minimal-persistence in muratgur/ordinus) into .agents/skills/sqlite-minimal-persistence in your project. Codex loads it when a task matches its description.

Can I use Sqlite Minimal Persistence in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add muratgur/ordinus --skill sqlite-minimal-persistence -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/sqlite-minimal-persistence, .gemini/skills/sqlite-minimal-persistence, .github/skills/sqlite-minimal-persistence and .opencode/skills/sqlite-minimal-persistence in your project.

What does Sqlite Minimal Persistence need to run?

SKILL.md names no scripts, command-line tools or credentials: Sqlite Minimal Persistence is instructions for the agent only.

Does Sqlite Minimal Persistence access the network?

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.

Is Sqlite Minimal Persistence safe to install?

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.

What licence does Sqlite Minimal Persistence use?

Sqlite Minimal Persistence is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Sqlite Minimal Persistence use?

About 480 tokens (SKILL.md is roughly 1.9k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Sqlite Minimal Persistence?

Skills that share tags, products or a category with Sqlite Minimal Persistence: Add Memory Kind (EverMind-AI/EverOS, 13k stars), Better Drizzle (almeidazs/better-drizzle, 347 stars), Prisma Database Setup (curvenote/curvenote, 169 stars) and Create Auth Skill (deadlock-mod-manager/deadlock-mod-manager, 473 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Sqlite Minimal Persistence?

muratgur (a GitHub user) maintains it in muratgur/ordinus, which has 109 GitHub stars. The repository holds 7 skills in this directory. The repository was last updated on September 3, 2026.

Source: muratgur/ordinus on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.