asyncpg-detection
当用户要求"检测asyncpg使用"、"查找asyncpg模式"、"扫描asyncpg导入"或"识别FastAPI项目中的asyncpg数据库代码"时,应使用此技能。它会自动扫描Python文件,识别需要转换为SQLAlchemy的asyncpg导入、连接模式和查询执行方法。
📖 中文导读:当用户要求"检测asyncpg使用"、"查找asyncpg模式"、"扫描asyncpg导入"或"识别FastAPI项目中的asyncpg数据库代码"时,应使用此技能。它会自动扫描Python文件,识别需要转换为SQLAlchemy的asyncpg导入、连接模式和查询执行方法。 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。
name: asyncpg-detection description: This skill should be used when the user asks to "detect asyncpg usage", "find asyncpg patterns", "scan for asyncpg imports", or "identify asyncpg database code in FastAPI projects". It automatically scans Python files to identify asyncpg imports, connection patterns, and query execution methods that need conversion to SQLAlchemy. version: 1.0.0
AsyncPG Detection for FastAPI Projects
This skill provides comprehensive detection of asyncpg usage patterns in FastAPI applications, identifying all code that needs to be converted to SQLAlchemy with asyncpg engine support.
Detection Overview
Scan FastAPI projects for asyncpg patterns including imports, connection management, queries, transactions, and error handling. Generate detailed reports with line numbers and conversion recommendations.
Core Detection Patterns
Import Detection
Look for these import statements:
import asyncpgfrom asyncpg importimport asyncpg as pgfrom asyncpg import Connection, Pool
Connection Patterns
Identify these asyncpg connection approaches:
asyncpg.connect()callsasyncpg.create_pool()usage- Manual connection string parsing
- Environment-based connection configuration
Query Patterns
Detect these asyncpg execution methods:
connection.fetch()for SELECT queriesconnection.execute()for INSERT/UPDATE/DELETEconnection.fetchval()for single valuesconnection.fetchrow()for single rowsconnection.iter()for result iteration
Usage Instructions
To detect asyncpg usage in your FastAPI project:
- Run comprehensive scan: Use the
/convert-asyncpg-to-sqlalchemycommand to scan all Python files in the project - Analyze detection results: Review the generated report for files containing asyncpg code
- Prioritize conversion: Focus on files with the most asyncpg usage first
- Check for complex patterns: Look for nested connections, transactions, and error handling that may require special attention
Reporting Format
The detection generates reports with:
- File list: All files containing asyncpg imports
- Pattern analysis: Specific asyncpg methods found
- Complexity assessment: Files requiring manual intervention
- Conversion recommendations: Suggested SQLAlchemy equivalents
Additional Resources
Reference Files
references/patterns-mapping.md- Complete asyncpg to SQLAlchemy pattern mappingreferences/complex-cases.md- Handling of complex asyncpg scenariosreferences/supabase-specific.md- Supabase-specific asyncpg patterns
Examples
examples/detection-report.md- Sample detection outputexamples/fastapi-project-structure.md- Example FastAPI project with asyncpg usage