Agent skill

Actions And Pg Migration

by zkldi in zkldi/Tachi

Patterns for writing actions (MakeAction/MakeAnonAction), using the Postgres DB (Kysely), and migrating Express routes from MongoDB to Postgres in the Tachi server.

No licenceAuto-check passedDatabases

Install Actions And Pg Migration

skills CLI
$ npx skills add zkldi/Tachi --skill actions-and-pg-migration -a claude-code

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

GitHub CLI
$ gh skill install zkldi/Tachi actions-and-pg-migration --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/zkldi/Tachi.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.cursor/skills/actions-and-pg-migration .claude/skills/actions-and-pg-migration && 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
actions-and-pg-migration
GitHub stars
238
Token cost
~2.3k tokens
SKILL.md length
418 words
Files
1
Skills in repo
5
Repo updated
First seen
Licence
None found

At a glance

Patterns for writing actions (MakeAction/MakeAnonAction), using the Postgres DB (Kysely), and migrating Express routes from MongoDB to Postgres in the Tachi server.

  • Works in 7 steps: Identify Mongo collections → find the… → Reads - replace… → Mutations - extract each write operation… → …
  • Adding a new mutation
  • SKILL.md covers Actions, Postgres / Kysely, Migrating a Mongo-backed… and Testing
  • Calls bun

What it does

Actions And Pg Migration is an agent skill from zkldi/Tachi. Patterns for writing actions (MakeAction/MakeAnonAction), using the Postgres DB (Kysely), and migrating Express routes from MongoDB to Postgres in the Tachi server. Use when adding a new mutation, migrating a Mongo-backed router to Postgres, writing action files, or writing tests for actions or routers.

Its SKILL.md is about 2.3k 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, covering NoSQL databases. It works with PostgreSQL and MongoDB. The repository describes itself as: A Cutting-Edge, Modular Score Tracker.

When your agent uses it

  • Adding a new mutation
  • Migrating a Mongo-backed router to Postgres
  • Writing action files
  • Writing tests for actions

Example prompts

  • “Use the actions-and-pg-migration skill to pattern for writing actions (MakeAction/MakeAnonAction), using the Postgres DB (Kysely), and migrating…”
  • “/actions-and-pg-migration”

Workflow steps

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

  1. Identify Mongo collections → find the equivalent priv_* Postgres table.
  2. Reads - replace MONGODB_KILL["collection"].find/findOne() with Kysely selects. Use the existing SELECT_* + To*Document helpers from…
  3. Mutations - extract each write operation into a MakeAction-wrapped file in src/actions/. Add its signature to ActionSignatures in…
  4. Middleware - update any middleware that does Mongo lookups (e.g. GetClientFromID) to use a query helper or direct Kysely query.
  5. Remove Mongo import - MONGODB_KILL should be gone from the file.
  6. Ownership checks - move them inside the action (taker.acct.id === row.author) rather than in Express middleware, so the action is…
  7. Error handler - throw ExpectedErr instead of returning early; no try/catch in routes needed.

What it can do on your machine

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

    • bun

    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

Actions And Pg Migration loads about 2.3k tokens when it runs. Until then it costs about 82 tokens; SKILL.md has 418 words of instructions outside code blocks.

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

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

Without a licence we can't republish the file, so here is its outline and opening line. It has 418 words (~2,275 tokens).

“All action input/output schemas live in src/lib/actions/actions.ts. Add a new entry to ActionSignatures (for authenticated actions) or AnonActionSignatures (for unauthenticated ones):”

— opening of SKILL.md by zkldi
name
actions-and-pg-migration

Read the full SKILL.md on GitHub

Files

Just SKILL.md in .cursor/skills/actions-and-pg-migration of zkldi/Tachi.

Open the folder on GitHubat commit e6b34a1

Compare with similar skills

Actions And Pg Migration 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.

Actions And Pg Migration compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Actions And Pg Migration this skillzkldi/Tachi238—~2.3kAutomated safety check: PassNone
Prisma Database Setupcurvenote/curvenote1703 repos~1.4kAutomated safety check: PassMIT
Database FundamentalsDanielPodolsky/ownyourcode2901 repos~1.6kAutomated safety check: PassMIT
Database Expertcin12211/orca-q224—~2.8kAutomated safety check: PassMIT
DB SculptorEliasOulkadi/shokunin114—~3.1kAutomated safety check: NotesMIT
Database Domain Specialistmodu-ai/moai-adk1.2k—~2.8kAutomated safety check: PassApache-2.0

