Byteforge Claude Skills
A collection of Claude Code skills by @jmazzahacks that codify best practices and reusable patterns for software development.
Available Skills
postgres-setup
A skill that provides a standardized pattern for setting up PostgreSQL databases with proper separation of schema and setup logic.
What it creates:
database/schema.sql - SQL schema definitionsdev_scripts/setup_database.py - Python setup script with load_dotenv support- Project-specific environment variable naming
- Idempotent operations (safe to run multiple times)
Features:
- ✅ Parameterized project naming (not hardcoded)
- ✅ Unix timestamp convention for dates (BIGINT, not TIMESTAMP)
- ✅ UUID primary keys with
gen_random_uuid()
- ✅ Proper permissions and user creation
- ✅ Connection pooling pattern with ThreadedConnectionPool
- ✅ Stale-connection-safe driver with retry on disconnect
- ✅ RealDictCursor for easy dict conversion
Design Principles:
- Unix Timestamps Only - Use
BIGINT for all date/time storage
- UUID Primary Keys - Better for distributed systems
- Idempotent Operations -
CREATE TABLE IF NOT EXISTS, safe to re-run
- Separation of Concerns - Schema in SQL, setup logic in Python
- No Hardcoded Credentials - Everything via environment variables
View full postgres-setup documentation →
python-lib-setup
A skill that provides a modern, standardized pattern for setting up Python libraries for PyPI publishing or private GitHub distribution.
What it creates:
pyproject.toml - Modern Python project configuration with hatchlingsrc/{package_name}/ - Source layout with explicit package discovery.gitignore - Comprehensive Python artifact exclusionsdev-requirements.txt - Development dependencies (includes build/twine for PyPI only)build-publish.sh - Automated build and publish script (PyPI only)README.md - Basic project documentation
Features:
- ✅ Modern pyproject.toml-based configuration (PEP 517/518)
- ✅ Src layout pattern for better code organization
- ✅ Explicit package discovery with hatchling
- ✅ Comprehensive .gitignore for Python projects
- ✅ PyPI or GitHub distribution paths
- ✅ Automated build-publish script with venv activation (PyPI path)
- ✅ git+https:// install instructions with CR_PAT patterns (GitHub path)
- ✅ Parameterized project setup (interactive questions)
- ✅ License selection (Proprietary, MIT, O'Saasy)
- ✅ Proper PyPI classifiers and metadata
Design Principles:
- Modern Standards - Follows PEP 517/518, no setup.py needed
- Src Layout - Clean separation of source code in src/ directory
- Explicit Configuration - Explicit package discovery, no magic
- Virtual Environment Convention - Uses bin/ at project root
- Comprehensive .gitignore - Covers all common Python artifacts
- Interactive Setup - Asks user questions before generating files
- Flexible Distribution - Supports PyPI publishing and private GitHub libraries
View full python-lib-setup documentation →
flask-smorest-api
A skill that provides a production-ready pattern for building Flask REST APIs with automatic OpenAPI/Swagger documentation.
What it creates:
- Main application file with Flask app factory pattern and dotenv support
- Blueprint architecture for modular endpoint organization
- Marshmallow schema files for validation and documentation
- Singleton manager for shared service instances
example.env with all required environment variables- CORS support and error handling
requirements.txt with all dependencies (unpinned)
Features:
- ✅ Automatic OpenAPI/Swagger documentation via flask-smorest
- ✅ Blueprint architecture for modularity
- ✅ MethodView classes for clean HTTP method handling
- ✅ Type-safe request/response with Marshmallow schemas
- ✅ Singleton manager pattern for database/service initialization
- ✅ CORS support for frontend integration
- ✅ Application factory pattern for testing
- ✅ Gunicorn production server support
- ✅ python-dotenv for environment variable management
- ✅ example.env pattern for configuration
Design Principles:
- Blueprint Organization - One blueprint per feature/resource
- Schema-Driven - Marshmallow schemas for validation and docs
- Singleton Manager - Centralized service initialization
- Application Factory -
create_app() pattern for flexibility
- OpenAPI/Swagger - Automatic documentation generation
- Environment-Based Config - All secrets via environment variables with example.env
- Production Ready - Gunicorn support out of the box
View full flask-smorest-api documentation →
flask-docker-deployment
A skill that provides a production-ready Docker deployment pattern for Flask applications with automated versioning and container registry publishing.
