QueryDock for PostgreSQL
Native PostgreSQL client for Android — browse schemas, run queries, and manage databases, tables, and users.
About
QueryDock for PostgreSQL is a native Android client that brings phpMyAdmin- and DBeaver-class database management to a mobile-optimized interface — "DBeaver in your pocket." Built with Kotlin, Jetpack Compose, and Material 3, it is a dedicated PostgreSQL client built on a SqlDialect SQL-generation layer (PostgresDialect), going deep on PostgreSQL-specific types and modern features such as JSONB, pgvector, and logical replication.
Features
- Multiple server profiles (host/port/database/user, SSL, read-only) with connection testing and instant switching
- Passwords encrypted in the Android Keystore (EncryptedSharedPreferences), SSH tunnel (local port forwarding, password or PEM private key + passphrase), and biometric app lock
- DB → schema → object tree (tables, views, materialized views, sequences, functions) with search
- Paginated data grid with sorting and cell detail, row CRUD with preview-SQL confirmation, and foreign-key jumps
- SQL editor with schema-aware autocomplete, syntax highlighting, EXPLAIN/ANALYZE, manual transactions (BEGIN/COMMIT/ROLLBACK), and destructive-statement warnings
- Result charts (bar/line/pie), CSV/JSON export, and transactional CSV import
- DDL tools: table-creation wizard, ALTER (add/rename/drop columns, rename table), object DROP, and schema diff between two tables
- JSON/JSONB tree and raw viewer with inline validation, sorting, path-extraction builder, and key statistics
- Vector search with pgvector nearest-neighbor (L2
<->, cosine<=>, inner product<#>), plus session, user/role, and extension/logical-replication insights