postgresql-table-design
A comprehensive guide for designing high-performance, maintainable PostgreSQL database schemas, covering best practices, data types, indexing, and advanced features.
Discover reusable agent skills, browse implementation details, and find the right skill for your workflow.
105 skills found
A comprehensive guide for designing high-performance, maintainable PostgreSQL database schemas, covering best practices, data types, indexing, and advanced features.
Test-driven development (TDD) workflow for Spring Boot applications using JUnit 5, Mockito, MockMvc, and Testcontainers.
Expert database design and access patterns: schema architecture, indexing strategies, query optimization, repository patterns, and transaction management for SQL and NoSQL databases.
Database schema validation, data integrity testing, migration validation, transaction isolation, and query performance testing. Ensure ACID compliance and referential integrity for data-driven applications.
A versatile data analysis assistant for loading datasets, performing statistical calculations, visualizing trends, and generating professional summary reports.
Transcribe audio files (wav, mp3, ogg) to text using the Qwen ASR model. Fast, local-friendly, and requires no API keys.
Process massive files and large codebases (10M+ tokens) by recursively chunking, sub-querying, and aggregating results to overcome LLM context limits.
Automates the lifecycle management of ephemeral Neon PostgreSQL databases for testing, CI/CD, and rapid prototyping workflows.
Find, review, and remove duplicate or near-duplicate images in FiftyOne datasets using computer vision similarity embeddings.
Specialized data engineering agent for designing ETL/ELT pipelines, defining data schemas, managing data quality, and implementing robust ingestion workflows.
Optimizes Prisma Client connection pool settings for production databases, serverless environments, and high-concurrency architectures to prevent connection exhaustion and performance bottlenecks.
World-class senior data engineering skill for building scalable data pipelines, ETL/ELT systems, and modern data infrastructure using Python, Spark, dbt, and Kafka.