mofa db

mofa db init -t <DB_TYPE> [OPTIONS]

mofa db init -t postgres

mofa db init -t postgres -o migration.sql

mofa db init -t postgres \
  -u "postgresql://user:pass@localhost/mofa"

mofa db init -t postgres

-- MoFA PostgreSQL Schema
-- Copy and execute this SQL to initialize your database

CREATE TABLE IF NOT EXISTS agents (
    id VARCHAR(255) PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    state VARCHAR(50) NOT NULL,
    started_at TIMESTAMP NOT NULL,
    provider VARCHAR(100),
    model VARCHAR(100),
    description TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS sessions (
    session_id VARCHAR(255) PRIMARY KEY,
    agent_id VARCHAR(255),
    created_at TIMESTAMP NOT NULL,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    metadata JSONB,
    FOREIGN KEY (agent_id) REFERENCES agents(id) ON DELETE CASCADE
);

CREATE TABLE IF NOT EXISTS messages (
    id SERIAL PRIMARY KEY,
    session_id VARCHAR(255) NOT NULL,
    role VARCHAR(50) NOT NULL,
    content TEXT NOT NULL,
    timestamp TIMESTAMP NOT NULL,
    FOREIGN KEY (session_id) REFERENCES sessions(session_id) ON DELETE CASCADE
);

CREATE INDEX idx_sessions_agent ON sessions(agent_id);
CREATE INDEX idx_messages_session ON messages(session_id);
CREATE INDEX idx_messages_timestamp ON messages(timestamp);

mofa db init -t postgres -o migration.sql

→ Generating postgres migration script...
✓ Migration script saved to: migration.sql

psql -U user -d mofa -f migration.sql

mofa db init -t postgres \
  -u "postgresql://user:pass@localhost/mofa"

→ Initializing postgres database...
  URL: postgresql://user:****@localhost/mofa
  ✓ Created table: agents
  ✓ Created table: sessions
  ✓ Created table: messages
  ✓ Created indexes
✓ Database tables initialized successfully!

mofa db init -t postgres -u "postgresql://user:pass@localhost/mofa"

mofa db init -t mysql -u "mysql://user:pass@localhost/mofa"

mofa db init -t sqlite -u "sqlite://./mofa.db"

mofa db schema -t <DB_TYPE>

mofa db schema -t postgres

mofa db schema -t postgres

-- MoFA POSTGRES Schema
-- Copy and execute this SQL to initialize your database

CREATE TABLE IF NOT EXISTS agents (
    id VARCHAR(255) PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    state VARCHAR(50) NOT NULL,
    started_at TIMESTAMP NOT NULL,
    provider VARCHAR(100),
    model VARCHAR(100),
    description TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Additional tables and indexes...

mofa db schema -t mysql

-- MoFA MYSQL Schema
-- Copy and execute this SQL to initialize your database

CREATE TABLE IF NOT EXISTS agents (
    id VARCHAR(255) PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    state VARCHAR(50) NOT NULL,
    started_at TIMESTAMP NOT NULL,
    provider VARCHAR(100),
    model VARCHAR(100),
    description TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- Additional tables and indexes...

mofa db schema -t sqlite

-- MoFA SQLITE Schema
-- Copy and execute this SQL to initialize your database

CREATE TABLE IF NOT EXISTS agents (
    id TEXT PRIMARY KEY,
    name TEXT NOT NULL,
    state TEXT NOT NULL,
    started_at TEXT NOT NULL,
    provider TEXT,
    model TEXT,
    description TEXT,
    created_at TEXT DEFAULT CURRENT_TIMESTAMP,
    updated_at TEXT DEFAULT CURRENT_TIMESTAMP
);

-- Additional tables and indexes...

-- Session lookups by agent
CREATE INDEX idx_sessions_agent ON sessions(agent_id);

-- Message lookups by session
CREATE INDEX idx_messages_session ON messages(session_id);

-- Time-based message queries
CREATE INDEX idx_messages_timestamp ON messages(timestamp);

# Basic format
postgresql://user:password@host:port/database

# Example
postgresql://mofa_user:secret@localhost:5432/mofa

# With SSL
postgresql://user:pass@host/db?sslmode=require

# Unix socket
postgresql:///dbname?host=/var/run/postgresql

# Basic format
mysql://user:password@host:port/database

# Example
mysql://mofa_user:secret@localhost:3306/mofa

# With SSL
mysql://user:pass@host/db?ssl-mode=REQUIRED

# Unix socket
mysql://user:pass@localhost/db?socket=/var/run/mysqld/mysqld.sock

# File path
sqlite://./mofa.db
sqlite:///absolute/path/to/mofa.db

# In-memory (testing only)
sqlite::memory:

agent:
  id: my-agent
  name: My Agent

# Database configuration
persistence:
  enabled: true
  
  # PostgreSQL
  database:
    type: postgres
    url: ${DATABASE_URL}
  
  # Or SQLite
  # database:
  #   type: sqlite
  #   path: ~/.local/share/mofa/mofa.db

# Session persistence
session:
  persist: true
  ttl_seconds: 86400  # 24 hours

export DATABASE_URL="postgresql://user:pass@localhost/mofa"

# Connect to database
psql -d mofa

# List tables
\dt

# Check schema
\d agents
\d sessions
\d messages

# Test query
SELECT * FROM agents LIMIT 1;

# Install with database support
cargo install mofa-cli --features db

# Or build from source
cargo build --release --features db -p mofa-cli

export DATABASE_URL="postgresql://user:pass@localhost/mofa"
mofa db init -t postgres -u "$DATABASE_URL"

# .env (add to .gitignore)
DATABASE_URL=postgresql://user:pass@localhost/mofa

# AWS Secrets Manager
DATABASE_URL=$(aws secretsmanager get-secret-value \
  --secret-id mofa/db --query SecretString --output text)

-- PostgreSQL
CREATE USER mofa_app WITH PASSWORD 'secure_password';
GRANT CONNECT ON DATABASE mofa TO mofa_app;
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO mofa_app;
GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO mofa_app;

-- MySQL
CREATE USER 'mofa_app'@'localhost' IDENTIFIED BY 'secure_password';
GRANT SELECT, INSERT, UPDATE, DELETE ON mofa.* TO 'mofa_app'@'localhost';
FLUSH PRIVILEGES;

mofa db init -t postgres -u "postgresql://localhost/mofa"
# Error: Failed to connect to PostgreSQL: ...

mofa db init -t postgres -u "postgresql://user:pass@localhost/mofa"
# Error: SQL error: permission denied for table agents

mofa db init -t postgres -u "postgresql://localhost/mofa"
# Error: Direct database execution requires the 'db' feature

cargo install mofa-cli --features db