PSequel

Small tool for quick sql query, specialized in PostgresSQL. Written in Vala for GNOME desktop in the hope to be useful.

This project is not a part of or affiliated with PostgreSQL.

Features

• Load and save connections.
• Import and Export connections info
• List schema info, tables, views.
• View table columns info, indexes, foreign keys
• View table data, sort by column
• Write query
• Query History
• Hightlight current query
• Export query data

Installation

Flatpak

Recommended

Click here to install app from Flathub.

Build from source

Via GNOME Builder

PSequel can be built with GNOME Builder >= 3.38. Clone this repo and click run button.

(Warning: required to rebuild postgres, will take a little bit of time)

Via Meson

You really don't want to do this unless you want to contribute to this project.

Fedora 40 instuctions

sudo dnf install vala gtk4-devel libadwaita-devel json-glib-devel gtksourceview5-devel libpq-devel sqlite-devel libcsv-devel

Install - pgquery-vala

git clone --recurse-submodules https://github.com/ppvan/pg_query_vala.git

meson setup --prefix=/usr build/ && ninja -C build install

Other distro

TBU

Psequel can be built directly via Meson:

git clone https://github.com/ppvan/psequel
cd psequel
meson build
cd build
meson compile

Next, it can be installed by meson install.

Dependencies

If you use GNOME Builder or Flatpak, dependencies will be installed automatically. If you use pure Meson, dependencies will be:

• vala >= 0.56
• gtk >= 4.16
• gtksourceview >= 5.0
• gio >= 2.80
• json-glib >= 1.6
• libadwaita >= 1.6
• postgres-libs >= 16.2
• libcsv >= 3.0
• pgquery-vala

Contributions

Contributions are welcome.

Credits

• Psequel - MacOS postgresql client. This project is inspired by Psequel.
• libpg_query - PostgresSQL parser
• libcsv - Robust C csv library