PgSQL Visual Manager

Turn L.L.C

About this app

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 using a terminal.

Connect to any PostgreSQL server and instantly explore your schemas, tables, and views. 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 colour labels
• SSH tunnel support — connect through a jump server using a 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
• Clear visual distinction between tables and views
• Optimised 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 — just like your favourite 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 the clipboard

──────────────────────────────
✍️ QUERY EDITOR
──────────────────────────────
• Syntax-highlighted SQL editor with line numbers: Atom One Dark/Light
• Context-aware autocomplete in 3 modes:
— SQL keywords and 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 tunnelling with private key file support
• Automatic keepalive and reconnect — idle connections stay active

──────────────────────────────
🎨 DESIGNED FOR DAILY USE
──────────────────────────────
• Full dark and light theme support
• Responsive layout — sidebar on tablets, drawer on phones
• Monospace font throughout for better readability
• Clean Material 3 design with colour-coded connections
• Copy any value to the clipboard with one tap

──────────────────────────────
PERFECT FOR
──────────────────────────────
✔ Backend and full-stack developers
✔ Database administrators managing remote servers
✔ DevOps engineers needing quick access on the go
✔ 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 Android experience with no bloat or required subscription.

What's new

Small Changes