11月1日 的 PgSQL Visual Manager 應用程式分析

PgSQL Visual Manager is a full-featured PostgreSQL client built for developers, DBAs, and data engineers who need a clean, mobile-friendly way to manage their databases — without touching a terminal. Connect to any PostgreSQL server and explore your schemas, tables, and views instantly. Run raw SQL queries with a smart editor, browse and edit rows visually, and export results in seconds. ────────────────────────────── 🔌 CONNECTIONS ────────────────────────────── • Save multiple named connections with custom color labels • SSH tunnel support — connect through a jump server with password or private key • SSL/TLS encryption with optional client certificates (Root CA, Client Cert, Client Key) • Test any connection before saving • Secure local credential storage — your passwords never leave your device ────────────────────────────── 🗂️ DATABASE EXPLORER ────────────────────────────── • Browse all schemas, tables, and views in a clean sidebar layout • Switch databases on an active connection without reconnecting • Filter tables by schema or search by name in real time • Visual distinction between tables and views • Optimized for both phone and tablet screen sizes ────────────────────────────── 📊 TABLE VIEWER & EDITOR ────────────────────────────── • Paginated data grid with 25 / 50 / 100 / 200 rows per page • Sort by any column with a single tap • Filter rows using a WHERE clause bar — same as your favorite desktop tool • Insert new rows with smart per-column controls: — Date, time, and datetime pickers for temporal columns — NULL toggle for nullable fields — Number keyboards for numeric types — Primary key fields locked in edit mode • Edit and delete rows with confirmation • Long-press any cell to copy its value to clipboard ────────────────────────────── ✍️ QUERY EDITOR ────────────────────────────── • Syntax-highlighted SQL editor with line numbers (Atom One Dark/Light) • Context-aware autocomplete in 3 modes: — SQL keywords & functions (SELECT, WHERE, COALESCE, ROW_NUMBER…) — Table names after FROM, JOIN, UPDATE, INTO — Column names after WHERE, SET, SELECT — fetched live from your schema • Execution time, affected rows, and row count shown after every query • Export results to CSV or JSON with one tap ────────────────────────────── 🔒 SECURITY FIRST ────────────────────────────── • All credentials stored with Flutter Secure Storage (Keystore / Keychain) • SSL modes: disabled, require, verify-server • Full SSH tunneling with private key file support • Automatic keepalive and reconnect — idle connections stay alive ────────────────────────────── 🎨 DESIGNED FOR DAILY USE ────────────────────────────── • Full dark and light theme support • Responsive layout — sidebar on tablets, drawer on phones • Monospace font throughout for readability • Clean Material 3 design with color-coded connections • Copy any value to clipboard with a single tap ────────────────────────────── PERFECT FOR ────────────────────────────── ✔ Backend and full-stack developers ✔ Database administrators managing remote servers ✔ DevOps engineers needing quick on-the-go access ✔ Data analysts running ad-hoc queries ✔ Anyone who wants pgAdmin-level access from their phone PgSQL Visual Manager is open, lightweight, and built with Flutter — delivering a native experience on Android with no bloat or subscription required.