sosedoff /pgweb

Cross-platform client for PostgreSQL databases

★ 9,556⑂ 877👁 136⑃ 445● 426▤ 55
GoMITCreated 2014-10-09sosedoff.github.io/pgweb
下载:0.17.00.17.0 ↓0.17.02025-11-22
+0
日增长
9,556
stars
877
forks
136
watchers
445
prs
426
issues
55
releases

README

pgweb

Simple web-based and cross platform PostgreSQL database explorer.







 Overview

Pgweb is a web-based database explorer for PostgreSQL, written in Go, and works
on Mac, Linux and Windows machines. Distributed as a simple binary with zero dependencies.
Very easy to use and packs just the right amount of features.

See application screenshots

 Features

- Cross-platform: Mac/Linux/Windows (64bit).
- Simple installation (distributed as a single binary).
- Zero dependencies.
- Works with PostgreSQL 9.6+.
- Supports native SSH tunnels.
- Multiple database sessions.
- Execute and analyze custom SQL queries.
- Table and query data export to CSV/JSON/XML.
- Query history.
- Server bookmarks.

Visit WIKI for more details.

 Demo

Visit https://pgweb-demo.fly.dev/ to see Pgweb in action.

 Installation

- Precompiled binaries for supported operating systems are available.
- More installation options

 Usage

Start server:


pgweb


You can also provide connection flags:


pgweb --host localhost --user myuser --db mydb


Connection URL scheme is also supported:


pgweb --url postgres://user:password@host:port/database?sslmode=[mode]
pgweb --url "postgres:///database?host=/absolute/path/to/unix/socket/dir"


 Multiple database sessions

To enable multiple database sessions in pgweb, start the server with:


pgweb --sessions


Or set environment variable:


PGWEB_SESSIONS=1 pgweb


 Testing

Before running tests, make sure you have PostgreSQL server running on localhost:5432
interface. Also, you must have postgres user that could create new databases
in your local environment. Pgweb server should not be running at the same time.

Execute test suite:


make test


If you're using Docker locally, you might also run pgweb test suite against
all supported PostgreSQL version with a single command:


make test-all


 Contribute

- Fork this repository
- Create a new feature branch for a new functionality or bugfix
- Commit your changes
- Execute test suite
- Push your code and open a new pull request
- Use issues for any questions
- Check wiki for extra documentation

 License

The MIT License (MIT). See LICENSE file for more details.

Top issues

Latest release

0.17.0 v0.17.0 2025-11-22
Changes

- NEW Update Dockerfile to use Golang 1.24 image, GH-821
- NEW Bump go crypto package to 0.44.x, GH-820, GH-823
- NEW Add PostgreSQL 18 support to Github Actions, GH-816
- NEW Connect backend refactor, GH-801
- NEW Add server settings view, GH-768
- NEW Add exec time of empty queries, GH-763
- FIX Minor typos, GH-764, GH-786
- FIX Shorten git revision printed in the --version output, GH-770

 SHA256 Checksums


22cc0c500ac95917146f3b193276eb44c4aa91ca093e31a3f925d5423d74764a pgweb_darwin_amd64
da73e100ce78288c04b84e225503763b8841383e52981e5196f87e00c3440287 pgweb_darwin

Snapshot: 2026-11-16T09:23:14Z · Data license Apache-2.0 · JSON