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.