Skip to content
python logo

Python

python

Build, review, and refactor Python backend services. Use for tasks like FastAPI/Flask service setup, API design, request/response schemas, database access (PostgreSQL), migrations, background jobs, observability (logging/metrics/tracing), authentication, configuration, testing, and production har...

SKILL.md

Full skill instructions

python

Use this skill for Python 后端服务开发与评审。

Defaults (unless repo dictates otherwise)

  • Framework: FastAPI (preferred) or follow existing
  • Python: follow repo’s version; prefer modern typing
  • API: JSON over HTTP, explicit schemas
  • DB: PostgreSQL; prefer explicit migrations

Service structure (recommended)

  • app/
    • main.py (app factory, routers)
    • api/ (routers, request/​response models)
    • core/ (config, logging, security)
    • db/ (session/​engine, repositories)
    • models/ (ORM models if used)
    • schemas/ (Pydantic models)
    • services/ (business logic)
    • integrations/ (3rd party clients)
    • tests/

Workflow

  1. Clarify contract
  • Endpoints, auth requirements, error model, SLAs.
  • Data ownership and persistence requirements.
  1. API design
  • Version paths (/​v1/​...) and consistent naming.
  • Pydantic schemas: validate on input, shape output explicitly.
  • Error responses: stable code + message + optional details.
  1. Persistence
  • Define schema and migrations (Alembic if used).
  • Avoid leaking DB models into API; map to schemas.
  • Use indexes for query paths; ensure safe defaults and constraints.
  1. Security
  • Keep secrets in env vars; never in code.
  • AuthN/​AuthZ: token validation, scopes/​roles.
  • Input validation, rate limiting (if relevant), safe logging (no PII).
  1. Observability
  • Structured logs with request IDs.
  • Metrics for latency, error rate, DB timings; tracing if available.
  1. Testing
  • Unit tests for business logic.
  • API tests for endpoints (happy path + errors).
  • Deterministic fixtures; avoid flaky time/​network dependencies.

Output expectations when making changes

  • Prefer small, incremental diffs.
  • Update schemas/​migrations/​tests together.
  • Document new env vars and run steps.

More Security skills

supabase logo
Security

supabase

Handles the full Supabase workflow from schema changes to deployment, with built-in security guardrails that catch common traps like RLS...

2.7K 308.9K
View

Comprehensive guides and best practices for Neon Serverless Postgres, covering setup, connection methods, authentication, and platform APIs.

98 216.2K
View

Guide for setting up and using Firebase Authentication. Use this skill when the user's app requires user sign-in, user management, or secure data access using auth rules.

462 163.8K
View

A skill to evaluate how secure Firestore security rules are. Use this when Firestore security rules are updated to ensure that the generated rules are extremely secure and robust.

462 127.7K
View

Official skill for integrating Firebase AI Logic (Gemini API) into web applications. Covers setup, multimodal inference, structured output, and security.

462 125.1K
View

Complete Better Auth server and client setup with database adapters, session management, plugins, and security configuration.

222 118.2K
View

Deploy and manage projects on Vercel using token-based authentication. Use when working with Vercel CLI using access tokens rather than interactive login — e.g. "deploy to vercel", "set up vercel", "add environment variables to vercel".

31.9K 116.1K
View
cloudflare logo
Security

cloudflare

Complete Cloudflare platform integration with decision trees for compute, storage, AI, networking, security, and infrastructure-as-code.

3K 110.7K
View

Run Azure compliance and security audits with azqr plus Key Vault expiration checks. Covers best-practice assessment, resource review, policy/compliance validation, and security posture checks. WHEN: compliance scan, security audit, BEFORE running azqr (compliance cli tool), Azure best practices, Key Vault expiration check, expired certificates, expiring secrets, orphaned resources, compliance assessment.

253 103K
View
gws-gmail logo
Security

gws-gmail

Send, read, and manage Gmail messages, drafts, labels, and account settings.

31.2K 78.9K
View

Comprehensive website auditing across 230+ rules in 21 categories including SEO, performance, security, and accessibility.

94 72.3K
View
gws-shared logo
Security

gws-shared

Shared authentication, CLI syntax, and output formatting patterns for gws Google Workspace commands.

31.2K 63.4K
View

Security AI tools

StarByFace logo
Security

StarByFace

Discover your celebrity doppelgänger with StarByFace!

Free
View
GeoSpy logo
Security

GeoSpy

GeoSpy: Pricing, Features, FAQs, and Alternatives for AI Teams

Free
View

Detect AI-generated voices to protect against audio fraud.

Paid
View

Ensure Your Content's Originality with AI Plagiarism Checker

Freemium
View
Img Upscaler logo
Security

Img Upscaler

Upscale images by 400% without quality loss

Freemium
View
AICheatCheck logo
Security

AICheatCheck

Accurately Detect AI-Generated Content with TheChecker.AI

Free
View
D
Security

Detect GPT

Chrome extension that detects and flags AI-generated content

Free
View