New: 98,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

DB Formats

by zkldi in 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.

No licenceAuto-check passedDatabases

Install DB Formats

skills CLI
$ npx skills add zkldi/Tachi --skill db-formats -a claude-code

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

GitHub CLI
$ gh skill install zkldi/Tachi db-formats --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/db-formats .claude/skills/db-formats && 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
db-formats
GitHub stars
238
Token cost
~1.3k tokens
SKILL.md length
373 words
Files
1
Skills in repo
5
Repo updated
First seen
Licence
None found

At a glance

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

  • Works in 2 steps: SELECT_* - a const array of… → To*Document - a mapper function that…
  • Writing a new endpoint that reads from a Postgres table
  • SKILL.md covers Why not .selectAll(), The pattern, Using it in an endpoint and v1-MongoDB-compatible mapping…, plus 3 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

DB Formats is an agent skill from 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. Use when writing a new endpoint that reads from a Postgres table, adding a new db-formats file, or when working with Kysely selects that need to return API-compatible (v1-mongodb-like) response shapes.

Its SKILL.md is about 1.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

  • Writing a new endpoint that reads from a Postgres table
  • Adding a new db-formats file
  • Working with Kysely selects that need to return API-compatible (v1-mongodb-like) response shapes

Example prompts

  • “/db-formats”

Workflow steps

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

  1. SELECT_* - a const array of "table.column" strings listing exactly the columns needed
  2. To*Document - a mapper function that converts a typed Kysely row to the matching tachi-common document type

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

    No scripts in the folder and no shell commands in SKILL.md (its code samples are typescript).

    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

DB Formats loads about 1.3k tokens when it runs. Until then it costs about 96 tokens; SKILL.md has 373 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~96
When it runs · the whole SKILL.md, loaded when a task matches
~1.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 373 words (~1,294 tokens).

“.selectAll() is banned in endpoint code because it:”

— opening of SKILL.md by zkldi
name
db-formats

Read the full SKILL.md on GitHub

Files

Just SKILL.md in .cursor/skills/db-formats of zkldi/Tachi.

Open the folder on GitHubat commit e6b34a1

Compare with similar skills

DB Formats 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.

DB Formats compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
DB Formats this skillzkldi/Tachi238—~1.3kAutomated safety check: PassNone
Prisma Database Setupcurvenote/curvenote1703 repos~1.4kAutomated safety check: PassMIT
Rhctlsaidake/rhctl106—~4kAutomated safety check: NotesApache-2.0
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

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

  • Rhctl

    saidake/rhctl

    Run and author rhctl CLI workflows and remote environment scripts under scripts/ (PostgreSQL, JetStream, Docker, Redis, MongoDB, AWS LocalStack, execute/upload/patch).

    106 GitHub stars~4k tokensUpdated 3 days ago
    DatabasesAuto-check: notes

  • 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 18 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 4 days ago
    DatabasesAuto-check: notes

  • Database Domain Specialist

    modu-ai/moai-adk

    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 today
    DatabasesAuto-check passed

More from zkldi/Tachi

  • Actions And Pg Migration

    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.

    238 GitHub stars~2.3k tokensUpdated yesterday
    Auto-check passed

  • 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 yesterday
    Auto-check passed

  • Exhaustive Switch

    zkldi/Tachi

    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 yesterday
    Auto-check passed

  • Preserve Comments

    zkldi/Tachi

    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 yesterday
    Auto-check passed

Works with

Categories

Questions about DB Formats

What does DB Formats do?

Guidance on using db-formats/ column lists (SELECT) and document mappers (ToDocument) instead of selectAll() when writing Postgres-backed endpoints in the Tachi server. DB Formats is an agent skill from 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.

When should I use DB Formats?

DB Formats fits situations like: writing a new endpoint that reads from a Postgres table; adding a new db-formats file; working with Kysely selects that need to return API-compatible (v1-mongodb-like) response shapes.

How do I install DB Formats in Claude Code?

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

How do I install DB Formats in Codex?

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

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

What does DB Formats need to run?

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

Does DB Formats 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 DB Formats 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 DB Formats use?

No licence was found for DB Formats or its repository. Without one, default copyright applies: ask the author before reusing or redistributing it.

How many tokens does DB Formats use?

About 1.3k tokens (SKILL.md is roughly 5.2k 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 DB Formats?

Skills that share tags, products or a category with DB Formats: Prisma Database Setup (curvenote/curvenote, 170 stars), Rhctl (saidake/rhctl, 106 stars), Database Fundamentals (DanielPodolsky/ownyourcode, 290 stars) and Database Expert (cin12211/orca-q, 224 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains DB Formats?

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.