PGlite Client

The PGlite GUI Client for Mac.

A fast, native PGlite GUI client for Mac. PGlite is PostgreSQL 17 compiled to WebAssembly, so TablePro reaches it through its socket server, @electric-sql/pglite-socket, using the same libpq driver as PostgreSQL. Browse the public schema, run DDL, read visual EXPLAIN plans, and edit rows the way you would against a full PostgreSQL server. Free and open source.

Download for Mac Read the docs

TablePro connected to a PGlite database showing the data grid and SQL editor

Features

Built for PGlite.

Socket Server Connection

PGlite runs in-process in JavaScript, so TablePro talks to it over the PostgreSQL wire protocol through @electric-sql/pglite-socket. The socket server binds 127.0.0.1:5432 by default and uses trust auth, so the form has no password field.

Real PostgreSQL 17 Catalogs

pg_catalog and information_schema are complete. Table and view definitions, indexes, foreign keys, and structure editing behave exactly as they do on PostgreSQL.

Single Connection Handling

PGlite serves one client at a time, and TablePro keeps to one connection, serializing schema browsing, autocomplete, and row counts over it. Cancelling a running query has no effect at the protocol level, since PGlite has no backend process to signal.

Visual EXPLAIN Plans

EXPLAIN and EXPLAIN ANALYZE render as a plan tree, the same view PostgreSQL connections get.

AI Assistant and SQL Editor

Ask in English and get PostgreSQL SQL, with schema-aware autocomplete in the editor. The AI Rules pane holds per-connection guidance the assistant sees on every chat turn.

Import and Export

Export results to CSV, JSON, SQL, or XLSX. Import from CSV, JSON, or SQL.

Data Grid

Browse and edit data.

Sort, filter, and edit PGlite data in a spreadsheet-like grid. Click any cell to edit. Insert and delete rows. Review changes before saving.

TablePro data grid showing PGlite table rows with inline editing

SQL Editor

Write queries faster.

Tree-sitter syntax highlighting, schema-aware autocomplete, multi-tab, Vim mode, and full-text query history. AI assistant can write, explain, or optimize your SQL.

TablePro SQL editor with PGlite query and autocomplete

Capabilities

What you can do.

Connect over the PostgreSQL wire protocol
Browse the public schema and pg_catalog
Run DDL and edit table structure
Read visual EXPLAIN and EXPLAIN ANALYZE plan trees
Switch the active schema from the sidebar menu
Export to CSV, JSON, SQL, or XLSX
Import from CSV, JSON, or SQL
Ask the AI assistant for PostgreSQL SQL

Connect

Get connected in seconds.

# 1. Start the PGlite socket server
npx @electric-sql/pglite-socket            # in-memory
npx @electric-sql/pglite-socket --db=./my-pgdata   # persisted

# 2. Connect with TablePro
Host: 127.0.0.1
Port: 5432
Database: postgres
Username: postgres

# Connection URL
pglite://[email protected]:5432/postgres

Supported versions

PGlite, a build of PostgreSQL 17 compiled to WebAssembly

Connection types

Socket server (@electric-sql/pglite-socket)
TCP on loopback 127.0.0.1
Trust auth (no password)

Default port

5432

How to

Connect to PGlite in four steps.

1
Install TablePro
brew install --cask tablepro, or grab the DMG from tablepro.app/download. The PostgreSQL driver PGlite uses ships built in.
2
Start the socket server
Run npx @electric-sql/pglite-socket, or npx @electric-sql/pglite-socket --db=./my-pgdata to persist. Leave it running.
3
Open New Connection
Click New Connection, pick PGlite. Host 127.0.0.1, port 5432, database postgres, username postgres. There is no password field.
4
Connect
Click Save & Connect. The public schema appears in the sidebar, and Cmd+K lists the single postgres database.

FAQ

Common PGlite questions.

Do I need to run anything before connecting?

Yes. PGlite has no server of its own. Start one with npx @electric-sql/pglite-socket, or add --db=./my-pgdata to persist, and leave it running while you use the connection.

Why does the connection fail on localhost?

The socket server binds loopback IPv4. Use 127.0.0.1, since localhost can resolve to IPv6 first. Also confirm the port matches the server's --port.

Is TablePro free for PGlite?

Yes. AGPLv3 open source. PGlite uses the built-in PostgreSQL driver, so there is no plugin to install from the registry.

Can I use SSH tunnel or SSL?

No. The socket server has no TLS and rejects SSL, so SSL Mode is fixed to Disabled and the SSH, Cloudflare Tunnel, and SOCKS panes do not apply.

Can another tool stay connected at the same time?

No. The socket server serves one client at a time, and a second client gets a too many connections error. Close the other client and reconnect.

Try TablePro for free.

Free and open-source. macOS 14+. Apple Silicon and Intel.

Download for Mac Setup guide