cp /workspaces/claude-code-flow/docs/reasoningbank/models/safla/memory.db ~/.swarm/memory.db

npx claude-flow@alpha memory search "YOUR_QUERY" --namespace safla

# Self-learning patterns (confidence evolution)
npx claude-flow@alpha memory search "API optimization" --domain self-learning

# Feedback loops (user/system feedback)
npx claude-flow@alpha memory search "feedback" --domain feedback-optimization

# Bayesian confidence (probability updates)
npx claude-flow@alpha memory search "uncertainty" --domain confidence-adjustment

# Success/failure learning (distillation)
npx claude-flow@alpha memory search "deployment success" --domain distillation

# Meta-learning (recursive improvement)
npx claude-flow@alpha memory search "meta-learning" --domain recursive-cycles

# Expert patterns (0.9-0.95)
npx claude-flow@alpha memory retrieve "confidence:>0.90" --namespace safla

# High confidence (0.8-0.9)
npx claude-flow@alpha memory retrieve "confidence:>0.80" --namespace safla

# Learning patterns (0.5-0.7)
npx claude-flow@alpha memory retrieve "confidence:<0.70" --namespace safla

npx claude-flow@alpha memory search "Node.js optimization" --namespace safla
npx claude-flow@alpha memory search "PostgreSQL patterns" --namespace safla
npx claude-flow@alpha memory search "Kubernetes deployment" --namespace safla
npx claude-flow@alpha memory search "React performance" --namespace safla

# Pattern count by domain
sqlite3 ~/.swarm/memory.db "SELECT domain, COUNT(*) FROM patterns GROUP BY domain;"

# Top 10 highest confidence patterns
sqlite3 ~/.swarm/memory.db "SELECT description, confidence FROM patterns ORDER BY confidence DESC LIMIT 10;"

# Top 10 highest success rate patterns
sqlite3 ~/.swarm/memory.db "SELECT description, success_rate FROM patterns ORDER BY success_rate DESC LIMIT 10;"

# Knowledge graph relationships
sqlite3 ~/.swarm/memory.db "SELECT relationship, COUNT(*) FROM pattern_links GROUP BY relationship;"

# Before task (get relevant patterns)
npx claude-flow@alpha hooks pre-task --description "API optimization"
npx claude-flow@alpha memory search "API optimization" --namespace safla

# After editing (store pattern usage)
npx claude-flow@alpha hooks post-edit --file "src/api.ts" --memory-key "swarm/safla/api"

# After task (record success)
npx claude-flow@alpha hooks post-task --task-id "api-opt-123"

import Database from 'better-sqlite3';
import { homedir } from 'os';
import { join } from 'path';

const db = new Database(join(homedir(), '.swarm', 'memory.db'), { readonly: true });

// Get high-confidence patterns
const patterns = db.prepare(`
  SELECT * FROM patterns
  WHERE confidence >= 0.85 AND domain = ?
  ORDER BY success_rate DESC
  LIMIT 10
`).all('self-learning');

// Get related patterns
const related = db.prepare(`
  SELECT p.*, pl.relationship
  FROM patterns p
  JOIN pattern_links pl ON p.id = pl.target_id
  WHERE pl.source_id = ?
`).all(patternId);

db.close();

# Verify model installed
ls -lh ~/.swarm/memory.db

# Check pattern count
sqlite3 ~/.swarm/memory.db "SELECT COUNT(*) FROM patterns;"

# Test query performance
time npx claude-flow@alpha memory search "test" --namespace safla

# Optimize database
sqlite3 ~/.swarm/memory.db "PRAGMA optimize; VACUUM;"

# Check WAL mode
sqlite3 ~/.swarm/memory.db "PRAGMA journal_mode;"

sqlite3 ~/.swarm/memory.db "
SELECT description, confidence, success_rate
FROM patterns
ORDER BY confidence DESC, success_rate DESC
LIMIT 10;
"

# Get all relationships
sqlite3 ~/.swarm/memory.db "SELECT DISTINCT relationship FROM pattern_links;"

# Find patterns that CAUSE others
sqlite3 ~/.swarm/memory.db "
SELECT p.description
FROM patterns p
JOIN pattern_links pl ON p.id = pl.source_id
WHERE pl.relationship = 'causes'
LIMIT 10;
"

# Find patterns that ENHANCE others
sqlite3 ~/.swarm/memory.db "
SELECT p.description
FROM patterns p
JOIN pattern_links pl ON p.id = pl.source_id
WHERE pl.relationship = 'enhances'
ORDER BY pl.strength DESC
LIMIT 10;
"

# ReasoningBank CLI help
npx claude-flow@alpha memory --help

# GitHub Issues
https://github.com/ruvnet/claude-flow/issues

# Model location
~/.swarm/memory.db