How does this skill handle database connections on App Engine?

It configures Django to use Unix sockets via the /cloudsql/ path, ensuring secure and high-performance communication between App Engine and Cloud SQL instances.

Does it support static file serving?

It implements WhiteNoise for efficient static file serving directly from the App Engine instance, simplifying the deployment by avoiding external storage for simple assets.

Is the database password secure in this setup?

Yes, the skill enforces security best practices by utilizing environment variables and Google Secret Manager rather than hardcoding credentials in the app.yaml file.

Can I use this for local development?

Yes, it includes detailed instructions for using the Cloud SQL Auth Proxy to securely connect your local Django environment to your cloud database without whitelisting IPs.

How do I prevent 'Too Many Connections' errors in Cloud SQL?

The skill configures CONN_MAX_AGE settings to enable database connection pooling, which optimizes resource usage and prevents exhausting Cloud SQL connection limits.

Django Cloud SQL PostgreSQL

Name: Django Cloud SQL PostgreSQL
Author: evolv3ai

byevolv3ai

0•

云基础设施

Deploys production-ready Django applications to Google App Engine with optimized Cloud SQL PostgreSQL configurations.

This skill provides a comprehensive blueprint for deploying Django applications on Google App Engine Standard environment using Cloud SQL PostgreSQL. It automates the complex configuration of Unix socket connections, implements secure local development using the Cloud SQL Auth Proxy, and enforces production best practices for Gunicorn, database connection pooling, and static file management via WhiteNoise. It is specifically designed to prevent common deployment errors like socket misconfigurations, connection timeouts, and CSRF verification issues on the appspot.com domain.

主要功能

01Automated Unix socket configuration for Google App Engine environments

02Database connection pooling optimization to prevent connection exhaustion

03Comprehensive troubleshooting for 12+ common Cloud SQL and Django errors

040 GitHub stars

05Secure local development setup using Cloud SQL Auth Proxy

06Production-ready Gunicorn and WhiteNoise static file configurations

使用场景

01Deploying a new Django project to Google Cloud Platform App Engine

02Fixing 'No such file or directory' or 'Connection Refused' errors in GCP environments

03Migrating an existing Django app from local servers to App Engine Standard

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add evolv3ai/claude-skills-archive django-cloud-sql-postgres

For use in Claude.ai and ChatGPT

Download Skill