postgres-setup

What problem does it solve?

Manually configuring PostgreSQL databases, users, permissions, and schema can be a repetitive and error-prone task. This Skill automates the entire setup process, applying standardized best practices for schema definition and providing robust Python scripts for idempotent database provisioning.

Core Features & Use Cases

• Automated Provisioning: Creates databases and users with appropriate permissions, handling both production and test environments.
• Schema-Logic Separation: Clearly separates SQL schema definitions (schema.sql) from Python-based setup logic (setup_database.py).
• Best Practices: Enforces UUID primary keys, Unix timestamps for dates, and idempotent operations (CREATE IF NOT EXISTS).
• Use Case: Rapidly provision a new PostgreSQL instance for a microservice or application, ensuring consistent setup, idempotent operations, and immediate readiness for development and testing.

Quick Start

User: "Set up postgres database for my project"