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.

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

01Automated SQL schema generation with idempotent table definitions and optimized indexing.

02Comprehensive Python setup script for managing databases, users, and permissions.

03Native support for UUID primary keys and Unix timestamp patterns for high performance.

04Standardized environment variable templates for secure and flexible configuration.

05Reference implementation for a ThreadedConnectionPool-based database driver.

061 GitHub stars

Use Cases

01Bootstrapping a new backend project with a production-grade PostgreSQL foundation.

02Creating automated setup scripts for local development and CI/CD database provisioning.

03Migrating project database logic to follow standardized patterns for timestamps and identifiers.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jmazzahacks/byteforge-claude-skills postgres-setup

For use in Claude.ai and ChatGPT

Download Skill