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.
335 lines
20 KiB
HTML
335 lines
20 KiB
HTML
<!doctype html>
|
|
<html lang="en"><head>
|
|
<meta charset="utf-8"><meta name="viewport" content="width=device-width,initial-scale=1">
|
|
<title>hanzo-sql</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-sql">
|
|
<link rel="alternate" type="text/markdown" href="/hanzo-sql.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-sql.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-sql</h1><p class="lede">Hanzo SQL is a PostgreSQL fork with pre-built extensions for AI workloads: pgvector (vector similarity), pgcron (scheduled jobs), pgdocumentdb (MongoDB wire protocol), and PostGIS (geospatial).</p><h1>Hanzo SQL - PostgreSQL with AI Extensions</h1>
|
|
<p><strong>Category</strong>: Hanzo Ecosystem <strong>Related Skills</strong>: <code>hanzo/hanzo-kv.md</code>, <code>hanzo/hanzo-platform.md</code>, <code>hanzo/hanzo-orm.md</code></p>
|
|
<h2>Overview</h2>
|
|
<p>Hanzo SQL is a <strong>PostgreSQL fork</strong> with pre-built extensions for AI workloads: pgvector (vector similarity), pg_cron (scheduled jobs), pg_documentdb (MongoDB wire protocol), and PostGIS (geospatial). Ships as <code>ghcr.io/hanzoai/sql</code>. Built on PostgreSQL 18 (Debian bookworm). Default branch: <code>master</code>. Port 5432.</p>
|
|
<h3>Why Hanzo SQL?</h3>
|
|
<ul><li><strong>pgvector</strong>: Vector similarity search for AI embeddings (IVFFlat, HNSW indexes)</li><li><strong>pg_documentdb</strong>: MongoDB wire protocol compatibility over PostgreSQL (replaces standalone MongoDB)</li><li><strong>pg_cron</strong>: Scheduled jobs inside the database</li><li><strong>PostGIS</strong>: Geospatial data and queries</li><li><strong>Multi-tenant</strong>: Organization-scoped schemas (<code>hanzo</code>, <code>console</code>, <code>iam</code>)</li><li><strong>AI-tuned config</strong>: <code>conf/postgresql.conf</code> optimized for vector operations and parallel queries</li></ul>
|
|
<h3>Tech Stack</h3>
|
|
<ul><li><strong>Language</strong>: C (PostgreSQL core)</li><li><strong>Build</strong>: Meson (primary) / Make (GNUmakefile.in) / <code>configure</code> (autoconf)</li><li><strong>Image</strong>: <code>ghcr.io/hanzoai/sql</code> (multi-stage Dockerfile, Debian bookworm)</li><li><strong>Base</strong>: PostgreSQL 18</li></ul>
|
|
<h3>OSS Base</h3>
|
|
<p>Repo: <code>hanzoai/sql</code> (PostgreSQL fork). The <code>hanzo/</code> directory contains Hanzo-specific config, compose file, and init SQL.</p>
|
|
<h2>When to use</h2>
|
|
<ul><li>Primary OLTP database for any Hanzo service</li><li>Vector embedding storage and similarity search</li><li>MongoDB wire protocol access (via pg_documentdb, paired with FerretDB)</li><li>Multi-tenant application data with schema isolation</li><li>Scheduled database jobs (pg_cron)</li></ul>
|
|
<h2>Hard requirements</h2>
|
|
<ol><li><strong>Port 5432</strong> available</li><li><strong>Docker</strong> for container deployment (or full PostgreSQL build toolchain)</li><li><strong>Shared preload libraries</strong>: <code>vector,pg_cron,pg_documentdb_core,pg_documentdb</code></li></ol>
|
|
<h2>Quick reference</h2>
|
|
<p>| Item | Value | |------|-------| | Port | 5432 | | Image | <code>ghcr.io/hanzoai/sql</code> | | PG Version | 18 (bookworm) | | Default DB | <code>hanzo</code> | | Default User | <code>hanzo</code> | | Config | <code>conf/postgresql.conf</code> | | License | PostgreSQL License | | Repo | <code>github.com/hanzoai/sql</code> | | pgAdmin | port 5050 (via compose) |</p>
|
|
<h2>One-file quickstart</h2>
|
|
<h3>Docker (Hanzo image)</h3>
|
|
<pre><code class="lang-bash">docker run -d --name hanzo-sql \
|
|
-p 5432:5432 \
|
|
-e POSTGRES_DB=hanzo \
|
|
-e POSTGRES_USER=hanzo \
|
|
-e POSTGRES_PASSWORD=secret \
|
|
ghcr.io/hanzoai/sql</code></pre>
|
|
<h3>Docker Compose (local dev)</h3>
|
|
<pre><code class="lang-bash">cd hanzo/
|
|
docker compose up -d
|
|
|
|
# Connect
|
|
docker exec -it hanzo-postgres psql -U hanzo -d hanzo</code></pre>
|
|
<p>The <code>hanzo/compose.yml</code> starts PostgreSQL 17 with pgvector and pgAdmin:</p>
|
|
<pre><code class="lang-yaml">services:
|
|
postgres:
|
|
image: pgvector/pgvector:pg17
|
|
container_name: hanzo-postgres
|
|
ports:
|
|
- "5432:5432"
|
|
environment:
|
|
POSTGRES_DB: hanzo
|
|
POSTGRES_USER: hanzo
|
|
POSTGRES_PASSWORD: ${POSTGRES_PASSWORD:-hanzo_dev}
|
|
|
|
pgadmin:
|
|
image: dpage/pgadmin4:latest
|
|
container_name: hanzo-pgadmin
|
|
ports:
|
|
- "5050:80"
|
|
environment:
|
|
PGADMIN_DEFAULT_EMAIL: ${PGADMIN_EMAIL:[email protected]}
|
|
PGADMIN_DEFAULT_PASSWORD: ${PGADMIN_PASSWORD:-admin}</code></pre>
|
|
<h2>Core Concepts</h2>
|
|
<h3>Pre-Installed Extensions</h3>
|
|
<p>The Docker image builds and installs these extensions:</p>
|
|
<p>| Extension | Source | Purpose | |-----------|--------|---------| | <strong>pgvector</strong> | <code>hanzoai/sql-vector</code> | Vector similarity search | | <strong>pg_cron</strong> | citusdata/pg_cron v1.6.7 | Scheduled jobs | | <strong>pg_documentdb</strong> | microsoft/documentdb | MongoDB wire protocol | | <strong>PostGIS 3</strong> | apt package | Geospatial data |</p>
|
|
<p>Init script (<code>docker-entrypoint-initdb.d/01-extensions.sql</code>) enables them on startup. DocumentDB extensions are wrapped in exception handlers so PostgreSQL starts even if they fail to load.</p>
|
|
<h3>Shared Preload Libraries</h3>
|
|
<pre><code>shared_preload_libraries = 'vector,pg_cron,pg_documentdb_core,pg_documentdb'</code></pre>
|
|
<p>DocumentDB RUM extension uses graceful loading:</p>
|
|
<pre><code>documentdb_core.rum_library_load_option = 'try_documentdb_extended_rum'</code></pre>
|
|
<h3>Multi-Tenant Schema</h3>
|
|
<p>The <code>hanzo/init.sql</code> creates:</p>
|
|
<ul><li><strong>Schemas</strong>: <code>hanzo</code>, <code>console</code>, <code>iam</code></li><li><strong>Roles</strong>: <code>hanzo_console</code>, <code>hanzo_iam</code>, <code>hanzo_readonly</code></li><li><strong>Core tables</strong>: <code>hanzo.organizations</code>, <code>hanzo.projects</code>, <code>hanzo.embeddings</code></li><li><strong>Vector index</strong>: IVFFlat on <code>hanzo.embeddings</code> (1536-dim, cosine similarity)</li><li><strong>Trigram indexes</strong>: For fuzzy text search on org/project names</li></ul>
|
|
<h3>PostgreSQL Configuration</h3>
|
|
<p><code>conf/postgresql.conf</code> is tuned for AI workloads:</p>
|
|
<pre><code class="lang-ini"># Memory - tuned for vector operations
|
|
shared_buffers = 512MB
|
|
work_mem = 64MB
|
|
effective_cache_size = 1536MB
|
|
|
|
# Parallel queries - leverage multi-core for vector ops
|
|
max_parallel_workers_per_gather = 4
|
|
max_parallel_workers = 8
|
|
max_worker_processes = 16
|
|
|
|
# Connections
|
|
max_connections = 200
|
|
|
|
# WAL
|
|
wal_level = replica
|
|
max_wal_size = 2GB</code></pre>
|
|
<h3>Integration Points</h3>
|
|
<pre><code>hanzo/console -- AI observability metadata
|
|
hanzo/iam -- User/org data (Hanzo IAM)
|
|
hanzo/platform -- PaaS orchestration metadata
|
|
hanzo/kms -- Secret management data</code></pre>
|
|
<p>Connection string pattern:</p>
|
|
<pre><code>DATABASE_URL=postgresql://hanzo:password@localhost:5432/hanzo</code></pre>
|
|
<h3>Directory Structure</h3>
|
|
<pre><code>sql/
|
|
README.md # Upstream PostgreSQL README
|
|
Dockerfile # Multi-stage: build extensions + runtime
|
|
Makefile # PostgreSQL build
|
|
meson.build # Meson build system
|
|
configure / configure.ac
|
|
conf/
|
|
postgresql.conf # Hanzo-tuned PostgreSQL config
|
|
docker-entrypoint-initdb.d/
|
|
01-extensions.sql # Auto-enable extensions on startup
|
|
hanzo/
|
|
LLM.md # Hanzo-specific documentation
|
|
compose.yml # Local dev compose (PG + pgAdmin)
|
|
init.sql # Schema, roles, tables, indexes
|
|
src/ # PostgreSQL source code
|
|
contrib/ # PostgreSQL contrib modules
|
|
doc/ # PostgreSQL documentation
|
|
config/ # Build configuration</code></pre>
|
|
<h3>Syncing with Upstream</h3>
|
|
<pre><code class="lang-bash">git fetch upstream
|
|
git merge upstream/master
|
|
git checkout --ours hanzo/ # Preserve Hanzo customizations
|
|
git push origin master</code></pre>
|
|
<h2>Troubleshooting</h2>
|
|
<p>| Issue | Cause | Solution | |-------|-------|----------| | documentdb extension not loaded | Missing shared_preload_libraries | Ensure <code>pg_documentdb_core,pg_documentdb</code> in config | | Vector index slow | IVFFlat needs more lists | Increase <code>lists</code> parameter or switch to HNSW | | pg_cron not working | Wrong database_name | Set <code>cron.database_name</code> to match your DB | | Connection refused | PG not ready | Wait for healthcheck: <code>pg_isready -U hanzo -d hanzo</code> | | Init SQL failed | Extension .so missing | Check Dockerfile build stage completed |</p>
|
|
<h2>Related Skills</h2>
|
|
<ul><li><code>hanzo/hanzo-kv.md</code> - Redis-compatible cache</li><li><code>hanzo/hanzo-orm.md</code> - Go ORM with PostgreSQL backend</li><li><code>hanzo/hanzo-datastore.md</code> - ClickHouse (OLAP)</li><li><code>hanzo/hanzo-platform.md</code> - PaaS deployment</li><li><code>hanzo/hanzo-universe.md</code> - Production K8s infrastructure</li></ul>
|
|
<hr>
|
|
<p><strong>Last Updated</strong>: 2026-03-13 <strong>Category</strong>: Hanzo Ecosystem <strong>Related</strong>: sql, postgresql, pgvector, documentdb, database, multi-tenant <strong>Prerequisites</strong>: Docker or PostgreSQL build toolchain</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-sql.md">This page as plain text</a> · <a href="/llms.txt">Index for agents</a></div>
|
|
</footer>
|
|
</div></body></html> |