db-operations

Database Operations

Usage: /db-operations or /db-operations <action>

Purpose: Manage PostgreSQL database operations for OpenFGA and application data

Actions:

• shell - Access database shell
• backup - Create database backup
• restore - Restore from backup
• migrate - Run migrations

---

📊 Database Overview

The MCP Server LangGraph uses PostgreSQL for:

• OpenFGA data: Authorization tuples and models
• Session data: (if configured for PostgreSQL backend)
• Application state: Persistent storage

Connection Details:

• Host: localhost
• Port: 5432
• Database: openfga
• User: postgres
• Container: postgres (via docker-compose)

---

🔧 Database Operations

Access Database Shell

Open PostgreSQL interactive shell:

make db-shell

What it does:

• Connects to PostgreSQL container
• Opens psql interactive shell
• Connected to openfga database

Example session:

openfga=# \dt
-- List all tables

openfga=# SELECT * FROM store;
-- View OpenFGA stores

openfga=# \d authorization_model
-- Describe authorization_model table

openfga=# \q
-- Quit

Common psql commands:

• \dt - List tables
• \d table_name - Describe table
• \l - List databases
• \du - List users
• \q - Quit

---

Create Database Backup

Create timestamped backup:

make db-backup

What it does:

• Creates backups/ directory if needed
• Dumps database to SQL file
• Filename: openfga_backup_YYYYMMDD_HHMMSS.sql
• Includes all tables, data, and schema

Example:

Creating database backup...
✓ Backup created in backups/

Backup file: backups/openfga_backup_20251021_143022.sql
Size: 2.4 MB

Backup includes:

• All OpenFGA stores
• Authorization models
• Tuples (user-role-resource relationships)
• Configuration data

Storage location: ./backups/

Retention: Manual cleanup (keep critical backups)

---

Restore from Backup

Restore database from backup file:

make db-restore