Manages PostgreSQL administration, Alembic migrations, and schema design for the SmartEM ecosystem.
This skill provides a specialized toolkit for managing the SmartEM database layer, specifically focusing on PostgreSQL and Alembic. It enables developers to efficiently handle database migrations, troubleshoot connection issues, and perform deep performance analysis. By integrating domain-specific knowledge of the SmartEM scientific data hierarchy—including acquisitions, grids, and micrographs—this skill streamlines complex database workflows while ensuring schema integrity and safe data transitions in production environments.
主要功能
010 GitHub stars
02SmartEM-specific data context for scientific microscopy hierarchies
03Schema drift detection and validation against SQLModel definitions
04Real-time PostgreSQL performance analysis and query diagnostics
05Safe data migration templates with built-in production safeguards
06Automated Alembic migration generation and lifecycle management
使用场景
01Maintaining schema consistency between local development and CI/CD pipelines
02Evolving database schemas with version-controlled Alembic migrations
03Troubleshooting connectivity and performance bottlenecks in complex environments
