Postgres & Friends v1.0 · iPhone & iPadNEW

Postgres and friends,
in your pocket.

A local-first database client for iPhone and iPad. Connect to PostgreSQL, MySQL, SQLite, Redis, MongoDB, and Cloudflare D1 — browse tables, run SQL, and tunnel over SSH from wherever you are.

Free to start iPhone · iPad No account required
app-local-v1.db
Databases
Local Encryption
AES-256 Enabled
Tables (5)
users
orders
teams
api_keys
sessions
URI:postgresql://admin:f47a_982c@db.forge.internal:5432/prod_users
SQL Intellisense v2.1
1SELECT
2 users.id,
3 users.email,
4 count(orders.id) as total_orders,
5 SUM(orders.amount_usd) as life_value
6FROM users
7JOIN orders ON users.id = orders.user_id
8WHERE orders.status = 'completed'
9GROUP BY users.id
10ORDER BY life_value DESC
11LIMIT 3;
Results Grid Success in 1.42ms
idemailtotal_orderslife_value
usr_8fa2sarah.k@stripe.com14$2,480.00
usr_9b1calex@indiehackers.net8$1,120.00
usr_2d7ed.heinemeier@37signals.com6$890.00
Postgres, and friends

Six engines,
one app on your home screen.

Postgres is the one we named it after. Redis keys, Mongo documents, a SQLite file, a MySQL box, and Cloudflare D1 at the edge all live in the same connection list — no second app to install.

Relational
Latency::5432

PostgreSQL

The one on the icon. Browse schemas and tables, page through rows, and run whatever SQL you need against them.

Workspace Highlights
Multiple databases per connection
Table browsing and structure view
SQL editor with history
In-Memory
Latency::6379

Redis

Key-value storage, browsable. Walk the keyspace, read values, and check what is actually cached in there.

Workspace Highlights
Keyspace browsing
Value inspection
Database index selection
NoSQL Document
Latency::27017

MongoDB

Document storage without the ceremony. Open a collection, page through documents, and read nested fields in full.

Workspace Highlights
Collection browsing
Document detail viewer
Connection-string and SRV support
Relational
Latency::3306

MySQL

Where this app started. Full table browsing, SQL execution, and a built-in cheat sheet for the syntax you forgot.

Workspace Highlights
Multiple databases per connection
Built-in MySQL cheat sheet
SQL editor with history
Embedded Engine
Latency:file

SQLite

A database that is just a file. Open one from the Files app and query it like any other connection.

Workspace Highlights
Open a .db file from Files
Full SQL execution
No server required
Edge SQLite
Latency:REST

Cloudflare D1

SQLite-at-the-edge over Cloudflare's REST API. Browse multiple D1 databases on the same account from one workspace.

Workspace Highlights
REST API transport
Account-wide DB browser
Bearer-token auth
Core capabilities

A real client.
on a phone-sized screen.

Not a dashboard, not a wrapper around someone else's API. The same things you do in a desktop client, laid out for a thumb.

Write SQL, get rows

A proper editor with syntax highlighting, not a single-line text field. Run a statement, page through the result set, and tap any row to read it in full. Every query you run is kept in a local history you can go back to.

Syntax highlightingQuery historySaved queries
EDITORpostgres · main
SELECT id, email, plan, created_at
FROM users
WHERE plan = 'pro'
ORDER BY created_at DESC
LIMIT 50;
RESULT50 rows · 12 ms
8812ana@fastmail.compro
8809kenji@example.jppro
8804r.silva@corp.brpro

Tunnel in over SSH

Most databases worth reaching are not open to the internet. Point the connection at a bastion you can already log into — password or OpenSSH private key — and the port is forwarded for you.

TUNNEL● CONNECTED
Your iPhoneed25519 key in Keychain
Bastion hostbastion.internal:22
Database10.0.18.254:5432

The cheat sheet

Nobody remembers every bit of syntax on a phone keyboard. A built-in, filterable reference sits one tap from the editor, so you can look up the statement you half-remember without leaving the app.

