database SKILL.md skillA

database from bug-ops/zeph is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add bug-ops/zeph/database@v1.0

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

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
bug-ops/zeph
Path
.zeph/skills/database/SKILL.md
Versions recorded
3
Latest version
v1.0, committed Mar 30, 2026
First version recorded
Mar 21, 2026
Size
12,387 bytes
Repository stars
66
License
MIT

Query and manage SQLite, PostgreSQL, and MySQL databases from the command line. Use when the user asks to run SQL queries, inspect database schemas, create or alter tables, import or export data, manage indexes, analyze query performance with EXPLAIN, back up or restore databases, or perform CRUD operations via sqlite3, psql, or mysql CLI tools.

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

# Database CLI Operations

## Quick Reference

| Action | SQLite | PostgreSQL | MySQL |
|--------|--------|------------|-------|
| Connect | `sqlite3 db.sqlite` | `psql -U user -d dbname` | `mysql -u user -p dbname` |
| List databases | `.databases` | `\l` | `SHOW DATABASES;` |
| List tables | `.tables` | `\dt` | `SHOW TABLES;` |
| Describe table | `.schema tablename` | `\d tablename` | `DESCRIBE tablename;` |
| Quit | `.quit` | `\q` | `\q` or `exit` |
| Run file | `.read file.sql` | `\i file.sql` | `source file.sql` |

## SQLite (sqlite3)

### Connection and Configuration

```bash
# Open or create a database
sqlite3 mydb.sqlite

# Open read-only
sqlite3 -readonly mydb.sqlite

# Execute SQL directly (non-interactive)
sqlite3 mydb.sqlite "SELECT * FROM users;"

# Execute SQL from file
sqlite3 mydb.sqlite < queries.sql
sqlite3 mydb.sqlite ".read queries.sql"

# Output modes
sqlite3 mydb.sqlite -header -column "SELECT * FROM users;"
sqlite3 mydb.sqlite -json "SELECT * FROM users;"
sqlite3 mydb.sqlite -csv "SELECT * FROM users;"
sqlite3 mydb.sqlite -markdown "SELECT * FROM users;"
```

### Dot Commands

