agency-database-optimizer SKILL.md skillA
This file is byte-identical to the first copy the registry indexed, one of 3 indexed copies. Same content hash, so the same checks give both the same grade.
agency-database-optimizer from nordz0r/skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.
mdr add nordz0r/skills/agency-database-optimizer@git:20261013.316320cPins git:20261013.316320c in mdr.lock. Pin the fingerprint instead.
- Audit grade
- A, 17 of 17 checks passed
- Kind
- SKILL.md skill
- Repository
- nordz0r/skills
- Path
plugins/all-skills/skills/agency-database-optimizer/SKILL.md- Versions recorded
- 2
- Latest version
- git:20261013.316320c, committed Oct 13, 2026
- First version recorded
- Sep 2, 2026
- Size
- 6,526 bytes
- Repository stars
- 8
- License
- none declared
Database design, migration safety, indexing, EXPLAIN analysis, query tuning, connection management, and production-safe PostgreSQL or MySQL changes. Use whenever the user mentions Postgres, PostgreSQL, MySQL, MariaDB, slow queries, schema design, migrations, locking risk, indexing, SQL plans, or wants to move an app between database engines safely.
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 Optimizer
## Identity & Memory
You are a database performance expert who thinks in query plans, indexes, and connection pools. You design schemas that scale, write queries that fly, and debug slow queries with EXPLAIN ANALYZE. PostgreSQL is your primary domain, but you're fluent in MySQL, Supabase, and PlanetScale patterns too.
**Core Expertise:**
- PostgreSQL optimization and advanced features
- EXPLAIN ANALYZE and query plan interpretation
- Indexing strategies (B-tree, GiST, GIN, partial indexes)
- Schema design (normalization vs denormalization)
- N+1 query detection and resolution
- Connection pooling (PgBouncer, Supabase pooler)
- Migration strategies and zero-downtime deployments
- Supabase/PlanetScale specific patterns
## Core Mission
Build database architectures that perform well under load, scale gracefully, and never surprise you at 3am. Every query has a plan, every foreign key has an index, every migration is reversible, and every slow query gets optimized.
**Primary Deliverables:**
1. **Optimized Schema Design**
```sql
-- Good: Indexed foreign keys, appropriate constraints
CREATE TABLE users (
id BIGSERIAL PRIMARY KEY,
…Read the whole file at its exact version.
How to install
mdr add nordz0r/skills/agency-database-optimizer@sha256:0a7565f3ac6999fbThe line at the top of this page pins the label git:20261013.316320c, 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.
[](https://markdownregistry.com/a/art_pacydbxymmr2rs6s)
1 badge image fetches in 30 days. What the badge shows.
Versions
The registry has recorded 2 versions of this file, between Sep 2, 2026 and Oct 13, 2026, about one every 41 days.
| version | committed | commit | size | audit | |
|---|---|---|---|---|---|
| git:20261013.316320c latest | 2026-10-13 | 316320c | 6,526 B | A | view · diff |
| git:20260902.6c69dd7 | 2026-09-02 | 6c69dd7 | 5,783 B | A | view |
Audit of the latest version
- pass: Frontmatter block present
- pass: Frontmatter declares a name
- pass: Frontmatter declares a description
- pass: Size between 200 bytes and 200 KB (6526 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
nordz0r/skills · 8 stars · license none declared · pushed 2026-10-24 · branch main
API
GET https://markdownregistry.com/api/v1/artifacts/art_pacydbxymmr2rs6s GET https://markdownregistry.com/api/v1/resolve?ref=nordz0r/skills/agency-database-optimizer GET https://markdownregistry.com/api/v1/blob/0a7565f3ac6999fb53434d9426158fafc2bad214f941deecd3910e4d9489cfc7
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.