psq vs Postgres Editor

# 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.

Postgres Editor is a native PostgreSQL client built for every Apple platform — iPhone, iPad, Mac, and Apple Vision Pro. Written entirely in Swift with SwiftUI and powered by Swift NIO, it's the fastest, most seamless way to query and explore your databases wherever you are. Your connections, everywhere: Connections sync automatically via iCloud, so your databases are ready the moment you open the app on any of your devices. Add a connection once, use it everywhere. A query editor that keeps up with you. Write SQL with full syntax highlighting, run queries with a tap, and see results instantly. Export to JSON, browse your schema, and manage multiple connections across production, staging, and local environments — all in one place. AI-Powered Query Assistant. Powered by Apple Intelligence, the built-in Query Assistant understands your SQL in context. Ask it to explain a complex query, find performance issues, or suggest optimizations — without leaving the editor. Built for every Apple platform. iPhone & iPad — Query your databases on the go with a touch-first interface designed for mobile Mac — A full-featured desktop editor with sidebar navigation, multi-connection management, and keyboard-first workflows Apple Vision Pro — Explore your data in a new dimension with a spatial interface that floats in your environment Everything you need, nothing you don't. Native Swift & SwiftUI — fast, responsive, and at home on every Apple platform Swift NIO networking — low-latency, non-blocking database connections iCloud sync for connections across all your devices Saved queries with search Schema browser — navigate databases, tables, and columns instantly SSL support JSON export with one tap Full query log with execution times