rgrip

Free · open source · 9 MB

PostGIS, without opening QGIS.

A tiny native PostgreSQL client that puts any query's geometry on a map: UTM, Web Mercator, even ArcGIS st_geometry. Then copy the rows as an image and drop them in the team chat.

Download for macOS View on GitHub

macOS · Apple silicon · MIT OR Apache-2.0

  • 9 MBdownload
  • ~75 MBmemory at idle
  • 0%CPU when idle
  • No JVMno Electron, just Rust
rgrip main window: schema explorer, SQL console and results grid

Features

PostGIS
Readable geometry cells and a built-in map that reprojects WGS84, Web Mercator and UTM on the fly.
SQL console
Highlighting, context-aware autocomplete, a formatter (⇧⌘F), saved queries, and slash commands like /count that expand into full queries.
Results grid
Virtualized with server-side paging, multi-row selection and frozen columns. Export to CSV, JSON, GeoJSON, Markdown, SQL or SVG, or copy rows as an image.
Inline editing
Double-click a cell to edit it, with a date/time picker for date and time columns. Changes are saved in one transaction, matched on the primary key.
Relations
Follow foreign keys in both directions from any row, in a popup you can chain.
Connections
SSL up to verify-full with client certificates, SSH tunnels, and paste-in connection strings.

A closer look

Little workflows that add up.

PostGIS

See your data on a map

Geometry columns become readable cells and one click puts them on a map. Pick a dark, light, streets or satellite basemap. rgrip reprojects WGS84, Web Mercator and UTM on the client and flags features that landed in the wrong hemisphere (hello, swapped lat/lon).

PostGIS map view with feature popup

Editing

Edit cells in place

Double-click, pick a date from the calendar, set NULL. Pending changes stay highlighted until you save, and then everything goes out in a single transaction keyed on the primary key. If one row fails, nothing changes.

Inline cell editing with a date picker

Relations

Follow foreign keys, both ways

Right-click a row and jump to the rows it points to, or the rows pointing at it. Keep chaining, step Back, or promote any hop to its own tab.

Related-rows popup following foreign keys

Grid

Pin what matters

Freeze columns so keys and names stay put while you scroll through wide tables. The grid is virtualized and pages 1,000 rows at a time from the server.

Results grid with frozen columns

Sharing

Copy as image

Need to show someone a result? One click copies a PNG of the table to your clipboard, ready to paste into Telegram or Slack. There is also Copy for AI agent, which gives you markdown with the query and column types.

A table copied as a PNG image

Keyboard shortcuts

⌘↩
Run statement
⇧⌘↩
Run all (script)
⌘S
Save query / save edits
⇧⌘F
Format SQL
⌘N
New query
⌘W
Close tab
Tab
Expand slash command

Get rgrip

Grab the Apple silicon zip from GitHub Releases, unzip, and open. Updates arrive in-app.

Download for macOS Star on GitHub

Build from source

Needs Rust 1.88 or newer.

git clone https://github.com/yoouTaro/rgrip && cd rgrip && cargo run -p rgrip

Buy me a coffee ☕

rgrip is free and open source. If it saves you time, a coffee helps keep the late-night commits flowing. Sponsorships go through GitHub Sponsors, which passes on 100% to the maintainer.

☕ Buy me a coffee

Vibe-coded with ☕ and an AI pair programmer.