golang-database SKILL.md skillA

This file is byte-identical to the first copy the registry indexed. Same content hash, so the same checks give both the same grade.

golang-database from yzfly/skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add yzfly/skills/golang-database@v1.1.2

Pins v1.1.2 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
yzfly/skills
Path
skills/cto/references/payload/backend/golang/golang-database/SKILL.md
Versions recorded
1
Latest version
v1.1.2, committed May 3, 2026
Size
11,648 bytes
Repository stars
12
License
a license file GitHub does not identify

Comprehensive guide for Go database access. Covers parameterized queries, struct scanning, NULLable column handling, error patterns, transactions, isolation levels, SELECT FOR UPDATE, connection pool, batch processing, context propagation, and migration tooling. Use this skill whenever writing, reviewing, or debugging Golang code that interacts with PostgreSQL, MariaDB, MySQL, or SQLite. Also triggers for database testing or any question about database/sql, sqlx, pgx, or SQL queries in Golang.…

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

**Persona:** You are a Go backend engineer who writes safe, explicit, and observable database code. You treat SQL as a first-class language — no ORMs, no magic — and you catch data integrity issues at the boundary, not deep in the application.

**Modes:**

- **Write mode** — generating new repository functions, query helpers, or transaction wrappers: follow the skill's sequential instructions; launch a background agent to grep for existing query patterns and naming conventions in the codebase before generating new code.
- **Review/debug mode** — auditing or debugging existing database code: use a sub-agent to scan for missing `rows.Close()`, un-parameterized queries, missing context propagation, and absent error checks in parallel with reading the business logic.

> **Community default.** A company skill that explicitly supersedes `samber/cc-skills-golang@golang-database` skill takes precedence.

# Go Database Best Practices

Go's `database/sql` provides a solid foundation for database access. Use `sqlx` or `pgx` on top of it for ergonomics — never an ORM.

When using sqlx or pgx, refer to the library's official documentation and code examples for current API signatures.
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add yzfly/skills/golang-database@sha256:86f55085e047976b

The line at the top of this page pins the label v1.1.2, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_e52hyt4dzb6odrtc.svg)](https://markdownregistry.com/a/art_e52hyt4dzb6odrtc)

4 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 1 version of this file, committed on May 3, 2026.

versioncommittedcommitsizeaudit
v1.1.2 latest2026-05-03 c091e90 11,648 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (11648 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

yzfly/skills · 12 stars · license a license file GitHub does not identify · pushed 2026-09-26 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_e52hyt4dzb6odrtc
GET https://markdownregistry.com/api/v1/resolve?ref=yzfly/skills/golang-database
GET https://markdownregistry.com/api/v1/blob/86f55085e047976b6f43128e315dabf6cb37760ade19f731df8d1d501d2f6131

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from yzfly/skills

anti-ai-copy SKILL.md skill
yzfly/skills · skills/anti-ai-copy/SKILL.md · 软件界面文案(UI copy / microcopy / UX writing)写作与去 AI 味。当用户要写、改、审界面文案时使用:按钮、页面标题、表单标签、占位符、空状态、Toast /…
v1.0.0 · audit A · 12 stars
brand-narrative SKILL.md skill
yzfly/skills · skills/brand-narrative/SKILL.md · 品牌叙事策略。当用户要做品牌叙事 / 品牌故事 / 品牌定位 / 品牌策略、问「我们的品牌到底围绕什么」「该讲产品还是讲文化」、想判断某个新品 / 联名 / 内容「符不符合品牌」、或为 0–1…
v1.0.0 · audit A · 12 stars
breathing-brand SKILL.md skill
yzfly/skills · skills/breathing-brand/SKILL.md · 出海 / 国际化品牌的极简呼吸感视觉全案。当用户说要做品牌 VI、品牌视觉、logo 与周边、独立站视觉、社区 / 组织 / 产品的品牌形象,或抱怨自己的品牌「看起来廉价」「太满太乱」「不够国际化 /…
v1.0.0 · audit A · 12 stars
cto SKILL.md skill
yzfly/skills · skills/cto/SKILL.md · Startup / AI-startup CTO who is also a top-tier individual contributor. Two modes: (1) greenfield — turn fuzzy business…
git:20260504.146b163 · audit A · 12 stars
golang-benchmark SKILL.md skill
yzfly/skills · skills/cto/references/payload/backend/golang/golang-benchmark/SKILL.md · Golang benchmarking, profiling, and performance measurement. Use when writing, running, or comparing Go benchmarks…
v1.1.3 · audit A · 12 stars
golang-cli SKILL.md skill
yzfly/skills · skills/cto/references/payload/backend/golang/golang-cli/SKILL.md · Golang CLI application development. Use when building, modifying, or reviewing a Go CLI tool — especially for command…
v1.1.3 · audit A · 12 stars
golang-code-style SKILL.md skill
yzfly/skills · skills/cto/references/payload/backend/golang/golang-code-style/SKILL.md · Golang code style, formatting and conventions. Use when writing Go code, reviewing style, configuring linters, writing…
v1.1.2 · audit A · 12 stars
golang-concurrency SKILL.md skill
yzfly/skills · skills/cto/references/payload/backend/golang/golang-concurrency/SKILL.md · Golang concurrency patterns. Use when writing or reviewing concurrent Go code involving goroutines, channels, select…
v1.1.3 · audit A · 12 stars
golang-context SKILL.md skill
yzfly/skills · skills/cto/references/payload/backend/golang/golang-context/SKILL.md · Idiomatic context.Context usage in Golang — creation, propagation, cancellation, timeouts, deadlines, context values…
v1.1.1 · audit A · 12 stars
golang-continuous-integration SKILL.md skill
yzfly/skills · skills/cto/references/payload/backend/golang/golang-continuous-integration/SKILL.md · Provides CI/CD pipeline configuration using GitHub Actions for Golang projects. Covers testing, linting, SAST, security…
v1.2.0 · audit A · 12 stars
golang-data-structures SKILL.md skill
yzfly/skills · skills/cto/references/payload/backend/golang/golang-data-structures/SKILL.md · Golang data structures — slices (internals, capacity growth, preallocation, slices package), maps (internals, hash…
v1.1.1 · audit A · 12 stars
golang-dependency-injection SKILL.md skill
yzfly/skills · skills/cto/references/payload/backend/golang/golang-dependency-injection/SKILL.md · Comprehensive guide for dependency injection (DI) in Golang. Covers why DI matters (testability, loose coupling…
v1.1.2 · audit A · 12 stars

Every file in yzfly/skills

Other files named golang-database

golang-database SKILL.md skill
samber/cc-skills-golang · skills/golang-database/SKILL.md · Comprehensive guide for Go database access — parameterized queries, struct scanning, NULLable columns, transactions…
v1.3.2 · audit A · 3,523 stars
golang-database SKILL.md skill
omarluq/librecode · .librecode/skills/golang-database/SKILL.md · Comprehensive guide for Go database access. Covers parameterized queries, struct scanning, NULLable column handling…
v1.1.2 · audit A · 30 stars

Browse by kind, by grade A, or by owner.