psq - postgres monitor utility

# 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 [email protected] or visit our website for documentation and guides.