PostgreSQL Explorer
with AI Superpowers

Browse schemas, write SQL, and explore your database with an embedded Claude Code terminal. Built entirely through vibe coding with Claude.

PgVoyager Screenshot

Features

Schema Browser

Explore schemas, tables, views, functions, sequences, and custom types. See column details, constraints, indexes, and relationships at a glance.

SQL Query Editor

Full-featured editor powered by CodeMirror with syntax highlighting, autocomplete, error highlighting, and query history tracking.

Claude Code Terminal

An embedded AI assistant that can explore your schema, write SQL queries, execute them, and help you understand your data.

Foreign Key Preview

Hover over any FK value to instantly see the referenced record. No more jumping between tables to understand relationships.

ERD Visualization

Interactive entity relationship diagrams. View table relationships, navigate between tables, and export as PNG, SVG, JSON, or SQL DDL.

Database Analysis

Analyze database health with one click. Find missing indexes, table bloat, unused indexes, and more with actionable SQL fixes.

Connection Management

Save and manage multiple database connections. Quick connect/disconnect with a dropdown menu for easy switching.

Database Management

Connect once per server and browse every database on it. Switch databases from the sidebar, create new ones with a click, or drop databases — all without leaving PgVoyager.

Screenshots

Installation

curl -L https://github.com/thelinuxer/pgvoyager/releases/latest/download/pgvoyager-linux-amd64.tar.gz | tar xz
cd pgvoyager-linux-amd64
./install.sh

To install with a custom port: ./install.sh 8080

curl -L https://github.com/thelinuxer/pgvoyager/releases/latest/download/pgvoyager-darwin-arm64 -o pgvoyager
chmod +x pgvoyager
PGVOYAGER_MODE=production ./pgvoyager

Then open http://localhost:5137 in your browser.

# Download pgvoyager-windows-amd64.zip from releases
# Extract and run:
.\install.ps1

To install with a custom port: .\install.ps1 -Port 8080

Prerequisites

  • Claude Code CLI - For the embedded AI assistant (npm install -g @anthropic-ai/claude-code)
  • PostgreSQL - A database to connect to