AsyncPG Database Detection

About

Simplifies the migration process from raw asyncpg to SQLAlchemy in FastAPI applications by providing automated scanning and detailed reporting. It intelligently identifies imports, connection pools, and various query execution methods—such as fetch and execute—while assessing the complexity of transactions and error handling. This skill provides developers with a clear roadmap for refactoring, ensuring that no legacy database patterns are missed during project modernization by generating actionable reports with specific line numbers and conversion recommendations.

Key Features

• Detection of specific query execution methods including fetch, execute, and iter
• 0 GitHub stars
• Mapping of found patterns to recommended SQLAlchemy equivalents
• Identification of complex transaction and error handling scenarios
• Generation of detailed reports with line numbers and complexity assessments
• Comprehensive scanning for asyncpg imports and connection patterns

Use Cases

• Auditing database access patterns across large Python codebases
• Modernizing legacy FastAPI projects from raw SQL to ORM-based architectures
• Preparing a project for migration to SQLAlchemy with asyncpg engine support