Does it support creating test databases?

Yes, the generated Python setup script includes a --test-db flag to automatically provision a separate testing database with appropriate permissions.

What Python libraries are required for the setup script?

The generated setup and driver scripts primarily use psycopg2, the industry-standard PostgreSQL adapter for Python.

What database best practices does this skill enforce?

The skill enforces the use of UUIDs for primary keys, BIGINT Unix timestamps for dates, idempotent 'CREATE IF NOT EXISTS' statements, and proper foreign key indexing.

Can I customize the tables during setup?

Yes, the skill prompts you for specific table requirements during Step 1 and incorporates them into the resulting schema.sql file.

How are database credentials handled?

The skill uses a standardized environment variable pattern (e.g., PROJECT_PG_PASSWORD) to ensure credentials are never hardcoded in your source files.

PostgreSQL Database Setup

Name: PostgreSQL Database Setup
Author: jmazzahacks

byjmazzahacks

•

Database Management

Initializes PostgreSQL databases with standardized SQL schemas, Python setup scripts, and best-practice environment configurations.

About

The postgres-setup skill provides a production-ready framework for bootstrapping PostgreSQL databases in new or existing projects. It automates the creation of directory structures, idempotent SQL schemas, and robust Python setup scripts that handle user permissions and database creation for both development and testing environments. By codifying patterns like UUID primary keys, Unix timestamps (BIGINT), and connection pooling, it ensures your database layer is scalable, consistent, and follows industry best practices from day one.

Key Features

Automated SQL schema generation with idempotent table definitions and optimized indexing.
Comprehensive Python setup script for managing databases, users, and permissions.
Native support for UUID primary keys and Unix timestamp patterns for high performance.
Standardized environment variable templates for secure and flexible configuration.
Reference implementation for a ThreadedConnectionPool-based database driver.
1 GitHub stars

Use Cases

Bootstrapping a new backend project with a production-grade PostgreSQL foundation.
Creating automated setup scripts for local development and CI/CD database provisioning.
Migrating project database logic to follow standardized patterns for timestamps and identifiers.

About

Key Features

Automated SQL schema generation with idempotent table definitions and optimized indexing.
Comprehensive Python setup script for managing databases, users, and permissions.
Native support for UUID primary keys and Unix timestamp patterns for high performance.
Standardized environment variable templates for secure and flexible configuration.
Reference implementation for a ThreadedConnectionPool-based database driver.
1 GitHub stars

Use Cases

Bootstrapping a new backend project with a production-grade PostgreSQL foundation.
Creating automated setup scripts for local development and CI/CD database provisioning.
Migrating project database logic to follow standardized patterns for timestamps and identifiers.