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.

About

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

Automated generation of idempotent schema.sql and setup_database.py scripts
1 GitHub stars
Standardizes environment variable configuration for secure credential management
Provides a production-ready database driver with ThreadedConnectionPool
Enforces UUID primary keys and BIGINT Unix timestamp best practices
Supports multi-environment setups including dedicated test databases

Use Cases

Initializing the database layer and connection manager for a new backend service
Setting up isolated PostgreSQL environments for automated CI/CD testing
Standardizing database access patterns across multiple microservices

About

Key Features

Automated generation of idempotent schema.sql and setup_database.py scripts
1 GitHub stars
Standardizes environment variable configuration for secure credential management
Provides a production-ready database driver with ThreadedConnectionPool
Enforces UUID primary keys and BIGINT Unix timestamp best practices
Supports multi-environment setups including dedicated test databases

Use Cases

Initializing the database layer and connection manager for a new backend service
Setting up isolated PostgreSQL environments for automated CI/CD testing
Standardizing database access patterns across multiple microservices