스킬 db-connection

🗄️

db-connection

Name: db-connection
Author: Awais68

안전 ⚡ 스크립트 포함📁 파일 시스템 액세스

Set up database connections

This skill provides expert guidance for configuring database connections in Python and FastAPI applications. It covers Neon PostgreSQL setup, connection pooling, SSL configuration, and SQLAlchemy engine creation with best practices for production deployments.

지원: Claude Codex Code(CC)

🥉 72 브론즈

스킬 ZIP 다운로드

Claude에서 업로드

설정 → 기능 → 스킬 → 스킬 업로드로 이동

토글을 켜고 사용 시작

테스트해 보기

"db-connection" 사용 중입니다. Set up a database connection for my FastAPI app using Neon PostgreSQL

예상 결과:

Engine created successfully with pool_size=5
Connection string validated with SSL mode: require
Session factory configured for dependency injection
Health check endpoint available at /health/db

"db-connection" 사용 중입니다. Configure connection pool settings for my production application

예상 결과:

Pool size adjusted to 10 connections
Max overflow set to 20
Pool timeout configured at 30 seconds
Connection recycle set to 1800 seconds
Pool pre-ping enabled for connection health

"db-connection" 사용 중입니다. Add a database health check endpoint

예상 결과:

Created GET /health/db endpoint
Returns status: healthy or unhealthy
Includes latency measurement in milliseconds
Shows database connection pool statistics

보안 감사

안전

v5 • 1/16/2026

This skill is a documentation-based skill containing database connection examples. The only script (verify.py) only reads and validates the SKILL.md file. All static findings are false positives: regex flags were misidentified as cryptographic algorithms, markdown backticks as shell commands, and standard documentation URLs as hardcoded targets. No network calls, no command execution, no credential exfiltration detected.

스캔된 파일

825

분석된 줄 수

발견 사항

총 감사 수

위험 요인

⚡ 스크립트 포함 (1)

scripts/verify.py:1-62

📁 파일 시스템 액세스 (1)

scripts/verify.py:1-62

감사자: claude 감사 이력 보기 →

품질 점수

아키텍처

100

유지보수성

콘텐츠

커뮤니티

100

보안

사양 준수

만들 수 있는 것

Connect FastAPI to Neon

Configure SQLAlchemy engine and session management for FastAPI applications with Neon PostgreSQL

Tune connection pools

Optimize pool size, timeout, and recycle settings for serverless and production environments

Add health checks

Implement database health check endpoints for monitoring and deployment verification

이 프롬프트를 사용해 보세요

Basic connection setup

Set up a database connection for my FastAPI app using Neon PostgreSQL. I need SQLAlchemy engine configuration with connection pooling.

Configure pooling

Configure connection pool settings for my production FastAPI application. Current issues: slow responses under load, connection timeouts.

Add health checks

Add a database health check endpoint to my FastAPI app. It should return status, latency, and pool statistics.

Serverless optimization

Optimize database connection settings for Vercel serverless functions. I need to avoid connection limit errors.

모범 사례

Use pool_pre_ping to verify connections before use and avoid stale connections
Always close database sessions in finally blocks or use context managers
Configure appropriate timeouts and pool recycling to prevent connection leaks

피하기

Creating new database connections for each request instead of using connection pooling
Leaving connections open without proper cleanup, causing pool exhaustion
Hardcoding connection URLs instead of using environment variables with SecretStr

자주 묻는 질문

Which Python versions are supported?

This skill supports Python 3.8+ with SQLAlchemy 2.0 and Pydantic v2 for settings management.

What database platforms are supported?

Primary support for PostgreSQL (especially Neon). SQLAlchemy supports MySQL, SQLite, and other databases with similar patterns.

How do I integrate with existing FastAPI apps?

Use the get_db() dependency in your route handlers. Import from app.db.session and add db: Session = Depends(get_db) to routes.

Is my connection data secure?

Connection strings use Pydantic SecretStr to prevent logging of sensitive credentials. SSL is enforced for Neon connections.

Why am I getting connection timeout errors?

Check pool_size and max_overflow settings. For serverless, use smaller pools (2-3) with no overflow. Increase pool_timeout if needed.

How does this differ from @sqlmodel-crud?

This skill handles connection infrastructure. @sqlmodel-crud provides ORM model operations. Use both together for complete database integration.

개발자 세부 정보

작성자

Awais68

라이선스

MIT

리포지토리

https://github.com/Awais68/hackathon-2-phase-ii-full-stack-web-app/tree/main/.claude/skills/db-connection

참조

main

파일 구조

📁 scripts/

📄 verify.py

📄 SKILL.md