mirror of
https://github.com/hanzoai/skills.git
synced 2026-11-19 00:47:36 +00:00
Every page now loads /webmcp.js, scripts/webmcp.ts with its types stripped (npm run webmcp). Where the browser has document.modelContext it registers two read-only tools: search_skills over the published skills index, and get_skill, which returns a skill's markdown checked against the index digest. The markdown alternate link moves from build.py to site.py, so CI holds every page to it. The API catalog gains the site itself (llms.txt and the skills index) and hanzo.ai/agents; the live discovery check now fetches every catalog link. tests/site.mjs drives the tools through a recording modelContext, and checks a browser without one loads clean.
418 lines
21 KiB
HTML
418 lines
21 KiB
HTML
<!doctype html>
|
|
<html lang="en"><head>
|
|
<meta charset="utf-8"><meta name="viewport" content="width=device-width,initial-scale=1">
|
|
<title>hanzo-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="icon" href="/favicon.svg">
|
|
<link rel="canonical" href="https://hanzoskills.com/hanzo-database">
|
|
<link rel="alternate" type="text/markdown" href="/hanzo-database.md">
|
|
<script type="module" src="/webmcp.js"></script>
|
|
</head>
|
|
<!-- Reading this with a machine? Every page here is also plain markdown.
|
|
This one: https://hanzoskills.com/hanzo-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>hanzo-database</h1><p class="lede">Hanzo Database covers PostgreSQL (with pgvector), Redis, MongoDB, and Hanzo S3 configurations used across the Hanzo ecosystem.</p><h1>Hanzo Database - PostgreSQL, Redis & Vector Storage</h1>
|
|
<p><strong>Category</strong>: Hanzo Ecosystem <strong>Related Skills</strong>: <code>hanzo/hanzo-orm.md</code>, <code>hanzo/hanzo-datastore.md</code>, <code>hanzo/hanzo-stack.md</code></p>
|
|
<h2>Overview</h2>
|
|
<p>Hanzo Database covers PostgreSQL (with pgvector), Redis, MongoDB, and Hanzo S3 configurations used across the Hanzo ecosystem. <strong>All databases run in-cluster on K8s</strong> — no managed database services (DO Managed DB decommissioned Feb 2026).</p>
|
|
<h3>Why In-Cluster?</h3>
|
|
<ul><li><strong>Cost</strong>: 5-10x cheaper than managed DBs at scale</li><li><strong>Latency</strong>: Same-cluster networking, no external hops</li><li><strong>Control</strong>: Full PostgreSQL config, extensions, versions</li><li><strong>Consistency</strong>: Same setup across all environments</li></ul>
|
|
<h2>When to use</h2>
|
|
<ul><li>Configuring PostgreSQL for Hanzo services</li><li>Setting up pgvector for AI embeddings</li><li>Redis caching, sessions, and job queues</li><li>MongoDB for document storage (Chat)</li><li>Database troubleshooting and maintenance</li></ul>
|
|
<h2>Quick reference</h2>
|
|
<p>| Database | Port | Image | Use Case | |----------|------|-------|----------| | PostgreSQL | 5432 | <code>postgres:16</code> | Primary RDBMS, pgvector | | Redis | 6379 | <code>redis:7-alpine</code> | Cache, sessions, BullMQ queues | | MongoDB | 27017 | <code>mongo:7</code> | Document storage (Chat) | | Hanzo S3 | 9000 | <code>ghcr.io/hanzoai/s3</code> | S3-compatible object storage |</p>
|
|
<h2>Production Layout</h2>
|
|
<h3>hanzo-k8s Cluster</h3>
|
|
<p>| Service | Database | Host | |---------|----------|------| | <code>postgres.hanzo.svc</code> | — | Shared PostgreSQL instance | | ↳ | <code>iam</code> | Hanzo IAM (hanzo.id) | | ↳ | <code>cloud</code> | Cloud dashboard | | ↳ | <code>console</code> | Observability | | ↳ | <code>hanzo_cloud</code> | Cloud API | | ↳ | <code>kms</code> | KMS/Hanzo KMS | | ↳ | <code>platform</code> | PaaS platform |</p>
|
|
<h3>lux-k8s Cluster</h3>
|
|
<p>| Service | Database | Host | |---------|----------|------| | <code>postgres.hanzo.svc</code> | — | Shared PostgreSQL instance | | ↳ | <code>cloud</code> | Lux Cloud | | ↳ | <code>commerce</code> | Commerce API | | ↳ | <code>console</code> | Console | | ↳ | <code>gateway</code> | API Gateway | | ↳ | <code>hanzo</code> | Core Hanzo | | ↳ | <code>kms</code> | KMS |</p>
|
|
<h2>PostgreSQL + pgvector</h2>
|
|
<h3>Setup</h3>
|
|
<pre><code class="lang-sql">-- Enable pgvector extension
|
|
CREATE EXTENSION IF NOT EXISTS vector;
|
|
|
|
-- Create embeddings table
|
|
CREATE TABLE embeddings (
|
|
id SERIAL PRIMARY KEY,
|
|
content TEXT NOT NULL,
|
|
embedding vector(1536), -- OpenAI ada-002 dimensions
|
|
metadata JSONB DEFAULT '{}',
|
|
created_at TIMESTAMPTZ DEFAULT NOW()
|
|
);
|
|
|
|
-- IVFFlat index (fast approximate search)
|
|
CREATE INDEX ON embeddings
|
|
USING ivfflat (embedding vector_cosine_ops)
|
|
WITH (lists = 100);
|
|
|
|
-- HNSW index (better recall, more memory)
|
|
CREATE INDEX ON embeddings
|
|
USING hnsw (embedding vector_cosine_ops)
|
|
WITH (m = 16, ef_construction = 64);</code></pre>
|
|
<h3>Similarity Search</h3>
|
|
<pre><code class="lang-sql">-- Cosine similarity (most common for embeddings)
|
|
SELECT content, 1 - (embedding <=> $1::vector) AS similarity
|
|
FROM embeddings
|
|
ORDER BY embedding <=> $1::vector
|
|
LIMIT 5;
|
|
|
|
-- L2 distance
|
|
SELECT content, embedding <-> $1::vector AS distance
|
|
FROM embeddings
|
|
ORDER BY embedding <-> $1::vector
|
|
LIMIT 5;
|
|
|
|
-- Inner product
|
|
SELECT content, embedding <#> $1::vector AS score
|
|
FROM embeddings
|
|
ORDER BY embedding <#> $1::vector
|
|
LIMIT 5;
|
|
|
|
-- With metadata filter
|
|
SELECT content, 1 - (embedding <=> $1::vector) AS similarity
|
|
FROM embeddings
|
|
WHERE metadata->>'source' = 'docs'
|
|
ORDER BY embedding <=> $1::vector
|
|
LIMIT 5;</code></pre>
|
|
<h3>Python pgvector Usage</h3>
|
|
<pre><code class="lang-python">import psycopg2
|
|
from pgvector.psycopg2 import register_vector
|
|
import numpy as np
|
|
|
|
conn = psycopg2.connect(os.environ["DATABASE_URL"])
|
|
register_vector(conn)
|
|
cur = conn.cursor()
|
|
|
|
# Insert embedding
|
|
embedding = np.random.rand(1536).astype(np.float32) # Your actual embedding
|
|
cur.execute(
|
|
"INSERT INTO embeddings (content, embedding, metadata) VALUES (%s, %s, %s)",
|
|
("Hello world", embedding, '{"source": "docs"}')
|
|
)
|
|
|
|
# Similarity search
|
|
query_vec = np.random.rand(1536).astype(np.float32) # Your query embedding
|
|
cur.execute(
|
|
"SELECT content, 1 - (embedding <=> %s) AS similarity "
|
|
"FROM embeddings ORDER BY embedding <=> %s LIMIT 5",
|
|
(query_vec, query_vec)
|
|
)
|
|
for row in cur.fetchall():
|
|
print(f"{row[0]}: {row[1]:.3f}")
|
|
|
|
conn.commit()</code></pre>
|
|
<h3>Go pgvector Usage</h3>
|
|
<pre><code class="lang-go">import (
|
|
"github.com/jackc/pgx/v5"
|
|
"github.com/pgvector/pgvector-go"
|
|
)
|
|
|
|
conn, _ := pgx.Connect(ctx, os.Getenv("DATABASE_URL"))
|
|
|
|
// Insert
|
|
embedding := pgvector.NewVector(floats)
|
|
conn.Exec(ctx,
|
|
"INSERT INTO embeddings (content, embedding) VALUES ($1, $2)",
|
|
"Hello world", embedding,
|
|
)
|
|
|
|
// Search
|
|
rows, _ := conn.Query(ctx,
|
|
"SELECT content, 1 - (embedding <=> $1) AS similarity "+
|
|
"FROM embeddings ORDER BY embedding <=> $1 LIMIT 5",
|
|
pgvector.NewVector(queryVec),
|
|
)</code></pre>
|
|
<h2>Redis Patterns</h2>
|
|
<pre><code class="lang-bash"># Connection
|
|
REDIS_URL=redis://redis.hanzo.svc:6379
|
|
|
|
# From K8s pod
|
|
redis-cli -h redis.hanzo.svc</code></pre>
|
|
<h3>Common Patterns</h3>
|
|
<pre><code class="lang-python">import redis
|
|
|
|
r = redis.from_url(os.environ["REDIS_URL"])
|
|
|
|
# Cache
|
|
r.setex("key", 3600, "value") # 1 hour TTL
|
|
value = r.get("key")
|
|
|
|
# Session
|
|
r.hset(f"session:{session_id}", mapping={"user_id": "123", "role": "admin"})
|
|
|
|
# Rate limiting
|
|
key = f"ratelimit:{user_id}:{minute}"
|
|
count = r.incr(key)
|
|
r.expire(key, 60)
|
|
if count > 100:
|
|
raise RateLimitExceeded()
|
|
|
|
# Job queue (BullMQ pattern)
|
|
r.xadd("jobs:inference", {"model": "zen-70b", "prompt": "Hello"})</code></pre>
|
|
<h2>Local Development (compose.yml)</h2>
|
|
<pre><code class="lang-yaml">services:
|
|
postgres:
|
|
image: postgres:16
|
|
ports:
|
|
- "5432:5432"
|
|
environment:
|
|
POSTGRES_DB: hanzo
|
|
POSTGRES_USER: hanzo
|
|
POSTGRES_PASSWORD: "${DB_PASSWORD}"
|
|
volumes:
|
|
- postgres_data:/var/lib/postgresql/data
|
|
- ./init.sql:/docker-entrypoint-initdb.d/init.sql
|
|
|
|
redis:
|
|
image: redis:7-alpine
|
|
ports:
|
|
- "6379:6379"
|
|
volumes:
|
|
- redis_data:/data
|
|
|
|
mongodb:
|
|
image: mongo:7
|
|
ports:
|
|
- "27017:27017"
|
|
environment:
|
|
MONGO_INITDB_ROOT_USERNAME: hanzo
|
|
MONGO_INITDB_ROOT_PASSWORD: "${MONGO_PASSWORD}"
|
|
volumes:
|
|
- mongo_data:/data/db
|
|
|
|
minio:
|
|
image: minio/minio
|
|
ports:
|
|
- "9000:9000"
|
|
- "9001:9001"
|
|
environment:
|
|
MINIO_ROOT_USER: hanzo
|
|
MINIO_ROOT_PASSWORD: "${MINIO_PASSWORD}"
|
|
command: server /data --console-address ":9001"
|
|
volumes:
|
|
- minio_data:/data
|
|
|
|
volumes:
|
|
postgres_data:
|
|
redis_data:
|
|
mongo_data:
|
|
minio_data:</code></pre>
|
|
<h2>Troubleshooting</h2>
|
|
<p>| Issue | Cause | Solution | |-------|-------|----------| | Port conflict | Service already running | <code>lsof -i :5432 && kill PID</code> | | Connection refused | DB not started | <code>docker compose up -d postgres</code> | | pgvector not found | Extension not installed | <code>CREATE EXTENSION vector;</code> | | Slow queries | Missing index | Add IVFFlat or HNSW index | | OOM | Too many connections | Configure <code>max_connections</code> |</p>
|
|
<pre><code class="lang-bash"># Port conflicts
|
|
lsof -i :5432
|
|
|
|
# Full reset (destructive — loses all data)
|
|
docker compose down -v && docker system prune -a
|
|
|
|
# Connect to prod DB (from K8s pod)
|
|
kubectl exec -it postgres-0 -n hanzo -- psql -U hanzo</code></pre>
|
|
<h2>Related Skills</h2>
|
|
<ul><li><code>hanzo/hanzo-orm.md</code> - Go ORM for database access</li><li><code>hanzo/hanzo-datastore.md</code> - Vector database abstraction</li><li><code>hanzo/hanzo-stack.md</code> - Local stack with all DBs</li><li><code>hanzo/hanzo-kms.md</code> - Secret management (DB credentials)</li></ul>
|
|
<hr>
|
|
<p><strong>Last Updated</strong>: 2026-03-13 <strong>Category</strong>: Hanzo Ecosystem <strong>Related</strong>: postgresql, redis, pgvector, mongodb, minio, database <strong>Prerequisites</strong>: SQL, Redis basics, Docker</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="/hanzo-database.md">This page as plain text</a> · <a href="/llms.txt">Index for agents</a></div>
|
|
</footer>
|
|
</div></body></html> |