alter
ALTER TABLE … ADD COLUMNAdd a column to a table
ALTER TABLE … RENAME TORename an existing table
ALTER INDEX … RENAME TORename an existing index

Browse, search, hand it off

Walk the database and table list, page through rows without loading a million of them, search inside a result set, and check the column types when something looks wrong. When someone asks for the numbers, share the rows as CSV straight from the share sheet.

Paginated rowsStructure viewCSV share
public.users CSV
Structure
id int8email varcharplan varcharcreated_at timestamptz
Rows
8812 · pro8809 · pro8804 · pro
Page 1 of 241–50 of 1,183
How it goes

Three steps
from locked screen to answer.

Streamline your architectural operations with a workspace built specifically to integrate with your local CLI and Git repositories.

01. Connect

Setup

Paste a connection string and you're in

Type the host, user, and password, or paste a connection URI and let the app fill the form for you. Tag the connection by environment so you can tell staging from production at a glance — and add an SSH tunnel if the database is not reachable directly.

Under the hood
Connection-string input
SSH tunnel with password or private key
Environment tags on every connection

02. Look around

Browse

Databases, tables, rows, structure

Move from the database list into a table and page through its rows without dragging the whole thing down the wire. Search inside the results, tap a row to read long values in full, and switch to the structure view when you need column types and keys.

Under the hood
Multiple databases per connection
Paginated rows with search
Row detail and structure views

03. Run and share

Finish

Your SQL, and the answer to send back

Write a statement in the editor, run it, and keep it — query history and saved queries are stored locally so the thing you worked out last week is still there. When someone needs the result, export the rows as CSV and send them from the iOS share sheet.

Under the hood
SQL editor with syntax highlighting
Local query history and saved queries
CSV export via the share sheet
Privacy by default

Local-first architecture.
absolute query privacy.

A database client has no business acting as a middleman. Postgres & Friends talks directly to the servers you point it at, and everything it remembers about them stays inside the app sandbox on your device.

No account, no backend

There is nothing to sign up for. The app connects straight from your device to your server — we do not run a proxy, and there is no analytics or telemetry SDK collecting what you query.

Credentials in the Keychain

Hostnames, usernames, passwords, and SSH keys are stored in the iOS Keychain and the app's own sandbox container. They never sync to a service we control.

SSH tunnels built in

Reach a database that is not exposed to the internet by tunnelling through a bastion host. Password and OpenSSH private key authentication are both supported.

Your history stays yours

Saved queries and query history are written to the app's local Application Support directory. Delete the app and every trace of them goes with it.

The short versionWe cannot leak what we never receive.
NO ACCOUNTNO SERVERNO TELEMETRY
Simple Pricing

Free to start.
cheap to keep.

All purchases are made in-app through the App Store. Pro unlocks the same features on iPhone and iPad.

Free

Everything you need to poke at a database from your phone.

$0forever

  • Up to 3 saved connections
  • PostgreSQL, MySQL, SQLite, Redis, MongoDB & Cloudflare D1
  • Browse tables with paginated results
  • Run SQL and keep a local query history
  • SSH tunnel support, including private keys
  • Credentials stay in the device Keychain
Get it on the App Store
RECOMMENDED

Pro

For when one database stops being enough.

$3.99/ month

or $9.99 / year — save 79%

  • Everything in Free
  • Unlimited saved connections
  • Unlimited open tabs
  • Full SQL editor with syntax highlighting
  • Export and share results as CSV
  • Light mode and accent themes
Start with Pro

Lifetime

Pay once. Never think about it again.

$19.99one time

No subscription, no renewal

  • Every Pro feature, permanently unlocked
  • All future iOS updates included
  • Restores on any device with your Apple Account
Buy Lifetime
Common Inquiries

Frequently asked questions

Everything you need to know about security, schemas, offline workflows, and licensing.

PostgreSQL, MySQL, SQLite, Redis, MongoDB, and Cloudflare D1. You can browse databases and tables, page through rows, search results, inspect table structure, and run your own SQL against the engines that speak it.