database-skill

database-skill is a skill for Claude Code, Codex from jiushiwon/wg-skills. It costs 0 tokens per session (848 once invoked), scanned A, original, Apache-2.0.

A database planning guide for backend projects. It helps choose PostgreSQL, MySQL, MongoDB, or selected time-series databases, then defines table naming, initial data structures, and production migrations.

In plain words
What is it for?
Use it when selecting a database, designing tables or collections, setting table prefixes, defining core entities, configuring connection variables, or choosing a migration tool.
Why use it?
It makes database decisions consistent and records them where the generated project can use them. It also sets rules for safe schema changes, including migration files that can be rolled back.

Skill for Claude CodeCodex

Written for no agent in particular: nothing here depends on one.

Good fit Use it when selecting a database, designing tables or collections, setting table prefixes, defining core entities, configuring connection variables, or choosing a migration tool.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/jiushiwon/wg-skills/database-skill
Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent
npx skills add jiushiwon/wg-skills --skill database-skill
Clone the repo
git clone --depth 1 https://github.com/jiushiwon/wg-skills

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for database-skill

README.md
[![agentmods](https://agentmods.dev/badge/skills/jiushiwon/wg-skills/database-skill/github.svg)](https://agentmods.dev/skills/jiushiwon/wg-skills/database-skill)
Your own site
<a href="https://agentmods.dev/skills/jiushiwon/wg-skills/database-skill"><img src="https://agentmods.dev/badge/skills/jiushiwon/wg-skills/database-skill/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for database-skill

Your own site · 80×15
<a href="https://agentmods.dev/skills/jiushiwon/wg-skills/database-skill"><img src="https://agentmods.dev/badge/skills/jiushiwon/wg-skills/database-skill.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 0 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 848 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe. Third-party audits
  • NVIDIA SkillSpector pass 7 Sept 2026
How audits are shown
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00000 $0.00848
Opus 5 $0.00000 $0.00424
Sonnet 5 $0.00000 $0.00170
Haiku 4.5 $0.00000 $0.00085

Measured 9d ago against content hash d03f8ecceefd, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-08, from the pricing page.

Security

Grade A, and why

database-skill scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 9d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

vibeCoding/backend/database/database-skill/SKILL.md · 67 lines

What it actually says

Database Skill

为后端生成流程提供数据库选型、表前缀、初始 schema 与迁移规范。被 select 与 4 个后端 skill 引用。

选型

数据特征 推荐 备注
强关系、事务 PostgreSQL 默认首选
团队熟 MySQL MySQL 8 兼容现有团队
文档、灵活模式 MongoDB 仅 Node / Python 栈自动生成;Java / Go 不生成 MongoDB
时序 / 日志 TimescaleDB / InfluxDB 仅用户明确要求时推荐

表前缀

默认 wg(如 wg_user),snake_case;写入 spec.md,落到 entity / migration 名。用户可覆盖。

初始 schema

按核心实体给最小建表/建集合:主键、created_at / updated_at、deleted_at(软删除)、必要唯一索引。关系型用 snake_case 字段,MongoDB 用 camelCase。

交付物落点

本 skill 不生成独立文件,决策结果必须落到两处:

  1. spec.md(选型期):DB 类型、表前缀、核心实体清单、是否需要迁移工具。
  2. 生成项目内(生成期):连接变量按 backend-convention-skill env-config-guide.md 写入 .env.example;库名/前缀/迁移方式写入 docs/project-guide.md 的数据库与拓展段;DDL/迁移文件由后端 skill 按本 skill 规范现场生成。

迁移规范

生产必须显式迁移,迁移文件入库且可回滚。各栈工具:

工具 关键配置
Java Flyway / Liquibase ddl-auto: validate
Python Alembic 已含在依赖
Node TypeORM CLI 生产关 synchronize
Go golang-migrate / goose 开发可 AutoMigrate

详见 references/migration-guide.md

连接覆盖(稳定事实,不腐烂)

PostgreSQL MySQL MongoDB
端口 5432 3306 27017
DB_USER postgres app(官方镜像禁 root 作 MYSQL_USER) -
DB_TYPE postgres / postgresql mysql(Python 用 mysql+pymysql -
镜像 postgres:<ver>-alpine mysql:<ver> mongo:<ver>
DB_URL built from host/port/name jdbc:mysql://host:3306/<db> mongodb://host:27017/<db>

生成 MySQL 项目时用 docker-compose.mysql.yml 改名为 docker-compose.yml

版本获取

镜像版本查官方源:Docker Hub 官方标签页或 https://endoflife.date/api/{postgresql,mysql,mongodb}.json不写死版本号;实际值写入生成项目的 versions.md

不做

  • 不在本 skill 写业务接口。
  • 不替 Java / Go 生成 MongoDB。
  • 不替用户提交。
Files

What ships with it

3 files beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 9d ago First seen · 67 lines · 0 tokens per session scan A d03f8ecceefd

Subscribe to this mod's changes

database-skill is a skill published in the GitHub repository jiushiwon/wg-skills (97 stars, last pushed yesterday), licensed Apache-2.0. It costs nothing until one of its globs matches a file; then it loads 848 tokens. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Related

Other skills, from other repositories

event-store-design

Design and implement event stores for event-sourced systems. Use when building event sourcing infrastructure, choosing event store technologies, or implementing event persistence patterns.

wshobson/agents · 33 tokens

convex-explain-app

Explain an existing Convex app — data model + relationships, public vs internal functions, auth/ownership model, components, a request→data flow — read from the schema and function surface. Read-only.

openclaw/clawhub · 47 tokens

platform-custom-field-generate

Use this skill when users need to create, generate, or validate Salesforce Custom Field metadata. Trigger when users mention custom fields, field types, Roll-up Summary fields, Master-Detail relationships, Lookup relationships, formula fields, picklists, dependent (controlling) picklists, referencing a value set from…

forcedotcom/sf-skills · 194 tokens

openloomi-api

OpenLoomi ships a local-first HTTP API served from the desktop app (port 3414, fallback 3515). All auth, Memory, AI, RAG, Loop, and Audit data live in a local SQLite database — your data stays on your machine and the OpenLoomi app is the source of truth. The only externally-routed auth path is the Composio OAuth…

melandlabs/openloomi · 106 tokens

nornicdb-grpc

Drive NornicDB over gRPC — the Qdrant-compatible surface (Collections, Points, Snapshots) plus the additive NornicSearch service. Use when ingesting via Qdrant SDKs, migrating from Qdrant, or running hybrid text+vector search from a non-Bolt client. Covers connection, RPC catalog, collection→database mapping…

orneryd/NornicDB · 98 tokens

field-service-sobject-create-configure

Headless 360 REST API deployment step for creating sObject records. Handles describe-based field discovery, required-field derivation, entity-relationship ordering, and composite graph transactions. Use this skill when a designer skill (or a user directly) needs to create sObject records after design confirmation…

forcedotcom/sf-skills · 74 tokens