mirror of
https://github.com/hanzoai/skills.git
synced 2026-11-19 00:47:36 +00:00
338 lines
23 KiB
HTML
338 lines
23 KiB
HTML
<!doctype html>
|
|
<html lang="en"><head>
|
|
<meta charset="utf-8"><meta name="viewport" content="width=device-width,initial-scale=1">
|
|
<title>discover-database</title>
|
|
<meta name="color-scheme" content="dark">
|
|
<style>
|
|
/* Committed to one visual world: a dark instrument panel. No light variant —
|
|
the dot field and the hairline rules only read on black, and a naive
|
|
inversion would wash both out. Every colour is painted explicitly so the page
|
|
never borrows a host background. */
|
|
@font-face{font-family:'Zen';src:url('/fonts/Zen-Variable.woff2') format('woff2');font-weight:100 900;font-style:normal;font-display:swap}
|
|
@font-face{font-family:'Zen';src:url('/fonts/Zen-Italic-Variable.woff2') format('woff2');font-weight:100 900;font-style:italic;font-display:swap}
|
|
@font-face{font-family:'Zen Mono';src:url('/fonts/ZenMono-Variable.woff2') format('woff2');font-weight:100 900;font-style:normal;font-display:swap}
|
|
@font-face{font-family:'Zen Mono';src:url('/fonts/ZenMono-Italic-Variable.woff2') format('woff2');font-weight:100 900;font-style:italic;font-display:swap}
|
|
@font-face{font-family:'Zen Pixel Square';src:url('/fonts/ZenPixel-Square.woff2') format('woff2');font-style:normal;font-display:swap}
|
|
|
|
:root{
|
|
--ink:#f4f4f2; --soft:#9c9c98; --faint:#6a6a66; --ground:#000; --panel:#0a0a0a;
|
|
--line:#232323; --line-hi:#3a3a3a; --accent:#f4f4f2;
|
|
--font-zen-sans:'Zen',-apple-system,BlinkMacSystemFont,"Segoe UI",Helvetica,Arial,sans-serif;
|
|
--font-zen-mono:'Zen Mono',ui-monospace,"SF Mono",SFMono-Regular,Menlo,Consolas,monospace;
|
|
--font-zen-pixel-square:'Zen Pixel Square',monospace;
|
|
--mono:var(--font-zen-mono);
|
|
--sans:var(--font-zen-sans);
|
|
/* Controls are pills and surfaces are soft, as on hanzo.ai. */
|
|
--r:999px; --r-soft:14px;
|
|
}
|
|
*{box-sizing:border-box}
|
|
html{-webkit-text-size-adjust:100%}
|
|
body{margin:0;background:var(--ground);color:var(--ink);font-family:var(--sans);
|
|
font-size:16px;line-height:1.65;-webkit-font-smoothing:antialiased}
|
|
.wrap{max-width:60rem;margin:0 auto;padding:0 1.75rem}
|
|
|
|
/* The dot field. A halftone made of one repeating radial-gradient, faded out
|
|
along the diagonal by a mask so it reads as a wave rather than wallpaper. */
|
|
/* No overflow clip here: the dot field is inset to the box already, and a clip
|
|
would cut off the copy-prompt menu. */
|
|
.hero{position:relative;border-bottom:1px solid var(--line)}
|
|
.hero::before{content:"";position:absolute;inset:0;
|
|
background-image:radial-gradient(var(--line-hi) 1px, transparent 1px);
|
|
background-size:7px 7px;
|
|
-webkit-mask-image:linear-gradient(115deg,#000 0%,rgba(0,0,0,.55) 38%,transparent 72%);
|
|
mask-image:linear-gradient(115deg,#000 0%,rgba(0,0,0,.55) 38%,transparent 72%);
|
|
pointer-events:none}
|
|
.hero .wrap{position:relative;padding-top:5.5rem;padding-bottom:4rem}
|
|
|
|
nav{border-bottom:1px solid var(--line)}
|
|
nav .in{max-width:60rem;margin:0 auto;padding:1.1rem 1.75rem;display:flex;
|
|
justify-content:space-between;align-items:center;gap:1rem}
|
|
.brand{font-family:var(--mono);font-size:.85rem;letter-spacing:.14em;
|
|
text-transform:uppercase;color:var(--ink);text-decoration:none;
|
|
display:inline-flex;align-items:center;gap:.6rem}
|
|
.brand i{font-style:normal;color:var(--faint)}
|
|
.mark{width:1.15em;height:1.15em;display:block;flex:0 0 auto}
|
|
nav a.up{font-family:var(--mono);font-size:.72rem;letter-spacing:.14em;
|
|
text-transform:uppercase;color:var(--soft);text-decoration:none}
|
|
nav a.up:hover{color:var(--ink)}
|
|
|
|
h1{font-family:var(--mono);font-size:clamp(2rem,5.4vw,3.4rem);line-height:1.12;
|
|
letter-spacing:-.02em;margin:0 0 1.1rem;font-weight:500;text-wrap:balance}
|
|
h1 em{font-style:normal;color:var(--faint)}
|
|
.lede{color:var(--soft);font-size:1.05rem;max-width:52ch;margin:0 0 2.25rem}
|
|
|
|
.btns{display:flex;flex-wrap:wrap;gap:.7rem;margin:0 0 .5rem;align-items:center}
|
|
.btn{display:inline-flex;align-items:center;gap:.5rem;font-family:var(--mono);
|
|
font-size:.72rem;letter-spacing:.14em;text-transform:uppercase;
|
|
padding:.8rem 1.4rem;border:1px solid var(--line-hi);border-radius:var(--r);
|
|
color:var(--ink);text-decoration:none;background:transparent;cursor:pointer;
|
|
line-height:1.2;font-weight:400}
|
|
.btn:hover{background:#141414;text-decoration:none;border-color:var(--soft)}
|
|
.btn.solid{background:var(--ink);color:#000;border-color:var(--ink)}
|
|
.btn.solid:hover{background:#d8d8d4}
|
|
.btn .chev{width:.7em;height:.7em;flex:0 0 auto;transition:transform .15s ease}
|
|
.btn[aria-expanded="true"] .chev{transform:rotate(180deg)}
|
|
|
|
/* Copy-prompt selector. Each row copies the prompt for its own target. */
|
|
.copy{position:relative;display:inline-flex}
|
|
.menu{position:absolute;top:calc(100% + .5rem);left:0;z-index:20;min-width:21rem;
|
|
background:var(--panel);border:1px solid var(--line-hi);border-radius:var(--r-soft);
|
|
padding:.4rem;display:flex;flex-direction:column;
|
|
box-shadow:0 12px 32px rgba(0,0,0,.75)}
|
|
.menu[hidden]{display:none}
|
|
.mi{display:flex;align-items:center;gap:.7rem;width:100%;text-align:left;
|
|
padding:.62rem .8rem;border:0;border-radius:calc(var(--r-soft) - .35rem);
|
|
background:transparent;color:var(--ink);font-family:var(--mono);font-size:.76rem;
|
|
letter-spacing:.04em;text-decoration:none;cursor:pointer;line-height:1.3;
|
|
white-space:nowrap}
|
|
.mi:hover,.mi:focus-visible{background:#181818;outline:none}
|
|
.mi .mark{width:1.05rem;height:1.05rem;color:var(--soft)}
|
|
.mi:hover .mark{color:var(--ink)}
|
|
.mi u{margin-left:auto;color:var(--faint);text-decoration:none;font-size:.68rem;
|
|
letter-spacing:.1em;text-transform:uppercase}
|
|
|
|
/* Works-with bar: one scrolling row, name and mark per agent. */
|
|
.strip{border-bottom:1px solid var(--line);background:var(--panel)}
|
|
.strip .in{max-width:60rem;margin:0 auto;padding:.9rem 1.75rem;display:flex;
|
|
align-items:center;gap:1.25rem;font-family:var(--mono);font-size:.72rem;
|
|
letter-spacing:.1em;text-transform:uppercase;color:var(--faint)}
|
|
.strip b{color:var(--soft);font-weight:400;flex:0 0 auto;
|
|
border-right:1px solid var(--line);padding-right:1.25rem;align-self:stretch;
|
|
display:flex;align-items:center}
|
|
.bar{display:flex;align-items:center;gap:.5rem;flex:1 1 auto;min-width:0;
|
|
overflow-x:auto;scrollbar-width:none;scroll-snap-type:x proximity;
|
|
-webkit-overflow-scrolling:touch;
|
|
-webkit-mask-image:linear-gradient(90deg,#000 calc(100% - 3rem),transparent);
|
|
mask-image:linear-gradient(90deg,#000 calc(100% - 3rem),transparent)}
|
|
.bar::-webkit-scrollbar{display:none}
|
|
.agent{display:inline-flex;align-items:center;gap:.45rem;flex:0 0 auto;
|
|
padding:.4rem .85rem;border:1px solid var(--line);border-radius:var(--r);
|
|
color:var(--soft);white-space:nowrap;scroll-snap-align:start;
|
|
text-decoration:none;background:var(--ground)}
|
|
.agent:hover{color:var(--ink);border-color:var(--line-hi);text-decoration:none}
|
|
.agent .mark{width:.95rem;height:.95rem}
|
|
|
|
h2{font-family:var(--mono);font-size:1.1rem;letter-spacing:-.01em;margin:2.75rem 0 .75rem;font-weight:500}
|
|
h3{font-size:1rem;margin:2rem 0 .5rem;font-weight:600}
|
|
h4,h5,h6{font-size:.94rem;margin:1.5rem 0 .5rem;font-weight:600}
|
|
p{margin:0 0 1rem;max-width:70ch}
|
|
ul,ol{margin:0 0 1rem;padding-left:1.35rem;max-width:70ch}
|
|
li{margin:.22rem 0}
|
|
a{color:var(--ink);text-decoration:underline;text-underline-offset:3px;
|
|
text-decoration-color:var(--line-hi)}
|
|
a:hover{text-decoration-color:var(--ink)}
|
|
a:focus-visible{outline:1px solid var(--ink);outline-offset:3px}
|
|
code{font-family:var(--mono);font-size:.85em;background:var(--panel);
|
|
border:1px solid var(--line);border-radius:5px;padding:.1em .36em}
|
|
pre{background:var(--panel);border:1px solid var(--line);padding:1rem 1.1rem;
|
|
border-radius:var(--r-soft);overflow-x:auto;margin:0 0 1.25rem}
|
|
pre code{background:none;border:0;padding:0;font-size:.82rem;line-height:1.7}
|
|
blockquote{margin:0 0 1rem;padding-left:1rem;border-left:1px solid var(--line-hi);color:var(--soft)}
|
|
hr{border:0;border-top:1px solid var(--line);margin:2.5rem 0}
|
|
table{border-collapse:collapse;width:100%;margin:0 0 1.25rem;font-size:.92rem;
|
|
display:block;overflow-x:auto}
|
|
th,td{border:1px solid var(--line);padding:.5rem .7rem;text-align:left}
|
|
|
|
.curl{display:block;background:var(--panel);border:1px solid var(--line);
|
|
border-radius:var(--r-soft);padding:.95rem 1.1rem;font-family:var(--mono);
|
|
font-size:.8rem;color:var(--soft);overflow-x:auto;margin:0 0 2.5rem;
|
|
white-space:pre;line-height:1.9}
|
|
.curl b{color:var(--ink);font-weight:400}
|
|
.curl i{font-style:normal;color:var(--faint)}
|
|
|
|
/* index */
|
|
#q{width:100%;padding:.85rem 1.2rem;font-family:var(--mono);font-size:.85rem;color:var(--ink);
|
|
background:var(--panel);border:1px solid var(--line);border-radius:var(--r);margin:0 0 .6rem}
|
|
#q::placeholder{color:var(--faint);text-transform:uppercase;letter-spacing:.1em;font-size:.72rem}
|
|
#q:focus{outline:none;border-color:var(--soft)}
|
|
#count{color:var(--faint);font-family:var(--mono);font-size:.72rem;letter-spacing:.1em;
|
|
text-transform:uppercase;margin:0 0 2rem}
|
|
.cat{margin:2.5rem 0 .5rem;font-family:var(--mono);font-size:.7rem;letter-spacing:.16em;
|
|
text-transform:uppercase;color:var(--faint);border-bottom:1px solid var(--line);
|
|
padding-bottom:.45rem}
|
|
.row{display:block;padding:.6rem .9rem;margin:0 -.9rem;border-bottom:1px solid var(--line);
|
|
border-radius:var(--r-soft);text-decoration:none}
|
|
.row:hover{background:#0a0a0a}
|
|
.nm{font-family:var(--mono);font-size:.84rem;color:var(--ink);display:block}
|
|
.ds{color:var(--soft);font-size:.9rem;display:block;margin-top:.12rem}
|
|
footer{margin-top:4rem;padding:2rem 0 4rem;border-top:1px solid var(--line);
|
|
color:var(--faint);font-size:.85rem}
|
|
footer a{color:var(--soft)}
|
|
.fmap{display:grid;gap:1.75rem;grid-template-columns:repeat(auto-fit,minmax(11rem,1fr));
|
|
margin:0 0 2rem;font-size:.85rem}
|
|
.fmap b{display:block;font-family:var(--mono);font-size:.68rem;letter-spacing:.16em;
|
|
text-transform:uppercase;color:var(--faint);font-weight:400;margin:0 0 .6rem;
|
|
border-bottom:1px solid var(--line);padding-bottom:.4rem}
|
|
.fmap a{display:inline-block;color:var(--ink);text-decoration:none;margin:.3rem .35rem 0 0}
|
|
.fmap a:hover{text-decoration:underline}
|
|
.fmap div{color:var(--faint);line-height:1.5}
|
|
.fend{border-top:1px solid var(--line);padding-top:1.25rem;font-size:.82rem}
|
|
|
|
@media (max-width:640px){
|
|
.hero .wrap{padding-top:3.25rem;padding-bottom:2.75rem}
|
|
.btns{gap:.5rem}
|
|
.btn{padding:.75rem 1.15rem;font-size:.68rem}
|
|
.copy,.copy .btn{width:100%;justify-content:center}
|
|
.menu{left:0;right:0;min-width:0}
|
|
.strip .in{flex-direction:column;align-items:flex-start;gap:.6rem;padding:.9rem 1.75rem}
|
|
.strip b{border-right:0;padding-right:0}
|
|
.bar{width:100%}
|
|
}
|
|
</style>
|
|
<link rel="alternate" type="text/markdown" href="/discover-database.md">
|
|
|
|
<link rel="icon" href="/favicon.svg">
|
|
<link rel="canonical" href="https://hanzoskills.com/discover-database">
|
|
</head>
|
|
<!-- Reading this with a machine? Every page here is also plain markdown.
|
|
This one: https://hanzoskills.com/discover-database.md
|
|
Index: https://hanzoskills.com/llms.txt
|
|
Corpus: https://hanzoskills.com/all.md
|
|
Append .md to any path for the markdown twin. -->
|
|
<body>
|
|
<nav><div class="in">
|
|
<a class="brand" href="/"><svg class="mark" viewBox="0 0 67 67" fill="currentColor" aria-hidden="true"><path d="M22.21 67V44.6369H0V67H22.21Z"/><path d="M66.7038 22.3184H22.2534L0.0878906 44.6367H44.4634L66.7038 22.3184Z"/><path d="M22.21 0H0V22.3184H22.21V0Z"/><path d="M66.7198 0H44.5098V22.3184H66.7198V0Z"/><path d="M66.7198 67V44.6369H44.5098V67H66.7198Z"/></svg> HANZO<i>SKILLS</i></a>
|
|
<a class="up" href="/">All skills</a>
|
|
</div></nav>
|
|
|
|
<div class="wrap">
|
|
<h1>discover-database</h1><p class="lede">Automatically discover database skills when working with SQL, PostgreSQL, MongoDB, Redis, database schema design, query optimization, migrations, connection pooling, ORMs, or database selection. Activates for database design, optimization, and implementation tasks.</p><h1>Database Skills Discovery</h1>
|
|
<p>Provides automatic access to comprehensive database design, optimization, and implementation skills.</p>
|
|
<h2>When This Skill Activates</h2>
|
|
<p>This skill auto-activates when you're working with:</p>
|
|
<ul><li>SQL databases (PostgreSQL, MySQL)</li><li>NoSQL databases (MongoDB, Redis)</li><li>Database schema design and modeling</li><li>Query optimization and performance tuning</li><li>Database migrations and schema evolution</li><li>Connection pooling configuration</li><li>ORM usage and patterns</li><li>Database selection and architecture decisions</li></ul>
|
|
<h2>Available Skills</h2>
|
|
<h3>Quick Reference</h3>
|
|
<p>The Database category contains 8 core skills:</p>
|
|
<ol><li><strong>postgres-schema-design</strong> - Schema design, relationships, data types, normalization</li><li><strong>postgres-query-optimization</strong> - EXPLAIN plans, indexes, slow query debugging</li><li><strong>postgres-migrations</strong> - Schema changes, zero-downtime, rollback strategies</li><li><strong>mongodb-document-design</strong> - Document modeling, embedding vs referencing</li><li><strong>redis-data-structures</strong> - Caching, sessions, rate limiting, leaderboards</li><li><strong>database-connection-pooling</strong> - Pool configuration, debugging exhaustion</li><li><strong>orm-patterns</strong> - ORM best practices, N+1 prevention, eager loading</li><li><strong>database-selection</strong> - Choosing databases, SQL vs NoSQL decisions</li></ol>
|
|
<h3>Load Full Category Details</h3>
|
|
<p>For complete descriptions and workflows:</p>
|
|
<pre><code class="lang-bash">cat skills/database/INDEX.md</code></pre>
|
|
<p>This loads the full Database category index with:</p>
|
|
<ul><li>Detailed skill descriptions</li><li>Usage triggers for each skill</li><li>Common workflow combinations</li><li>Cross-references to related skills</li></ul>
|
|
<h3>Load Specific Skills</h3>
|
|
<p>Load individual skills as needed:</p>
|
|
<pre><code class="lang-bash"># PostgreSQL skills
|
|
cat skills/database/postgres-schema-design.md
|
|
cat skills/database/postgres-query-optimization.md
|
|
cat skills/database/postgres-migrations.md
|
|
|
|
# NoSQL skills
|
|
cat skills/database/mongodb-document-design.md
|
|
cat skills/database/redis-data-structures.md
|
|
|
|
# Cross-database skills
|
|
cat skills/database/database-connection-pooling.md
|
|
cat skills/database/orm-patterns.md
|
|
cat skills/database/database-selection.md</code></pre>
|
|
<h2>Common Workflows</h2>
|
|
<h3>New Database Project</h3>
|
|
<p><strong>Sequence</strong>: Selection → Schema design → Connection pooling</p>
|
|
<pre><code class="lang-bash">cat skills/database/database-selection.md # Choose database
|
|
cat skills/database/postgres-schema-design.md # or mongodb-document-design.md
|
|
cat skills/database/database-connection-pooling.md</code></pre>
|
|
<h3>Query Performance Debugging</h3>
|
|
<p><strong>Sequence</strong>: Optimization → Connection pooling → ORM patterns</p>
|
|
<pre><code class="lang-bash">cat skills/database/postgres-query-optimization.md # Debug slow queries
|
|
cat skills/database/database-connection-pooling.md # Check pool settings
|
|
cat skills/database/orm-patterns.md # Fix N+1 queries</code></pre>
|
|
<h3>Schema Evolution</h3>
|
|
<p><strong>Sequence</strong>: Schema design → Migrations</p>
|
|
<pre><code class="lang-bash">cat skills/database/postgres-schema-design.md # Design changes
|
|
cat skills/database/postgres-migrations.md # Implement safely</code></pre>
|
|
<h3>Caching Layer</h3>
|
|
<p><strong>Sequence</strong>: Redis structures → Cache patterns</p>
|
|
<pre><code class="lang-bash">cat skills/database/redis-data-structures.md # Redis patterns
|
|
# Then load caching skills via discover-caching gateway</code></pre>
|
|
<h2>Skill Selection Guide</h2>
|
|
<p><strong>PostgreSQL skills</strong> (relational, ACID, complex queries):</p>
|
|
<ul><li><code>postgres-schema-design.md</code> - Design relational schemas</li><li><code>postgres-query-optimization.md</code> - Optimize complex queries</li><li><code>postgres-migrations.md</code> - Evolve schema over time</li></ul>
|
|
<p><strong>MongoDB skills</strong> (document-oriented, flexible schema):</p>
|
|
<ul><li><code>mongodb-document-design.md</code> - Design document structures</li><li>Choose when: Flexible schema, nested data, rapid iteration</li></ul>
|
|
<p><strong>Redis skills</strong> (in-memory, key-value, caching):</p>
|
|
<ul><li><code>redis-data-structures.md</code> - Caching, sessions, rate limiting</li><li>Choose when: Speed critical, caching layer, real-time features</li></ul>
|
|
<p><strong>Cross-database skills</strong>:</p>
|
|
<ul><li><code>database-selection.md</code> - <strong>Start here</strong> for new projects</li><li><code>database-connection-pooling.md</code> - All databases need this</li><li><code>orm-patterns.md</code> - When using ORMs (SQLAlchemy, Prisma, Mongoose)</li></ul>
|
|
<h2>Integration with Other Skills</h2>
|
|
<p>Database skills commonly combine with:</p>
|
|
<p><strong>API skills</strong> (<code>discover-api</code>):</p>
|
|
<ul><li>API endpoints → Database queries</li><li>Connection pooling for API servers</li><li>Query optimization for API performance</li><li>Migrations alongside API versioning</li></ul>
|
|
<p><strong>Backend language skills</strong> (<code>discover-backend</code>):</p>
|
|
<ul><li>Python: SQLAlchemy, psycopg2, PyMongo</li><li>Zig: PostgreSQL C bindings</li><li>Rust: SQLx, Diesel</li><li>Go: database/sql, GORM</li></ul>
|
|
<p><strong>Testing skills</strong> (<code>discover-testing</code>):</p>
|
|
<ul><li>Integration tests with test databases</li><li>Migration testing</li><li>Query performance testing</li><li>Data fixture management</li></ul>
|
|
<p><strong>Data pipeline skills</strong> (<code>discover-data</code>):</p>
|
|
<ul><li>ETL from databases</li><li>Database as data source</li><li>Bulk data operations</li><li>Streaming database changes (CDC)</li></ul>
|
|
<p><strong>Observability skills</strong> (<code>discover-observability</code>):</p>
|
|
<ul><li>Query metrics and slow query logs</li><li>Connection pool metrics</li><li>Database performance monitoring</li><li>Alert configuration</li></ul>
|
|
<h2>Progressive Loading</h2>
|
|
<p>This gateway skill (~200 lines, ~2K tokens) enables progressive loading:</p>
|
|
<ul><li><strong>Level 1</strong>: Gateway loads automatically (you're here now)</li><li><strong>Level 2</strong>: Load category INDEX.md (~3K tokens) for full overview</li><li><strong>Level 3</strong>: Load specific skills (~2-4K tokens each) as needed</li></ul>
|
|
<p>Total context: 2K + 3K + skill(s) = 5-10K tokens vs 25K+ for entire index.</p>
|
|
<h2>Quick Start Examples</h2>
|
|
<p><strong>"Design a PostgreSQL schema for an e-commerce app"</strong>:</p>
|
|
<pre><code class="lang-bash">cat skills/database/postgres-schema-design.md</code></pre>
|
|
<p><strong>"Why is my query slow?"</strong>:</p>
|
|
<pre><code class="lang-bash">cat skills/database/postgres-query-optimization.md</code></pre>
|
|
<p><strong>"How do I safely change my database schema?"</strong>:</p>
|
|
<pre><code class="lang-bash">cat skills/database/postgres-migrations.md</code></pre>
|
|
<p><strong>"Should I use MongoDB or PostgreSQL?"</strong>:</p>
|
|
<pre><code class="lang-bash">cat skills/database/database-selection.md</code></pre>
|
|
<p><strong>"Implement caching with Redis"</strong>:</p>
|
|
<pre><code class="lang-bash">cat skills/database/redis-data-structures.md</code></pre>
|
|
<p><strong>"Fix N+1 queries in my ORM"</strong>:</p>
|
|
<pre><code class="lang-bash">cat skills/database/orm-patterns.md</code></pre>
|
|
<h2>Database Type Decision Tree</h2>
|
|
<pre><code>Need ACID transactions? YES → PostgreSQL
|
|
Need complex queries/joins? YES → PostgreSQL
|
|
Need flexible schema? YES → MongoDB
|
|
Need real-time caching? YES → Redis
|
|
Need full-text search? YES → PostgreSQL (with extensions) or Elasticsearch
|
|
Need graph relationships? YES → Neo4j or PostgreSQL (with extensions)
|
|
Need analytics? YES → DuckDB or Redpanda + Iceberg</code></pre>
|
|
<p>For detailed decision-making:</p>
|
|
<pre><code class="lang-bash">cat skills/database/database-selection.md</code></pre>
|
|
<h2>PostgreSQL Focus Areas</h2>
|
|
<p><strong>Schema design</strong> → <code>postgres-schema-design.md</code>:</p>
|
|
<ul><li>Tables, columns, data types</li><li>Primary keys, foreign keys, constraints</li><li>Normalization vs denormalization</li><li>Indexing strategies</li></ul>
|
|
<p><strong>Query optimization</strong> → <code>postgres-query-optimization.md</code>:</p>
|
|
<ul><li>EXPLAIN and EXPLAIN ANALYZE</li><li>Index selection and creation</li><li>Query plan analysis</li><li>Performance tuning</li></ul>
|
|
<p><strong>Migrations</strong> → <code>postgres-migrations.md</code>:</p>
|
|
<ul><li>Schema change strategies</li><li>Zero-downtime deployments</li><li>Rollback procedures</li><li>Migration tools (Alembic, Flyway, migrate)</li></ul>
|
|
<h2>NoSQL Focus Areas</h2>
|
|
<p><strong>MongoDB</strong> → <code>mongodb-document-design.md</code>:</p>
|
|
<ul><li>Document structure and embedding</li><li>References vs embedding tradeoffs</li><li>Schema versioning</li><li>Index design for documents</li></ul>
|
|
<p><strong>Redis</strong> → <code>redis-data-structures.md</code>:</p>
|
|
<ul><li>Strings, hashes, lists, sets, sorted sets</li><li>Caching patterns and TTLs</li><li>Session storage</li><li>Rate limiting implementations</li><li>Leaderboards and counters</li></ul>
|
|
<h2>ORM Considerations</h2>
|
|
<p>Before using ORMs, load:</p>
|
|
<pre><code class="lang-bash">cat skills/database/orm-patterns.md</code></pre>
|
|
<p><strong>Common ORM pitfalls</strong>:</p>
|
|
<ul><li>N+1 query problems</li><li>Lazy vs eager loading confusion</li><li>Transaction management</li><li>Raw SQL when necessary</li><li>Migration generation</li></ul>
|
|
<p><strong>Supported ORMs</strong>:</p>
|
|
<ul><li>SQLAlchemy (Python)</li><li>Prisma (TypeScript/Node.js)</li><li>Diesel (Rust)</li><li>GORM (Go)</li><li>ActiveRecord (Ruby)</li><li>Entity Framework (C#)</li></ul>
|
|
<h2>Usage Instructions</h2>
|
|
<ol><li><strong>Auto-activation</strong>: This skill loads automatically when Claude Code detects database work</li><li><strong>Browse skills</strong>: Run <code>cat skills/database/INDEX.md</code> for full category overview</li><li><strong>Load specific skills</strong>: Use bash commands above to load individual skills</li><li><strong>Follow workflows</strong>: Use recommended sequences for common patterns</li><li><strong>Decision support</strong>: Start with <code>database-selection.md</code> for new projects</li></ol>
|
|
<hr>
|
|
<p><strong>Next Steps</strong>: Run <code>cat skills/database/INDEX.md</code> to see full category details, or load specific skills using the bash commands above.</p>
|
|
<footer>
|
|
<div class="fmap">
|
|
<div><b>Build</b>
|
|
<a href="https://hanzo.app">hanzo.app</a> app builder
|
|
<a href="https://hanzo.codes">hanzo.codes</a> code with an agent
|
|
<a href="https://hanzoskills.com">hanzoskills.com</a> what an agent reads</div>
|
|
<div><b>Run</b>
|
|
<a href="https://console.hanzo.ai">console.hanzo.ai</a> cloud console
|
|
<a href="https://api.hanzo.ai">api.hanzo.ai</a> the API</div>
|
|
<div><b>Account</b>
|
|
<a href="https://hanzo.id">hanzo.id</a> sign in
|
|
<a href="https://pay.hanzo.ai">pay.hanzo.ai</a> top up
|
|
<a href="https://billing.hanzo.ai">billing.hanzo.ai</a> invoices and usage</div>
|
|
<div><b>Company</b>
|
|
<a href="https://hanzo.ai">hanzo.ai</a> canonical
|
|
<a href="https://hanzo.ventures">hanzo.ventures</a> ventures</div>
|
|
</div>
|
|
<div class="fend"><a href="/discover-database.md">This page as plain text</a> · <a href="/llms.txt">Index for agents</a></div>
|
|
</footer>
|
|
</div>
|
|
</body></html> |