Database Tools

GAGOS provides tools for connecting to and managing PostgreSQL, MySQL, and Redis databases.

PostgreSQL

Connecting

1. Open PostgreSQL window from desktop
2. Enter connection details (host, port, database, user, password)
3. Enable SSL if required
4. Click "Connect"

Features

• Query Editor - Execute SQL queries
• Schema Browser - View tables, columns, indexes
• Table Data - Browse table contents
• Export - Dump database or tables

Query Execution

1. Enter SQL in the query editor
2. Click "Execute" or press Ctrl+Enter
3. Results display in table format
4. Export results as CSV

MySQL

Connecting

1. Open MySQL window from desktop
2. Enter connection details
3. Click "Connect"

Features

• Query Editor - Execute SQL queries
• Schema Browser - View databases, tables, columns
• Table Data - Browse and search table contents
• Export - Dump database

Redis

Connecting

1. Open Redis window from desktop
2. Enter host, port, and optional password
3. Select database number (0-15)
4. Click "Connect"

Features

• Key Browser - Browse all keys with pattern filter
• Key Types - String, List, Set, Hash, ZSet support
• Command Console - Execute raw Redis commands
• Cluster Info - View server info and statistics

Key Operations

• View key value and TTL
• Edit string values
• Delete keys
• Set expiration

Connection Presets

Each database tool includes presets for common configurations:

• Localhost - Default local connection
• Kubernetes - Connect to services in cluster

Security Notes

• Credentials are not stored - enter each session
• Use SSL/TLS when connecting over network
• Connections are made from GAGOS container, not your browser