Agent skill

Makemigrations

by deusXmachina-dev in deusXmachina-dev/memorylane

Create SQLite migrations for MemoryLane storage schema changes.

GPL-3.0Auto-check passedDatabases

Install Makemigrations

skills CLI
$ npx skills add deusXmachina-dev/memorylane --skill makemigrations -a claude-code

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

GitHub CLI
$ gh skill install deusXmachina-dev/memorylane makemigrations --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/deusXmachina-dev/memorylane.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.cursor/skills/makemigrations .claude/skills/makemigrations && 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
makemigrations
GitHub stars
121
Token cost
~973 tokens
SKILL.md length
340 words
Files
1
Skills in repo
9
Repo updated
First seen
Licence
GPL-3.0

At a glance

Create SQLite migrations for MemoryLane storage schema changes.

  • Works in 6 steps: Identify schema delta → Create migration file → Implement safe SQL → …
  • Persisted fields change in src/main/storage/index.ts
  • SKILL.md covers Purpose, When to Use, Rules and Workflow, plus 1 more section
  • Calls npm

What it does

Makemigrations is an agent skill from deusXmachina-dev/memorylane. Create SQLite migrations for MemoryLane storage schema changes. Use when interfaces or persisted fields change in src/main/storage/index.ts, when a new column/index/table/trigger is needed, or when the user asks to add a migration similar to 0001initialschema.ts.

Its SKILL.md is about 970 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 Databases. It works with SQLite. The licence is GPL-3.0.

When your agent uses it

  • Persisted fields change in src/main/storage/index.ts
  • A new column/index/table/trigger is needed
  • The user asks to add a migration similar to 0001initialschema.ts

Example prompts

  • “/makemigrations”

Workflow steps

6 steps, taken from the step headings in SKILL.md.

  1. Identify schema delta
  2. Create migration file
  3. Implement safe SQL
  4. Register migration
  5. Tests
  6. Validate

What it can do on your machine

Read from SKILL.md and the folder at commit 16abbe0. 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

    Shell commands in SKILL.md call:

    • npm

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md. Its commands use npm, which can reach the network depending on how they are called.

    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

Makemigrations loads about 973 tokens when it runs. Until then it costs about 70 tokens; SKILL.md has 340 words of instructions outside code blocks.

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

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 deusXmachina-dev/memorylane at commit 16abbe0, republished under its GPL-3.0 licence (© deusXmachina-dev). 340 words, ~973 tokens.

Download SKILL.mdSave it as .claude/skills/makemigrations/SKILL.md (or your agent's skills folder).
name
makemigrations
description
Create SQLite migrations for MemoryLane storage schema changes. Use when interfaces or persisted fields change in src/main/storage/index.ts, when a new column/index/table/trigger is needed, or when the user asks to add a migration similar to 0001_initial_schema.ts.

Create Storage Migration

Purpose

Keep runtime storage schema in sync with src/main/storage/index.ts by adding forward-only migrations in src/main/storage/migrations/.

When to Use

Use this skill when any persisted shape changes, especially:

  • StoredActivity or ActivitySummary field changes in src/main/storage/index.ts
  • SQL statements in StorageService change selected/inserted columns
  • New filters require indexes
  • Legacy table/data needs migration into current tables

Rules

  1. Never edit or reorder existing migration files after they ship.
  2. Always add a new migration with a monotonically increasing 4-digit prefix (0003_*, 0004_*, ...).
  3. Migration must be idempotent where possible (IF EXISTS / IF NOT EXISTS).
  4. Migration must be safe on partially migrated user data.
  5. Register the new migration in src/main/storage/migrations/index.ts.

Workflow

Copy this checklist and execute in order:

text
Migration Progress
- [ ] 1) Identify schema delta from index.ts changes
- [ ] 2) Create next migration file in src/main/storage/migrations/
- [ ] 3) Implement migration.up(db) with safe SQL
- [ ] 4) Register migration in src/main/storage/migrations/index.ts
- [ ] 5) Add/update storage migration tests
- [ ] 6) Run tests and lint for touched files
1) Identify schema delta

