## 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

#### Databases Panel

#### Create Database

#### Schema Browser

#### Query Editor

#### ERD Visualization

#### Table-Centered ERD

#### Foreign Key Preview

#### Database Analysis

#### Claude Code Terminal

## 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

×