Why does this skill use BIGINT for timestamps instead of TIMESTAMP?

Storing Unix timestamps as BIGINT is a best practice that avoids time zone conversion complexities across different server environments and simplifies date logic in application code.

Does this skill provide connection pooling?

Yes, the optional database driver component includes a implementation of ThreadedConnectionPool from psycopg2 to handle concurrent connections efficiently.

Can I use this skill with an existing PostgreSQL database?

Yes. The generated scripts use 'CREATE TABLE IF NOT EXISTS' and 'IF NOT EXISTS' for extensions and indexes, making them safe to run against existing databases to ensure schema compliance.

How does it handle database security?

The skill promotes security best practices by using environment variables for all credentials and creating a dedicated application user with specific privileges rather than using the superuser.

PostgreSQL Database Setup

Name: PostgreSQL Database Setup
Author: jmazzahacks

byjmazzahacks

•

Database Management

Standardizes PostgreSQL database initialization with automated schema generation, setup scripts, and high-performance connection drivers.

This skill automates the creation of a professional-grade PostgreSQL environment for new projects, establishing a clean separation between SQL schema definitions and Python-based setup logic. It enforces industry best practices such as UUID primary keys, BIGINT Unix timestamps for consistency, and robust connection pooling to ensure your database layer is production-ready from day one. By standardizing environment variable patterns and providing a context-managed database driver, it streamlines development workflows for production, development, and testing environments.

Key Features

01Automated generation of idempotent schema.sql and setup_database.py scripts

021 GitHub stars

03Standardizes environment variable configuration for secure credential management

04Provides a production-ready database driver with ThreadedConnectionPool

05Enforces UUID primary keys and BIGINT Unix timestamp best practices

06Supports multi-environment setups including dedicated test databases

Use Cases

01Initializing the database layer and connection manager for a new backend service

02Setting up isolated PostgreSQL environments for automated CI/CD testing

03Standardizing database access patterns across multiple microservices

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