Map TypeScript/API changes to SQLite changes:

  • Added persisted field -> ALTER TABLE ... ADD COLUMN (or backfill strategy)
  • Removed field -> usually keep column; stop reading/writing it first, remove later with explicit migration plan
  • Renamed field -> add new column + backfill + dual-read/write strategy if needed
  • New query pattern -> add index
  • New text search shape -> update FTS table/trigger strategy
  • Vector shape/dimension changes -> explicit data migration strategy
2) Create migration file

Name pattern:

  • File: src/main/storage/migrations/000X_descriptive_name.ts
  • Export: export const migration: Migration
  • name must match file stem exactly (example: 0003_add_window_title_index)

Template:

typescript
import Database from 'better-sqlite3'
import type { Migration } from '../migrator'

export const migration: Migration = {
  name: '000X_descriptive_name',
  up(db: Database.Database): void {
    // schema/data updates
  },
}
3) Implement safe SQL

Preferred patterns:

  • db.exec(...) for DDL batches
  • db.prepare(...).run() for parameterized DML
  • Guard checks using sqlite_master when needed
  • Wrap multi-step data migrations in db.transaction(() => { ... })()

For data moves:

  • Use INSERT OR IGNORE where duplicate IDs may exist
  • Backfill defaults for new NOT NULL columns
  • Drop legacy objects only after successful copy
4) Register migration

Update src/main/storage/migrations/index.ts:

  • Add import for the new migration
  • Append to migrations array at the end (preserve order)
5) Tests

Update src/main/storage/storage.test.ts (or related tests) to cover:

  • Fresh DB applies all migrations successfully
  • Existing DB at previous schema upgrades correctly
  • Backfilled/default values are correct
  • Expected indexes/tables/triggers exist after migration
6) Validate

Run relevant checks:

bash
npm test -- src/main/storage/storage.test.ts
npm run lint

If tests are broad or expensive, run targeted tests first, then full suite when requested.

Examples in Repo

  • Baseline schema setup: src/main/storage/migrations/0001_initial_schema.ts
  • Legacy data migration + cleanup: src/main/storage/migrations/0002_migrate_context_events.ts

© deusXmachina-dev, GPL-3.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in .cursor/skills/makemigrations of deusXmachina-dev/memorylane.

Open the folder on GitHubat commit 16abbe0

Compare with similar skills

Makemigrations 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.

Makemigrations compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Makemigrations this skilldeusXmachina-dev/memorylane121—~973Automated safety check: PassGPL-3.0
Iptvnator Sqlite DB Worker4gray/iptvnator7.3k—~824Automated safety check: PassMIT
Analyze Nsys Profilemlc-ai/pith-train355—~1.9kAutomated safety check: PassApache-2.0
Reactive Sqlite UIfastrepl/anarlog9.4k—~699Automated safety check: PassMIT
Composer Forensicsdxos/dxos525—~3.1kAutomated safety check: PassCustom licence
Sqlite Schema Designfastrepl/anarlog9.4k—~1.9kAutomated safety check: PassMIT

Similar skills

  • A skill your agent uses when changing Electron SQLite IPC, database-worker operations, request-scoped progress or cancellation, worker packaging, or runtime verification of non-EPG database work.

    7.3k GitHub stars~824 tokensUpdated today
    DatabasesAuto-check passed
  • Analyze Nsys Profile

    mlc-ai/pith-train

    Query a captured PithTrain Nsight Systems profile to measure compute/communication overlap, locate exposed comm by DualPipeV stage, and inspect per-rank stream behavior.

    355 GitHub stars~1.9k tokensUpdated 3 days ago
    DatabasesAuto-check passed
  • Reactive Sqlite UI

    fastrepl/anarlog

    Build SQLite-backed reactive UI in apps/desktop using stable patterns for reads, selection, forms, writes, and loading states.

    9.4k GitHub stars~699 tokensUpdated today
    DatabasesAuto-check passed
  • Forensically inspect and repair Composer browser profiles — offline (Chrome OPFS / SQLite extract) or live via /recovery.html debug port.

    525 GitHub stars~3.1k tokensUpdated today
    DatabasesAuto-check passed
  • Sqlite Schema Design

    fastrepl/anarlog

    Design or review schemas for crates/cloudsync using SQLite Sync constraints, not generic SQLite advice.

    9.4k GitHub stars~1.9k tokensUpdated today
    DatabasesAuto-check passed
  • Toon

    butttons/dora

    Token-Oriented Object Notation is a compact, human-readable encoding of the JSON data model that minimizes tokens and makes structure easy for models to follow.

    109 GitHub stars~9.4k tokensUpdated 7 mo ago
    DatabasesAuto-check passed