```bash
.help                    # List all dot commands
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add bug-ops/zeph/database@sha256:e5c147a312ec68f3

The line at the top of this page pins the label v1.0, 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_bbblohtgjpf7kkuf.svg)](https://markdownregistry.com/a/art_bbblohtgjpf7kkuf)

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

Versions

The registry has recorded 3 versions of this file, between Mar 21, 2026 and Mar 30, 2026, about one every 4 days.

versioncommittedcommitsizeaudit
v1.0 latest2026-03-30 c68c5de 12,387 BA view · diff
v1.02026-03-21 f1a698c 12,372 BA view · diff
v1.02026-03-21 a3fbaa5 12,373 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 (12387 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

bug-ops/zeph · 66 stars · license MIT · pushed 2026-11-03 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_bbblohtgjpf7kkuf
GET https://markdownregistry.com/api/v1/resolve?ref=bug-ops/zeph/database
GET https://markdownregistry.com/api/v1/blob/e5c147a312ec68f3b3c37bae5adcbf517f98e1984da6cb48ada727d43ae64494

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 bug-ops/zeph

AGENTS.md@.github AGENTS.md file
bug-ops/zeph · .github/AGENTS.md
git:20260606.583c571 · audit A · 66 stars
api-request SKILL.md skill
bug-ops/zeph · .zeph/skills/api-request/SKILL.md · Send HTTP API requests using curl. Use when the user asks to call an API, fetch data from a URL, send…
v1.0 · audit A · 66 stars
archive SKILL.md skill
bug-ops/zeph · .zeph/skills/archive/SKILL.md · Create, extract, list, and convert compressed archives using tar, zip, gzip, bzip2, xz, zstd, and 7z. Use when the user…
v1.0 · audit A · 66 stars
browser SKILL.md skill
bug-ops/zeph · .zeph/skills/browser/SKILL.md · Browser automation via Playwright MCP — navigate pages, click elements, fill forms, take screenshots, extract text…
v1.0 · audit B · 66 stars
caveman SKILL.md skill
bug-ops/zeph · .zeph/skills/caveman/SKILL.md · Switch to ultra-compressed, telegraphic output. Use when the user asks for terse, brief, minimal, "caveman", or…
v1.0 · audit A · 66 stars
code-analysis SKILL.md skill
bug-ops/zeph · .zeph/skills/code-analysis/SKILL.md · LSP-based code analysis via mcpls MCP server. Use for compiler-accurate type inspection, go-to-definition…
v1.0 · audit A · 66 stars
cron SKILL.md skill
bug-ops/zeph · .zeph/skills/cron/SKILL.md · Schedule recurring and one-time tasks using cron, crontab, at, and launchd. Use when the user asks to set up scheduled…
v1.0 · audit A · 66 stars
docker SKILL.md skill
bug-ops/zeph · .zeph/skills/docker/SKILL.md · Manage Docker containers, images, volumes, networks, and Compose stacks. Use when the user asks to build, run, stop…
v1.0 · audit A · 66 stars
file-ops SKILL.md skill
bug-ops/zeph · .zeph/skills/file-ops/SKILL.md · File system operations — list directory contents, find files by name or glob pattern, search text inside files with…
v1.0 · audit A · 66 stars
git SKILL.md skill
bug-ops/zeph · .zeph/skills/git/SKILL.md · Run git version control commands for repository management. Use when the user asks to check status, view history or…
v1.0 · audit A · 66 stars
github SKILL.md skill
bug-ops/zeph · .zeph/skills/github/SKILL.md · GitHub CLI (gh) for repository management, issues, pull requests, releases, workflows, search, gists, and API access…
v1.0 · audit A · 66 stars
json-yaml SKILL.md skill
bug-ops/zeph · .zeph/skills/json-yaml/SKILL.md · Parse, query, transform, validate, and convert JSON and YAML data using jq and fy (fast-yaml). Use when the user asks…
v1.0 · audit A · 66 stars

Every file in bug-ops/zeph

Other files named database

database SKILL.md skill
msrv-tech/skills · database/SKILL.md · Создание, запуск, обновление, загрузка и выгрузка информационных баз 1С, Git и ibcmd.
git:20260930.4d99096 · audit A · 62 stars
database SKILL.md skill
event4u-app/agent-config · src/skills/database/SKILL.md · Use when designing schemas and relations, tuning queries or indexes on any SQL engine, or multi-connection patterns —…
git:20261026.9af7ad3 · audit A · 18 stars
database SKILL.md skill
jnpiyush/agentx · .github/skills/architecture/database/SKILL.md · Design database operations including migrations, indexing strategies, transactions, connection pooling, and ORM best…
v1.0.0 · audit A · 18 stars
database Cursor rule
darknecrocities/skillbuilder · .cursor/rules/database.mdc · Architect, implement, and maintain resilient relational and NoSQL databases, zero-downtime schema migrations…
git:20261029.1aa6bef · audit A · 13 stars
database SKILL.md skill
darknecrocities/skillbuilder · skills/database/SKILL.md · Architect, implement, and maintain resilient relational and NoSQL databases, zero-downtime schema migrations…
git:20261025.6dc09bd · audit A · 13 stars
database SKILL.md skill
yamanidev/claude-code-configuration · skills/database/SKILL.md · Workflow for designing, querying, and reasoning about databases — schema modeling, normalization, keys/constraints…
git:20260717.6d13f3c · audit A · 9 stars
database SKILL.md skill
umararshad4/honey-stack · skills/database/SKILL.md · Design schemas, write safe/online migrations, add indexes, fix slow queries and N+1, get transactions and concurrency…
git:20261017.c52b424 · audit A · 4 stars

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