Contents
- pgmnemo — Product Plan
- 1. Vision
- 2. Mission
- 3. Target User Segments
- 4. Wedge → Expansion Sequence
- 5. T0..T+12w Roadmap — Weekly Milestones
- Week 0 (2026-04-29 → 2026-05-03) — BOOTSTRAP
- Week 1 (2026-05-04 → 2026-05-10) — RETRIEVAL CORE
- Week 2 (2026-05-11 → 2026-05-17) — WRITE PATH + DISTILLATION
- Week 3 (2026-05-18 → 2026-05-24) — MULTI-TENANT + RLS
- Week 4 (2026-05-25 → 2026-05-31) — PRIVATE BETA PREP
- Week 5 (2026-06-01 → 2026-06-07) — FEEDBACK INTEGRATION
- Week 6 (2026-06-08 → 2026-06-14) — HN LAUNCH PREP
- Week 7 (2026-06-15 → 2026-06-21) — PUBLIC LAUNCH
- Week 8 (2026-06-22 → 2026-06-28) — STABILISATION + EXPANSION
- Week 9–10 (2026-06-29 → 2026-07-12) — ENTERPRISE HOOKS + pgrx DECISION
- Week 11–12 (2026-07-13 → 2026-07-26) — T+12W MILESTONE GATE
- 6. Exit Options
- 7. Kill Criteria (StatAnalyst-sourced)
- 8. Hire Plan
- 9. Revenue Model Decision Tree
- 10. WG Condition Gates
- Appendix A — Key References
- Appendix B — Risks at T0
pgmnemo — Product Plan
Version: 1.0
Date: 2026-04-29
Author: startup_mentor (agent 87), growth_lead (agent 88)
Status: DRAFT — awaiting founder approval
Founder veto: Active on every P0/P1 strategic decision per AGENTS.md §founder-ack rule
1. Vision
pgmnemo is a PostgreSQL extension (PL/pgSQL hot-path + optional Rust/pgrx compiled layer) that turns any PostgreSQL 17+ database into a production-grade multi-agent memory substrate — giving AI orchestration systems ACID-consistent episodic, semantic, and working memory co-located with application data, without adding a separate vector database or memory microservice.
2. Mission
Ship the fastest, most ops-simple agent memory layer in the PostgreSQL ecosystem within T+12 weeks. Prove community adoption by T+12w milestone gate (≥50 GitHub stars, ≥1 named production deployment, ≥1 inbound inquiry from a PostgreSQL-adjacent vendor). If the gate is not passed, freeze per kill criteria §9.
3. Target User Segments
Segment A — Solo / Indie AI Developer (wedge)
- Profile: Solo engineer building an AI agent on top of existing Postgres. Runs Docker Compose. Already uses pgvector. Does not want to manage a separate Pinecone/Mem0 subscription.
- Pain: Tracking conversation history + semantic retrieval + deduplication across runs requires either a memory SaaS (vendor lock-in, $19–249/mo) or rolling their own schema (maintenance burden).
- Job to be done: “Add agent memory to my existing Postgres with one SQL script, zero new services.”
- Acquisition channel: Hacker News, r/LocalLLaMA, pgvector GitHub issues, X/Twitter dev audience.
- User stories (acceptance criteria):
- US-A1: As a solo dev, I can install pgmnemo with
psql -f install.sqland havemem.search_semantic()returning results within 10 minutes. AC: install.sql idempotent, no superuser required, works on PG17 Docker image. - US-A2: As a solo dev, I receive ≤40 ms p95 latency on
mem.search_semantic()on a corpus of 10K entries. AC: benchmark reproduced viamake benchin CI; result logged to console.
- US-A1: As a solo dev, I can install pgmnemo with
Segment B — Small AI Platform / Startup (expansion target, T+8w)
- Profile: 2–10 person startup building an AI product on Postgres (Supabase, Neon, or self-hosted). Needs multi-tenant agent memory, RBAC, retention policies.
- Pain: Mem0 ($249/mo Pro) is getting expensive and its memory is decoupled from their application’s data model (user IDs, org IDs, project IDs). Cross-DB consistency is a constant headache.
- Job to be done: “Give each of my customers an isolated memory namespace backed by the same DB transaction that handles their other data.”
- Acquisition channel: Supabase Marketplace, Discord/Slack communities, direct outreach via LinkedIn.
- User stories:
- US-B1: As a platform engineer, I can create a tenant-isolated memory namespace via
SELECT mem.create_namespace('tenant_42')with RLS enforcement. AC: queries for tenant_42 cannot read tenant_43 memories; enforced at SQL level, no application code required. - US-B2: As a platform engineer, I can set per-namespace retention policies (
mem.set_retention('tenant_42', '90 days')). AC: pg_cron job runs nightly; expired memories soft-deleted;mem.active_count('tenant_42')reflects policy.
- US-B1: As a platform engineer, I can create a tenant-isolated memory namespace via
Segment C — Enterprise / Postgres-Adjacent Infrastructure Vendor (monetisation target, T+24w+)
- Profile: EDB, Crunchy Data (Snowflake), Supabase, Neon, Timescale, Yandex Cloud — companies shipping Postgres distributions or managed Postgres, wanting to offer “AI memory” as a managed feature without building in-house.
- Pain: Customers ask for native agent memory integration. Building in-house costs 6+ months of Rust/PG expertise.
- Job to be done: “Bundle pgmnemo into our distribution and ship it as a premium feature / marketplace extension.”
- Acquisition channel: Supabase Marketplace extension program, EDB extension certification, Crunchy Data partner program, Yandex Cloud Managed PostgreSQL extension list.
- User story:
- US-C1: As a managed Postgres vendor, I can ship pgmnemo as a prebuilt
.sofor PG17 onlinux/amd64+linux/arm64with a singleCREATE EXTENSION pgmnemo;. AC: extension passesmake installcheckon vanilla PG17 Docker; no superuser required for retrieval functions.
- US-C1: As a managed Postgres vendor, I can ship pgmnemo as a prebuilt
4. Wedge → Expansion Sequence
T0 → T+4w WEDGE: Solo dev / indie
Deliver: install.sql, mem.* schema, MCP connector, README
Signal: GitHub stars, first "I installed it" HN/Reddit post
Positioning: "pgvector for agent memory"
T+4w → T+8w EXPANSION-1: Small AI platform / startup
Deliver: multi-tenant namespaces, RLS, retention policies, Supabase compatibility
Signal: ≥1 startup using in staging/prod, inbound inquiry in repo issues
Positioning: "Drop Mem0, use pgmnemo — your Postgres already handles the memory"
T+8w → T+12w EXPANSION-2: OSS launch + commercial positioning
Deliver: public launch (HN Show HN, Product Hunt), PGXN submission, BSL 1.1 license
Signal: ≥50 stars, ≥1 named prod deployment, ≥1 vendor inquiry
Go/No-go: §9 kill criteria evaluated at T+12w milestone gate
T+12w+ EXPANSION-3 (conditional on gate pass)
Evaluate: managed cloud (Supabase partnership), pgrx upgrade, seed fund raise
See §8 revenue model decision tree and §6 exit options
5. T0..T+12w Roadmap — Weekly Milestones
All milestones owner: founder (Alex Gaydabura) unless a specific agent role is noted.
Week 0 (2026-04-29 → 2026-05-03) — BOOTSTRAP
| # | Milestone | Owner | Done criterion |
|---|---|---|---|
| W0.1 | PRODUCT_PLAN.md approved by founder | startup_mentor | Founder comment in task thread |
| W0.2 | mem.* schema SQL scripts: mem.search_semantic(), mem.get_context_pack(), graph CTE |
TL | psql -f install.sql on PG17 Docker; all 3 functions return rows |
| W0.3 | RLS provenance gate: app.role SET LOCAL + row-level policy promote_canonical |
TL | EXPLAIN shows RLS filter; cross-role read test fails as expected |
| W0.4 | MCP connector for tasks_db wired to mem.* functions |
TL | Agent can call mem.search_semantic() via tasks_db MCP in dev |
| W0.5 | GitHub repository created, README (1-screen), install.sql pushed | growth_lead | Repo public, install.sql in root, CI green |
Week 1 (2026-05-04 → 2026-05-10) — RETRIEVAL CORE
| # | Milestone | Owner | Done criterion |
|---|---|---|---|
| W1.1 | mem.insert_memory(), mem.forget(), mem.active_count() functions shipped |
TL | Unit tests pass; MCP integration test green |
| W1.2 | HNSW index on mem.memories.embedding (m=16, ef_construction=128) |
TL | \d mem.memories shows index; EXPLAIN uses index scan |
| W1.3 | Benchmark script make bench — p95 latency target ≤ 40 ms at 10K rows |
TL | Bench output in CI logs; PASS/FAIL result logged |
| W1.4 | pg_cron dedup job: mem.curate_cosine_dedup() runs nightly |
TL | pg_cron job registered; manual trigger clears test duplicates |
| W1.5 | COMPETITIVE_TRACKING.md v1 (Constructive AgenticDB, Mem0, Zep, pgvector) | growth_lead | File in repo; ≥8 competitors assessed with pricing and positioning |
Week 2 (2026-05-11 → 2026-05-17) — WRITE PATH + DISTILLATION
| # | Milestone | Owner | Done criterion |
|---|---|---|---|
| W2.1 | FastAPI write path (POST /mem/ingest, POST /mem/distill) wired to mem.* schema |
TL | API smoke tests pass |
| W2.2 | bge-m3 embedding integration verified against mem.memories.embedding column |
TL | End-to-end: ingest → embed → mem.search_semantic() returns expected result |
| W2.3 | POSITIONING.md v1 — one-sentence pitch, comparison table vs Mem0/pgvector/Constructive | growth_lead | File in repo; founder approves |
| W2.4 | BL-B recall@10 baseline run on live HYBRID stack | PI (77) | recall@10 ≥ 0.60; result logged in spec/reports/ |
Week 3 (2026-05-18 → 2026-05-24) — MULTI-TENANT + RLS
| # | Milestone | Owner | Done criterion |
|---|---|---|---|
| W3.1 | mem.create_namespace(), namespace-scoped RLS policies |
TL | Segment B US-B1 acceptance criteria pass |
| W3.2 | mem.set_retention() + pg_cron nightly expiry job |
TL | Segment B US-B2 acceptance criteria pass |
| W3.3 | Docker Compose example (docker-compose.pgmnemo.yml) |
TL | docker-compose up -d + psql -f install.sql produces working stack in < 5 min from cold start |
| W3.4 | Content calendar v1 (4-week pre-launch posts) | growth_lead | Published; founder approves |
Week 4 (2026-05-25 → 2026-05-31) — PRIVATE BETA PREP
| # | Milestone | Owner | Done criterion |
|---|---|---|---|
| W4.1 | make installcheck CI: PostgreSQL standard regression tests green |
TL | CI badge green on GitHub |
| W4.2 | Private beta: 3–5 solo devs / startups invited | growth_lead | ≥3 people have installed and sent feedback |
| W4.3 | BIWEEKLY MENTOR REVIEW #1 | startup_mentor (87) | Review published in spec/reports/MENTOR_REVIEW_W4.md |
| W4.4 | BSL 1.1 license draft reviewed by founder | founder | LICENSE file in repo; license FAQ page drafted |
Week 5 (2026-06-01 → 2026-06-07) — FEEDBACK INTEGRATION
| # | Milestone | Owner | Done criterion |
|---|---|---|---|
| W5.1 | Top-3 private beta bug fixes shipped | TL | Closed issues; beta testers re-verify |
| W5.2 | mem.explain_context_pack() — human-readable debug output for context selection |
TL | Function returns structured explanation of which memories were selected and why |
| W5.3 | PGXN submission (pgxn.org) — packages pgmnemo 0.1.0 |
TL | PGXN page live; pgxnclient install pgmnemo works |
Week 6 (2026-06-08 → 2026-06-14) — HN LAUNCH PREP
| # | Milestone | Owner | Done criterion |
|---|---|---|---|
| W6.1 | LAUNCH_PLAN.md v1 — HN “Show HN” draft, timing, upvote campaign | growth_lead (88) | Draft approved by founder |
| W6.2 | Demo video (< 3 min): install pgmnemo, run an agent, show memory retrieval | founder | Video uploaded; link in README |
| W6.3 | Supabase Marketplace submission request filed | growth_lead | Submission email/form sent; tracking issue opened |
| W6.4 | BIWEEKLY MENTOR REVIEW #2 | startup_mentor | Review published in spec/reports/MENTOR_REVIEW_W6.md |
Week 7 (2026-06-15 → 2026-06-21) — PUBLIC LAUNCH
| # | Milestone | Owner | Done criterion |
|---|---|---|---|
| W7.1 | LAUNCH: Show HN post goes live | founder | Post up; ≥30 upvotes within 48h |
| W7.2 | LAUNCH: Product Hunt listing | growth_lead | PH page live on launch day |
| W7.3 | Competitive re-evaluation post-launch (Constructive AgenticDB response?) | growth_lead | COMPETITIVE_TRACKING.md v2 published |
| W7.4 | GitHub star count logged — first public signal data point | growth_lead | Logged in spec/reports/LAUNCH_METRICS.md |
Week 8 (2026-06-22 → 2026-06-28) — STABILISATION + EXPANSION
| # | Milestone | Owner | Done criterion |
|---|---|---|---|
| W8.1 | Post-launch bug fixes, issues triaged | TL | No P0 open issues; P1s have assigned ETA |
| W8.2 | First Segment C vendor outreach: EDB, Crunchy (Snowflake), Supabase, Yandex Cloud | growth_lead | ≥2 emails sent; responses logged in spec/reports/VENDOR_OUTREACH.md |
| W8.3 | BIWEEKLY MENTOR REVIEW #3 | startup_mentor | Review published in spec/reports/MENTOR_REVIEW_W8.md |
| W8.4 | pgrx upgrade path evaluation: are ≥2 of 4 trigger conditions met? | TL | Finding logged in spec/v2/pgmnemo/PGRX_EVALUATION_W8.md; decision deferred or actioned |
Week 9–10 (2026-06-29 → 2026-07-12) — ENTERPRISE HOOKS + pgrx DECISION
| # | Milestone | Owner | Done criterion |
|---|---|---|---|
| W9.1 | mem.audit_log table + mem.enable_audit() (enterprise BSL-gated feature) |
TL | Audit events written on insert/delete; RLS enforced |
| W9.2 | mem.search_hybrid() — BM25 + vector fusion (pg_trgm or pg_search) |
TL | Hybrid recall@10 ≥ pure vector recall on BL-B fixture |
| W9.3 | If pgrx trigger conditions met (W8.4): Rust spike for mem_temporal_score custom operator |
TL | Spike doc in spec/v2/pgmnemo/PGRX_SPIKE.md; decision recorded |
| W10.1 | BIWEEKLY MENTOR REVIEW #4 | startup_mentor | Review published in spec/reports/MENTOR_REVIEW_W10.md |
Week 11–12 (2026-07-13 → 2026-07-26) — T+12W MILESTONE GATE
| # | Milestone | Owner | Done criterion |
|---|---|---|---|
| W11.1 | StatAnalyst kill-criteria measurement run | statistical_analyst (79) | Report in spec/reports/KILL_CRITERIA_T12W.md; all 3 metrics measured |
| W11.2 | Metrics audit: GitHub stars ≥ 50? Named prod deployment ≥ 1? Inbound inquiry ≥ 1? | growth_lead | Metrics logged; go/no-go recommendation filed |
| W11.3 | BIWEEKLY MENTOR REVIEW #5 — T+12W VERDICT | startup_mentor | Review in spec/reports/MENTOR_REVIEW_W12.md; PASS / KILL / INTERESTED verdict |
| W12.1 | FOUNDER DECISION — exit option (§6) or continue → revenue path (§8) | founder | Decision documented in spec/v2/pgmnemo/FOUNDER_DECISION_T12W.md |
6. Exit Options
Each option requires founder hard veto clearance before actioning.
Option A — Acqui-hire / Strategic Acquisition
Targets: PostgresPro, EDB, Crunchy Data (Snowflake), Yandex Cloud
Rationale: Crunchy Data sold for $250M at $30M ARR with ~100 employees (June 2025). EDB at $161M revenue (2025). Both demonstrate the “Postgres-expert team → strategic acquisition” pattern. (Source: EXT-2 §C-2.)
Go-conditions (all must be true): 1. T+12w gate passes (≥50 stars OR ≥1 named prod deployment) 2. Inbound interest from ≥1 acquisition target (email, issue comment, LinkedIn, conference) 3. Founder has ≥6 months runway remaining 4. Competing offer OR strategic urgency exists (e.g., Constructive AgenticDB poaching user base)
What to bring to the conversation: GitHub star trajectory + BL-B recall@10 benchmark data + named deployments + BSL 1.1 license (signals commercial intent) + HYBRID architecture doc.
Owner: founder; trigger: growth_lead signals inbound vendor interest (from W8.2 outreach)
Founder veto: Required before any NDA or LOI is signed.
Option B — Open-Core SaaS (Supabase / ParadeDB model)
Targets: Build pgmnemo.cloud — managed Postgres + pgmnemo, hosted on Fly.io / Railway
Rationale: ParadeDB raised $14M Series A (July 2025) with Rust PG extension + managed cloud. Supabase is a distribution partner and potential acquirer ($5B valuation, 2025). OSS core (BSL 1.1) + paid managed tier is the most validated Postgres commercialisation pattern. (Source: EXT-2 §C-2, §C-4.)
Go-conditions (all must be true): 1. T+12w gate passes (≥50 stars, ≥1 named prod deployment, ≥1 vendor inquiry) 2. ≥3 beta users willing to pay ≥$49/mo for hosted pgmnemo 3. Founder has ≥12 months runway for infra investment 4. Supabase Marketplace listing approved OR PGXN installs ≥ 200
Revenue model: See §8. Managed tier $49–499/mo; enterprise license custom.
Owner: founder; trigger: payment intent signals from ≥3 beta users
Founder veto: Required before any cloud infrastructure spend exceeds $500/mo.
Option C — Freeze
Conditions: All three kill criteria §9 thresholds hit simultaneously at T+12w (2026-07-26).
Action: Stop new feature development. Archive repo as read-only. Publish post-mortem. Redirect founder bandwidth to core Agentura product.
What is preserved: SQL scripts remain publicly accessible under BSL 1.1 (or MIT if freeze decision includes license downgrade). Code is not deleted.
Owner: founder; trigger: StatAnalyst kill-criteria report (W11.1) + startup_mentor KILL verdict (W11.3)
Founder veto: Founder may override freeze with explicit written justification in FOUNDER_DECISION_T12W.md (e.g., late-breaking inbound vendor acquisition interest).
7. Kill Criteria (StatAnalyst-sourced)
Primary kill signal — all three must be true simultaneously at T+12w (2026-07-26):
| Criterion | Kill threshold | Rationale |
|---|---|---|
| GitHub stars | < 50 at 2026-07-26 | ParadeDB had >1K stars at Series A pitch (EXT-2 §C-2); 50 is minimal viable OSS signal for a narrow-niche extension |
| Inbound product inquiries | 0 in the T0→T+12w window | No GitHub issues expressing adoption intent + no email/Discord/HN comment = zero market pull |
| Production deployments | 0 named deployments | Even 1 developer self-reporting “using in prod” proves the install path works and someone finds it valuable |
Interpretation of partial failure: - 40 stars + 1 prod deployment → CAUTION — startup_mentor decides CONTINUE / PIVOT / FREEZE at W11.3 - 0 stars + 0 inquiries + 0 prod deployments → FREEZE — kill criteria fully triggered - ≥50 stars + 0 prod deployments + 0 inquiries → PASS (community interest, no adoption — extend 4 weeks)
Secondary kill signals (trigger immediate mentor review, not automatic freeze): - Constructive AgenticDB ships compiled Rust extension with feature parity before T+12w - Mem0 or Zep ships native Postgres integration, removing the wedge - pgrx reaches 1.0.0 AND Constructive ships Rust extension simultaneously — HYBRID moat gone - Founder runway drops below 3 months before T+12w gate
Kill execution process:
1. W11.1 — StatAnalyst publishes spec/reports/KILL_CRITERIA_T12W.md
2. W11.3 — startup_mentor issues MENTOR REVIEW #5 verdict
3. W12.1 — founder makes final decision in spec/v2/pgmnemo/FOUNDER_DECISION_T12W.md
8. Hire Plan
pgmnemo runs on Agentura’s virtual-agent team (TL=5, PI=77, growth_lead=88, startup_mentor=87) during T0→T+12w. No human hires are expected or budgeted before the T+12w milestone gate.
When do we need a pgrx / Rust dev?
Trigger: pgrx upgrade path evaluation (W8.4) shows ≥2 of the 4 trigger conditions met (from SYNTHESIS §5.4):
1. pgrx reaches 1.0.0 stable API
2. A bge-m3-class model ≤100M params passes the 0.58 recall@10 boundary (RES-MEM-EMBED-1)
3. pg_net or equivalent matures to production-grade outbound HTTPS with retry semantics
4. Team scales beyond 1 founder
Expected timing: Not before T+24w. If Option B (managed cloud) is actioned post-T+12w, a pgrx/Rust dev becomes necessary for the compiled extension moat within the T+24w → T+36w window.
Profile required: 2+ years Rust production experience; prior pgrx contribution or shipped production extension (ideal: VectorChord / TimescaleDB / plrust contributor); Postgres internals knowledge (access method API, planner hooks). Full-time equivalent.
Source: pgrx Discord server, Rust PostgreSQL Ecosystem Zulip, direct GitHub outreach to VectorChord / pgvecto.rs contributors. Budget: $120–180K/year (competitive with ParadeDB / TimescaleDB open roles).
When do we need a DevRel?
Trigger: GitHub stars ≥ 200 AND weekly install velocity ≥ 20 installs/week AND ≥3 active external pull request contributors.
Expected timing: T+16w → T+24w if Option B proceeds after the milestone gate.
Profile required: Developer advocate with credibility in both Postgres and LLM/AI communities. Must have public content track record (blog posts, conference talks, YouTube) on Postgres or AI infrastructure. Must be able to write SQL and demo pgmnemo without assistance. Not a pure marketing hire.
Source: Postgres community (pgDay speakers, PostgreSQL Wiki contributors), AI infrastructure Discord/Slack communities.
9. Revenue Model Decision Tree
Pre-T+12w: revenue target = $0. Objective is adoption and community signal, not revenue.
T+12w gate PASS?
│
├─ YES → revenue decision
│ │
│ ├─ ≥3 beta users willing to pay ≥$49/mo AND runway ≥ 12mo?
│ │ └─ YES → MANAGED CLOUD (Option B)
│ │ Model: $49/mo Starter (1 namespace, 100K memories)
│ │ $199/mo Growth (10 namespaces, 1M memories, audit log)
│ │ Custom Enterprise (SLA, BYOK, SOC2 roadmap)
│ │ Stack: Fly.io or Railway + pgmnemo + bge-m3 sidecar
│ │ License: BSL 1.1 — self-host free, cloud use requires paid tier
│ │ Signal to raise seed: ≥$5K MRR OR ≥1 enterprise LOI
│ │
│ ├─ < 3 payers BUT ≥1 vendor inbound inquiry (from W8.2)?
│ │ └─ ENTERPRISE LICENSE (targeted OEM deal)
│ │ Model: Named-user license per deployment; $5K–$50K/year
│ │ OEM integration deal with EDB / Crunchy / Supabase / Yandex
│ │ Trigger: ≥1 vendor confirms evaluation intent
│ │ Ceiling: 1–2 deals covers 12mo runway; not a scalable business alone
│ │
│ └─ No payers AND no vendor inquiry → SERVICES (runway extension only)
│ Model: Integration consulting at $150–250/hr
│ Target: Segment B startups wanting pgmnemo but lacking PG ops
│ Ceiling: $30–50K total; bridge only — not a company strategy
│
└─ NO → FREEZE (§6 Option C)
OR ACQUI-HIRE if inbound acquisition interest exists despite gate failure
License strategy (confirmed by WG vote 5-0-0, pending founder approval)
| Component | License | Rationale |
|---|---|---|
Core SQL schema (mem.*) |
BSL 1.1 | Prevents AWS/GCP free-riding; self-hosted use free; cloud providers must license. TimescaleDB / MariaDB precedent. |
| Python write/distillation service (FastAPI) | MIT | Maximum adoption, zero friction for Segment A; no meaningful cloud-provider risk here |
| pgrx compiled extension (when shipped) | BSL 1.1 | Consistent with TimescaleDB / ParadeDB model; binary moat requires license enforcement at distribution layer |
| Managed cloud tier | Proprietary SaaS | On top of BSL 1.1 core; explicit carve-out in BSL for internal use |
Decision point (Gate 2 §10): Founder must choose BSL 1.1 vs Apache-2.0 before PGXN submission (W5.3). Apache-2.0 maximises stars; BSL 1.1 protects commercial path. This is a founder P0 decision — no agent can resolve it.
Pre-launch requirement: License FAQ page (single markdown file in repo) citing TimescaleDB and MariaDB BSL precedent, before HN launch (W7.1), to pre-empt “is this really open source?” threads.
10. WG Condition Gates
All four gates require founder approval before any downstream action. Founder retains hard veto per AGENTS.md §founder-ack rule.
Gate 1 — PAPER-FIRST / Architecture Decision (HYBRID)
Documents:
- spec/v2/memory-svc/SYNTHESIS_DESIGN-MEM-EXT_WG_RECOMMENDATION.md — WG vote 5-0-0 for HYBRID
- spec/v2/memory-svc/RESEARCH_DESIGN-MEM-EXT-1_TECH_FEASIBILITY.md — FEASIBLE_WITH_RISK
- spec/v2/memory-svc/RESEARCH_DESIGN-MEM-EXT-2_COMMERCIAL.md — VIABLE_WITH_RISK
Condition met: Technical feasibility = FEASIBLE_WITH_RISK AND commercial viability = VIABLE_WITH_RISK → HYBRID trigger per decision rule §4 of synthesis doc.
WG vote: 5-0-0 unanimous (PI 77, LitScout 82, ExperimentDesigner 84, StatAnalyst 79, TL 5)
Status: PROPOSED — pending founder approval 2026-04-29
What it unlocks: Proceed with mem.* schema implementation (W0.2–W0.4, W1.1–W1.4)
If founder vetoes HYBRID: Choose STAY (continue FastAPI path, no commercial positioning) or PIVOT (8–12 week Rust delay; not recommended per WG scoring 2.85/5.00)
Gate 2 — LICENSE / BSL 1.1 Adoption
Document: spec/v2/memory-svc/RESEARCH_DESIGN-MEM-EXT-2_COMMERCIAL.md §C-3
Condition: Founder approves BSL 1.1 for mem.* SQL schema core
Deadline: Before W5.3 PGXN submission (2026-06-07)
Status: Pending
What it unlocks: Commercial positioning, PGXN submission with correct license metadata, Supabase Marketplace submission, OEM deal conversations
Veto note: Founder may choose Apache-2.0 or MIT; this trades commercial defensibility for maximum community adoption. Decision is permanent — changing license after public release damages trust.
Gate 3 — METRICS / T+12w Milestone Gate
Document: spec/reports/KILL_CRITERIA_T12W.md (to be created at W11.1)
Condition: ≥50 GitHub stars OR ≥1 named prod deployment OR ≥1 vendor inquiry by 2026-07-26
Status: Pending measurement
What it unlocks:
- PASS → revenue model decision tree (§8); exit option evaluation (§6); pgrx upgrade path re-evaluation
- FAIL → kill criteria §7 executed; freeze unless founder veto
Gate 4 — KILL / Freeze Trigger
Document: startup_mentor MENTOR REVIEW #5 (spec/reports/MENTOR_REVIEW_W12.md)
Condition: All three primary kill thresholds hit simultaneously (< 50 stars AND 0 inquiries AND 0 prod deployments) at T+12w
Status: Pending
What it unlocks: Freeze execution; founder decision in spec/v2/pgmnemo/FOUNDER_DECISION_T12W.md
Veto note: Founder may override kill with explicit written justification (e.g., late-breaking inbound acquisition interest that post-dates the measurement window). Justification must be documented.
Appendix A — Key References
| Document | Purpose |
|---|---|
spec/v2/memory-svc/SYNTHESIS_DESIGN-MEM-EXT_WG_RECOMMENDATION.md |
HYBRID architecture WG vote; scoring matrix; 4 trigger conditions for pgrx upgrade |
spec/v2/memory-svc/RESEARCH_DESIGN-MEM-EXT-1_TECH_FEASIBILITY.md |
Technical: pgrx risks, embedding-in-PG impossibility, latency projections (−47% p95) |
spec/v2/memory-svc/RESEARCH_DESIGN-MEM-EXT-2_COMMERCIAL.md |
Commercial: 8 competitors, 6 case studies, 6 license options, market sizing (35% CAGR) |
spec/v2/memory-svc/SPIKE_EMBED_BENCHMARK.md |
BL-B recall@10: bge-small REJECT (0.578); bge-m3 anchor = 0.620 |
spec/v2/memory-svc/ADR_002_DATA_MODEL.md |
Canonical schema: mem.memories, mem.episodes, mem.graph_edges |
agents/startup_mentor/SKILL.md |
Mentor review template and kill signal taxonomy |
agents/growth_lead/SKILL.md |
Growth and DevRel charter |
spec/v2/pgmnemo/_migration_001_bootstrap.sql |
DB bootstrap: project_id=18, assignee_id=87/88, Week-0 tasks |
Appendix B — Risks at T0
| # | Risk | Severity | Mitigation |
|---|---|---|---|
| R1 | Constructive AgenticDB gains traction before pgmnemo launches (schema-only, 2026-04-28) | HIGH | Ship mem.* SQL to GitHub within 2 weeks (W1.5); establish HNSW benchmark as differentiator; position compiled extension as roadmap moat |
| R2 | bge-m3 MLX LaunchAgent single point of failure on macOS reboot | MEDIUM | Document recovery in README; provide fallback text-embedding-3-small path in mem.ingest() |
| R3 | pgrx pre-1.0 instability blocks compiled extension path | MEDIUM | HYBRID architecture explicitly defers pgrx; PL/pgSQL path carries zero pgrx risk regardless |
| R4 | Founder single-point-of-failure (solo team, no delegation to human devs) | HIGH | Scope T0–T+12w to SQL-only deliverables any PG-literate contributor can maintain; pgrx dev hired only after gate passes |
| R5 | BSL 1.1 “not really open source” backlash on HN launch | MEDIUM | Prepare license FAQ before W7.1; cite TimescaleDB / MariaDB BSL precedent; MIT on FastAPI layer preserves community goodwill |
| R6 | Zero revenue path if Option B requires >12mo runway | MEDIUM | Services fallback ($150–250/hr) provides runway extension without structural commitment; sets ceiling explicitly |