Postgres Erd drawing using your android device

rafi farchi — Sat, 26 Sep 2026 14:49:32 +0000

Title: How to Generate and Present PostgreSQL ERDs Directly on Your Phone in 2 Minutes

As developers and DBAs, we often need to quickly review database schemas, share entity-relationship diagrams (ERDs) with team members during a call, or project a clean diagram onto a screen for a presentation.

Instead of opening a desktop IDE or setting up complex web tools, here is how you can generate, inspect, and present PostgreSQL ERDs directly from your Android device in just a few taps.

Step-by-Step Guide: From Connection to ERD

1. Download & Install the Tool

First, install Postgres Client - Studio (Free on Google Play):
👉 Get Postgres Client - Studio on Google Play Store

2. Configure Your Database Connection

Open the app and configure your cloud or remote PostgreSQL database connection details (SSL and standard connections supported).

3. Navigate to "Draw ERD"

Select your active database connection and open the Draw ERD feature from the workspace menu.

4. Select Target Schema

Choose the schema you want to visualize from the dropdown list.

5. Select Your Tables

Pick the relevant tables you want to focus on (for optimal viewing, selecting up to 25 tables works best for clear layout and readability).

6. Automatic Dependency Resolution

The built-in engine automatically detects foreign keys and auto-includes linked tables required to make the ERD complete and structurally accurate.

7. View, Cast, or Print

View and zoom into the interactive diagram directly on your phone.
Stream/Cast your mobile screen to a larger display or projector for team presentations.
Print or export as needed.

Bonus: Rendering engine credit

The visualization logic exports and processes rules compatible with the open-source JavaScript layout library [mermaid.js / viz.js]. Special thanks to the open-source community for maintaining these visualization frameworks!

Try It Out & Share Your Feedback

If you manage PostgreSQL databases on the go, try this workflow and let me know how it fits into your day-to-day work.

I'm actively improving the app based on developer feedback—feel free to drop a comment below with suggestions, feature requests, or questions!

Postgres client and Studio

rafi farchi — Tue, 22 Sep 2026 21:54:13 +0000

I’ve recently released Postgres Client - Studio, a mobile client designed for DBAs, system architects, and developers who need a robust tool to explore, manage, and query PostgreSQL databases directly from their mobile devices.

Unlike many mobile utilities that lock key features behind paywalls or limit connections, I wanted to create a tool that covers the entire workflow on the go.

Key Features:

Unlimited Connection Management: Easily create, manage, export, and import your connection profiles.
Hierarchical Object Browser: Deep dive down to the schema level with full support for all PostgreSQL object types.
Reverse DDL Generation: Generate clean DDL scripts directly from existing database objects.
Data Browsing & Editing: View, update, and export table data seamlessly.
Automated ERD Generation: Instant, zero-config Entity-Relationship Diagrams generated automatically from your metadata.
Offline Workspace: Draft, prepare, edit, and store your SQL queries and scripts offline before running them.
Interactive Query Execution: Run complex queries and scripts against your live databases with clear output displays.

I'd Love Your Feedback!

Since this is a newly launched tool, I'm actively looking for real-world testing and input from the PostgreSQL community.

Whether it's feature requests, UI/UX suggestions, or performance feedback:

Give it a try on the Google Play Store: https://play.google.com/store/apps/details?id=com.storage.postgres_studio
Let me know in the comments below what you think or what features you'd like to see next!

Thanks for checking it out!

DEV Community: rafi farchi