PostgreSQL Viewer: SQL Client

Shi Bok Jang

Contains adsIn-app purchases

About this app

A secure, feature-rich PostgreSQL client with an embedded local engine, SSH tunneling, and advanced database tools.

Key Features
• Native Embedded PostgreSQL: Built-in, natively compiled local database that runs fully standalone on your device.
• Standard SQL Dump: Generate schema and table-level dumps fully compatible with standard PostgreSQL dump format.
• Secure Connections: Encrypted connections via SSH tunneling and SSL.
• Credential Encryption: AES encryption for saved passwords, private keys, and passphrases.
• Profile Management: Seamlessly import and export connection profiles.
• Schema Explorer: Browse and inspect tables, views, procedures, functions, and triggers.
• ER Diagram: Visualize table relationships, and tap to view DDL scripts or query data.
• Smart SQL Editor: Syntax highlighting, intelligent auto-completion, and code formatting.
• Query Bookmarks: Save, organize, import, and export frequently used SQL queries.
• Execution Control: Multi-result set display and explicit transaction management.
• Performance Profiling: Built-in execution timing and profiling for SQL statements.
• Data Export: Export query results to CSV, JSON, and HTML formats.

Ratings and reviews

Connects correctly and runs queries just fine. Saving queries is not intuitive ("bookmark" then go to settings and change first view to bookmarks). I need a client that can schedule recurring queries and auto export them to a text file. This can export manually as csv or html no problem. Just needs automation.

Useful app. Works nicely if you can make a connection. Difficult to debug why not connecting sometimes. It says "Authentication type 10 is not supported". Not especially helpful as same credentials connect fOK from pgAdmin4 on other platforms.. Looks good apart from that.

Edit: developer fixed this problem in just a few days. Best and only fully working PostgreSQL client on the market. Many thanks! You deserve 5+ starts :) Old problem now fixed: Block structures don't work (RAISE NOTICE doesn't return any message)

What’s new

• Added Load support for Local Server to load SQL dump files into existing local PostgreSQL database.