Similar skills

  • Prisma Database Setup

    curvenote/curvenote

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

    170 GitHub starsUsed in 3 repos~1.4k tokens
    DatabasesAuto-check passed
  • Database Fundamentals

    DanielPodolsky/ownyourcode

    Reviews schema design, SQL queries, ORM patterns. An agent skill from DanielPodolsky/ownyourcode.

    290 GitHub starsUsed in 1 repo~1.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.

    224 GitHub stars~2.8k tokensUpdated 19 days ago
    DatabasesAuto-check passed
  • DB Sculptor

    EliasOulkadi/shokunin

    Design database schemas with Prisma/Drizzle, PostgreSQL index strategy (B-tree, GIN, GiST, BRIN, Hash), query optimization (EXPLAIN ANALYZE), migration safety (expand/contract, zero-downtime), and…

    114 GitHub stars~3.1k tokensUpdated 5 days ago
    DatabasesAuto-check: notes
  • Database guidance for PostgreSQL, MongoDB, Redis and Oracle plus Neon, Supabase and Firestore: schema design, indexing, query tuning and cloud database choice.

    1.2k GitHub stars~2.8k tokensUpdated yesterday
    DatabasesAuto-check passed
  • Cosmosdb Best Practices

    microsoft/vscode-cosmosdb

    Official

    Azure Cosmos DB performance optimization and best practices guidelines for NoSQL, partitioning, queries, and SDK usage.

    200 GitHub stars~4.3k tokensUpdated today
    DatabasesAuto-check passed

More from zkldi/Tachi

  • Coverage Tools

    zkldi/Tachi

    Aggregates Vitest v8/Istanbul coverage across Tachi workspaces via tachi-coverage-tools (manifest, CLI, optional programmatic API).

    238 GitHub stars~580 tokensUpdated 2 days ago
    Auto-check passed
  • DB Formats

    zkldi/Tachi

    Guidance on using db-formats/ column lists (SELECT) and document mappers (ToDocument) instead of selectAll() when writing Postgres-backed endpoints in the Tachi server.

    238 GitHub stars~1.3k tokensUpdated 2 days ago
    Auto-check passed
  • Prefer staticAssertUnreachable in the default branch of switches that must cover every variant of a union, so exhaustiveness is checked at compile time.

    238 GitHub stars~625 tokensUpdated 2 days ago
    Auto-check passed
  • Preserves existing code comments (line, block, JSDoc, region markers) when editing files; does not delete or collapse comments for brevity unless the user asked to remove or update them.

    238 GitHub stars~399 tokensUpdated 2 days ago
    Auto-check passed

Categories

Questions about Actions And Pg Migration

What does Actions And Pg Migration do?

Patterns for writing actions (MakeAction/MakeAnonAction), using the Postgres DB (Kysely), and migrating Express routes from MongoDB to Postgres in the Tachi server. Actions And Pg Migration is an agent skill from zkldi/Tachi. Patterns for writing actions (MakeAction/MakeAnonAction), using the Postgres DB (Kysely), and migrating Express routes from MongoDB to Postgres in the Tachi server.

When should I use Actions And Pg Migration?

Actions And Pg Migration fits situations like: adding a new mutation; migrating a Mongo-backed router to Postgres; writing action files; writing tests for actions.

How do I install Actions And Pg Migration in Claude Code?

Run `npx skills add zkldi/Tachi --skill actions-and-pg-migration -a claude-code`. Or copy the skill folder (.cursor/skills/actions-and-pg-migration in zkldi/Tachi) into .claude/skills/actions-and-pg-migration in your project. Claude Code loads it when a task matches its description.

How do I install Actions And Pg Migration in Codex?

Run `npx skills add zkldi/Tachi --skill actions-and-pg-migration -a codex`. Or copy the skill folder (.cursor/skills/actions-and-pg-migration in zkldi/Tachi) into .agents/skills/actions-and-pg-migration in your project. Codex loads it when a task matches its description.

Can I use Actions And Pg Migration 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 zkldi/Tachi --skill actions-and-pg-migration -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/actions-and-pg-migration, .gemini/skills/actions-and-pg-migration, .github/skills/actions-and-pg-migration and .opencode/skills/actions-and-pg-migration in your project.

What does Actions And Pg Migration need to run?

Going by SKILL.md and its folder, Actions And Pg Migration needs the command-line tools its instructions call (bun).

Does Actions And Pg Migration 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 Actions And Pg Migration 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 Actions And Pg Migration use?

No licence was found for Actions And Pg Migration or its repository. Without one, default copyright applies: ask the author before reusing or redistributing it.

How many tokens does Actions And Pg Migration use?

About 2.3k tokens (SKILL.md is roughly 9.1k 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 Actions And Pg Migration?

Skills that share tags, products or a category with Actions And Pg Migration: Prisma Database Setup (curvenote/curvenote, 170 stars), Database Fundamentals (DanielPodolsky/ownyourcode, 290 stars), Database Expert (cin12211/orca-q, 224 stars) and DB Sculptor (EliasOulkadi/shokunin, 114 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Actions And Pg Migration?

zkldi (a GitHub user) maintains it in zkldi/Tachi, which has 238 GitHub stars. The repository holds 5 skills in this directory. The repository was last updated on October 8, 2026.

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