postgres-ops

What problem does it solve?

This skill enables developers to quickly set up and manage a local PostgreSQL environment for development and testing, eliminating manual configuration and environment drift.

Core Features & Use Cases

• Start a local PostgreSQL container with Docker for development environments.
• Connect and interact with PostgreSQL using psql and standard connection strings.
• Manage databases, users, backups, and restores, and inspect schemas and queries to validate changes.
• Use practical examples like creating a dev database, restoring from a backup, or validating a migration.

Quick Start

Start a local PostgreSQL container with Docker and connect to it using psql to create and manage databases.