migrate-postgres-tables-to-hypertables
Migrate standard PostgreSQL tables to TimescaleDB hypertables with optimized partitioning, chunking, and compression strategies for time-series data.
Discover reusable agent skills, browse implementation details, and find the right skill for your workflow.
121 skills found
Migrate standard PostgreSQL tables to TimescaleDB hypertables with optimized partitioning, chunking, and compression strategies for time-series data.
Build read models and projections from event streams for CQRS, materialized views, and optimized query performance in event-sourced systems.
Systematic performance engineering: baseline measurement, profiling, bottleneck diagnosis, and evidence-based optimization guidance for high-performance applications.
Vitest testing patterns for reliable unit and integration tests. Focuses on critical business logic, edge cases, and mocking strategies for high-impact functions.
Run, debug, and manage DBHub tests including unit, integration with Testcontainers, and database-specific suites. Perfect for verifying code changes and troubleshooting database connector issues.
Test-driven development (TDD) workflow for Spring Boot applications using JUnit 5, Mockito, MockMvc, and Testcontainers.
Database schema validation, data integrity testing, migration validation, transaction isolation, and query performance testing. Ensure ACID compliance and referential integrity for data-driven applications.
Optimizes Prisma Client connection pool settings for production databases, serverless environments, and high-concurrency architectures to prevent connection exhaustion and performance bottlenecks.
Expert SQL agent for modern database systems, query optimization, HTAP environments, and data architecture patterns. Optimize performance, schema design, and analytical workloads effectively.
AI-powered Kubernetes and OpenShift troubleshooting. Proactively assess cluster health, debug pod failures, analyze logs, and validate security using Popeye-inspired patterns.
Specialized IDF (Information Display Frame) sub-agent for generating and reviewing CQRS Query Side implementations across Java, TypeScript, and Go.
Automated Vitest management skill: handles test execution, coverage reporting, failure diagnosis, and configuration management for TypeScript/JavaScript projects.