​

Databases & Caching

​

Available Services

​

Usage Examples

​

Full Stack Database Setup

npx create-better-openclaw \
  --services postgresql,redis,neo4j \
  --yes

​

Minimal Cache + Database

npx create-better-openclaw --preset minimal --yes

​

Backend Platform

npx create-better-openclaw \
  --services supabase,postgresql,redis \
  --yes

​

Database Comparison

​

Architecture Patterns

​

Layered Caching

# Redis for hot data
# PostgreSQL for persistent storage
npx create-better-openclaw --services redis,postgresql --yes

​

Graph + Relational Hybrid

# Neo4j for relationships
# PostgreSQL for tabular data
npx create-better-openclaw --services neo4j,postgresql --yes

​

Real-Time Backend

# Convex for reactive data
# Redis for caching
npx create-better-openclaw --services convex,redis --yes

​

Performance Optimization

​

PostgreSQL

1. Indexes: Create indexes on frequently queried columns
2. Connection Pooling: Use PgBouncer for connection management
3. Partitioning: Partition large tables by date or key
4. JSONB: Use JSONB for semi-structured data
5. Vacuum: Configure autovacuum appropriately

​

Redis

1. Memory Management: Set maxmemory and eviction policies
2. Persistence: Choose RDB or AOF based on needs
3. Key Naming: Use consistent key naming conventions
4. Expiration: Set TTLs on cached data
5. Pipeline: Use pipelining for bulk operations

​

Neo4j

1. Indexes: Create indexes on frequently queried properties
2. Constraints: Use constraints for data integrity
3. Query Optimization: Use EXPLAIN for query analysis
4. Batch Imports: Use LOAD CSV or batch APIs
5. Memory Configuration: Tune heap and page cache

​

Data Persistence

​

Volumes

volumes:
  postgres-data:      # PostgreSQL data
  redis-data:         # Redis snapshots
  neo4j-data:         # Neo4j graph data
  convex-data:        # Convex SQLite/data
  supabase_db:        # Supabase storage

​

Backup Strategies

​

PostgreSQL Backups

# Backup
docker exec postgresql pg_dump -U openclaw openclaw > backup.sql

# Restore
cat backup.sql | docker exec -i postgresql psql -U openclaw openclaw

​

Redis Backups

# Trigger save
docker exec redis redis-cli SAVE

# Copy RDB file
docker cp redis:/data/dump.rdb ./redis-backup.rdb

​

Neo4j Backups

# Export to Cypher
docker exec neo4j neo4j-admin database dump neo4j --to-path=/data

​

Security Best Practices

​

Authentication

1. Strong Passwords: Generate random passwords for production
2. Environment Variables: Store credentials in .env
3. Network Isolation: Use Docker networks
4. Connection Limits: Configure max connections
5. SSL/TLS: Enable encrypted connections in production

​

Access Control

1. User Roles: Create separate users with minimal permissions
2. Database Isolation: Use separate databases per service
3. Network Policies: Restrict database ports to internal network
4. Audit Logs: Enable logging for security events
5. Regular Updates: Keep database images updated

​

Integration Patterns

​

Application Stack

npx create-better-openclaw \
  --services postgresql,redis,n8n,grafana \
  --yes

​

AI + Database

npx create-better-openclaw \
  --services postgresql,redis,qdrant,ollama \
  --yes

​

Full Platform

npx create-better-openclaw \
  --services supabase,postgresql,redis,neo4j \
  --yes

​

Monitoring

• Grafana + Prometheus: Metrics dashboards
• Health Checks: Built-in Docker health checks
• Logs: Access via docker logs
• Query Performance: Enable slow query logs

# View PostgreSQL logs
docker logs postgresql -f

# View Redis stats
docker exec redis redis-cli INFO

# Check Neo4j status
docker exec neo4j cypher-shell "CALL dbms.listConfig();"