Gavin's Postgres Tools

postgres-lsp

Language Server Protocol implementation for PostgreSQL and PL/pgSQL. Get diagnostics, semantic highlighting, and code intelligence in your editor.

Rust
View on GitHub

pgfmt

A PostgreSQL-specific SQL statement formatter. Enforces consistent style across your SQL codebase with configurable rules.

Rust
View on GitHub

pglifecycle

A PostgreSQL schema management tool for tracking and applying DDL changes throughout the database lifecycle.

Rust
View on GitHub

tree-sitter-postgres

A tree-sitter grammar for PostgreSQL, generated directly from PostgreSQL's Bison grammar. Current as of PostgreSQL 17.

Rust
View on GitHub

libpgfmt

A Rust library for formatting PostgreSQL SQL and PL/pgSQL, powered by tree-sitter-postgres. Supports customizable formatting rules.

Rust
View on GitHub

zed-postgres

A Zed extension providing PostgreSQL and PL/pgSQL syntax highlighting, code outlines, and SQL injection support.

Rust
View on GitHub

pgdumplib

Python library for reading and writing pg_dump files using the custom format. Programmatically manipulate PostgreSQL backups.

Python
View on GitHub

libpgdump

A Rust library for reading and writing PostgreSQL dump files. Supports all three pg_dump formats: custom, directory, and tar.

Rust
View on GitHub

pgparse

Python wrapper for libpg_query, giving you access to PostgreSQL's actual SQL parser. Parse and analyze SQL statements programmatically.

Python
View on GitHub

pgpasslib

Python library for retrieving passwords from a PostgreSQL password file (.pgpass). Reads from PGPASSFILE or the default location.

Python
View on GitHub

mikkoo

A PgQ to RabbitMQ relay. Consumes PostgreSQL queue events and publishes them to RabbitMQ, with built-in retry and error handling.

Python
View on GitHub