Monitor PostgreSQL databases in real-time from your iPhone. Live query tracking, connection monitoring, and transaction throughput metrics.

psq4ios - PostgreSQL Monitor

Monitor your PostgreSQL databases in real-time, directly from your iPhone or iPad.

Overview

psq4ios brings professional PostgreSQL monitoring to iOS. Connect securely to your databases and get instant visibility into server performance, active queries, connection states, and transaction throughput.

Key Features

Real-Time Monitoring

• Live dashboard refreshing every 2 seconds
• Active query tracking with execution time
• Connection state breakdown (active, idle, idle in transaction)
• Transaction throughput (TPS) with 5-minute sparkline visualization
• Replication stream health monitoring

Query Management

• View full query text with syntax highlighting
• Cancel or terminate long-running queries
• Copy queries to clipboard for analysis
• Color-coded query states and execution times
• Sort by duration to identify bottlenecks

Server Management

• Manage multiple PostgreSQL servers
• Custom colors and icons for easy identification
• Secure password storage in iOS Keychain
• Drag to reorder servers
• Last connected timestamp tracking

Import & Export

• Import servers from pg_service.conf files
• Bulk import multiple database connections
• Quick setup from existing configurations

Security

• Direct TLS-encrypted connections to PostgreSQL
• No third-party services or data collection
• Passwords stored securely in iOS Keychain
• All monitoring happens on-device

Native iOS Experience

• Built with SwiftUI for smooth, native performance
• Dark mode support
• SF Symbols throughout
• Optimized for iPhone and iPad

Perfect For

• Database Administrators: Monitor production databases from anywhere
• DevOps Engineers: Quick troubleshooting on the go
• Backend Developers: Check query performance during development
• Site Reliability Engineers: Respond to incidents from mobile

Technical Details

• Connects directly to PostgreSQL 9.4+
• Uses PostgresNIO for robust connectivity
• TLS 1.2+ encryption required
• Supports standard PostgreSQL authentication
• Queries pg_stat_activity, pg_stat_database, and pg_stat_replication

Requirements

• iOS 26.0 or later
• Network access to your PostgreSQL servers
• PostgreSQL server with TLS enabled
• Valid database credentials with appropriate permissions

Privacy

PSQ respects your privacy:

• No analytics or tracking
• No data sent to third parties
• All connections are direct from your device to your servers
• Passwords stored only in iOS Keychain

Support

Need help? Contact us at support@psq.lol or visit our website for documentation and guides.