Does this include static file configuration?

Yes, it includes WhiteNoise integration and app.yaml handler configuration to serve static files directly from the App Engine instance.

How do I manage database passwords securely?

The skill instructs you to use Google Secret Manager or runtime environment variables rather than hardcoding credentials in your repository.

How does this skill handle local vs production database connections?

It uses environment variable detection to switch between local connections via Cloud SQL Auth Proxy and production connections via Unix sockets at /cloudsql/.

What versions of Django and PostgreSQL are supported?

It is optimized for Django 5.1+ and PostgreSQL 15+, utilizing the psycopg2-binary adapter and modern Gunicorn configurations.

Django Cloud SQL PostgreSQL

Name: Django Cloud SQL PostgreSQL
Author: jezweb

byjezweb

•

245

•

Cloud Infrastructure

Deploys and configures Django applications on Google App Engine Standard with secure Cloud SQL PostgreSQL integration.

This skill provides a production-ready blueprint for running Django in the Google Cloud ecosystem, focusing on the specific networking requirements of App Engine and Cloud SQL. It automates the configuration of Unix socket connections for production, sets up the Cloud SQL Auth Proxy for secure local development, and optimizes Gunicorn settings for high-performance hosting. By incorporating database pooling and security best practices, it helps developers resolve common deployment errors like 'No such file or directory' and authentication failures.

Key Features

01Advanced database connection pooling with CONN_MAX_AGE

02Secure Unix socket connection setup for PostgreSQL

03Automated App Engine Standard deployment configuration

04245 GitHub stars

05Local development integration via Cloud SQL Auth Proxy

06Optimized Gunicorn and WhiteNoise production settings

Use Cases

01Setting up a secure local development environment that mirrors production database behavior

02Migrating a local Django project to Google App Engine Standard

03Troubleshooting PostgreSQL connection issues in Google Cloud environments

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jezweb/claude-skills django-cloud-sql-postgres

For use in Claude.ai and ChatGPT

Download Skill