More from deusXmachina-dev/memorylane

All 9 skills in this repo
  • Release

    deusXmachina-dev/memorylane

    Prepare a MemoryLane release by updating the version and release notes, then creating and pushing the tagged release commit that triggers CI.

    121 GitHub stars~982 tokensUpdated today
    Auto-check passed
  • Process Analyst New

    deusXmachina-dev/memorylane

    (new) Find a person's repeated tasks from their screen activity, and what each one is worth automating, with the time and money saved.

    121 GitHub stars~13k tokensUpdated today
    Auto-check: notes
  • Automation Instructions

    deusXmachina-dev/memorylane

    Write step-by-step automation instructions for a workflow, tailored to your tool (Claude, n8n or Zapier).

    121 GitHub stars~1.1k tokensUpdated today
    Auto-check passed
  • Discover Patterns

    deusXmachina-dev/memorylane

    Discover repeated workflow patterns from screen activity and suggest automations

    121 GitHub stars~4.8k tokensUpdated today
    Auto-check passed
  • Last 30 Minutes

    deusXmachina-dev/memorylane

    Summarize what you've been doing in the last 30 minutes. An agent skill from deusXmachina-dev/memorylane.

    121 GitHub stars~696 tokensUpdated today
    Auto-check passed
  • Report New

    deusXmachina-dev/memorylane

    (new) Turn a process analysis into a polished, client-ready report, first an HTML deck you review, then a matching PDF.

    121 GitHub stars~7.9k tokensUpdated today
    Auto-check: notes

Works with

Categories

Questions about Makemigrations

What does Makemigrations do?

Create SQLite migrations for MemoryLane storage schema changes. Makemigrations is an agent skill from deusXmachina-dev/memorylane. Create SQLite migrations for MemoryLane storage schema changes.

When should I use Makemigrations?

Makemigrations fits situations like: persisted fields change in src/main/storage/index.ts; A new column/index/table/trigger is needed; the user asks to add a migration similar to 0001initialschema.ts.

How do I install Makemigrations in Claude Code?

Run `npx skills add deusXmachina-dev/memorylane --skill makemigrations -a claude-code`. Or copy the skill folder (.cursor/skills/makemigrations in deusXmachina-dev/memorylane) into .claude/skills/makemigrations in your project. Claude Code loads it when a task matches its description.

How do I install Makemigrations in Codex?

Run `npx skills add deusXmachina-dev/memorylane --skill makemigrations -a codex`. Or copy the skill folder (.cursor/skills/makemigrations in deusXmachina-dev/memorylane) into .agents/skills/makemigrations in your project. Codex loads it when a task matches its description.

Can I use Makemigrations 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 deusXmachina-dev/memorylane --skill makemigrations -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/makemigrations, .gemini/skills/makemigrations, .github/skills/makemigrations and .opencode/skills/makemigrations in your project.

What does Makemigrations need to run?

Going by SKILL.md and its folder, Makemigrations needs the command-line tools its instructions call (npm).

Does Makemigrations access the network?

SKILL.md contains no URLs. Its commands use npm, which can reach the network depending on how they are called. This is read from the text; nothing was executed.

Is Makemigrations 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 Makemigrations use?

Makemigrations is published under the GPL-3.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Makemigrations use?

About 973 tokens (SKILL.md is roughly 3.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 Makemigrations?

Skills that share tags, products or a category with Makemigrations: Iptvnator Sqlite DB Worker (4gray/iptvnator, 7.3k stars), Analyze Nsys Profile (mlc-ai/pith-train, 355 stars), Reactive Sqlite UI (fastrepl/anarlog, 9.4k stars) and Composer Forensics (dxos/dxos, 525 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Makemigrations?

deusXmachina-dev (a GitHub organization) maintains it in deusXmachina-dev/memorylane, which has 121 GitHub stars. The repository holds 9 skills in this directory. The repository was last updated on October 6, 2026.

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