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.