Skill UI

This guide outlines architectural patterns and best practices for building scalable, production-ready APIs with FastAPI. It covers proper project structure, separating concerns using routers, services, and CRUD layers, implementing dependency injection for database sessions and authentication, defining Pydantic schemas for request/response, handling asynchronous operations, and managing custom error responses.

Flox is a declarative, Nix-based environment manager designed to create perfectly reproducible development environments. It handles system-level dependencies (like compilers, databases, and native libraries) and ensures that complex toolchains across multiple languages (Python, Node.js, Go, etc.) function identically across macOS and Linux. Ideal for solving 'works on my machine' issues and onboarding new team members instantly.

This guide details the Hexagonal Architecture (Ports and Adapters) pattern, a robust method for decoupling core business logic from external infrastructure concerns. It teaches how to structure applications to make the domain model independent of databases, UI frameworks, or message queues. Implementing this pattern drastically improves testability, maintainability, and the ability to swap out external services without rewriting business rules.

A comprehensive guide to building robust database layers in Kotlin using the Exposed ORM framework. It covers advanced patterns including DSL queries, DAO entity management, transaction handling, connection pooling with HikariCP, schema migration via Flyway, and implementing the Repository pattern for clean, production-grade data access.

A comprehensive guide to implementing Test-Driven Development (TDD) in Laravel. This resource covers best practices for Unit, Feature, and Integration testing, guiding developers on using PHPUnit and Pest. It details strategies for managing database states (e.g., RefreshDatabase) and effectively mocking external dependencies for robust application development.

This tool automates the creation of new, sequentially numbered database migration scripts. It generates paired 'up' and 'down' SQL files for managing schema changes, such as creating tables, adding/modifying columns, or creating indexes. It ensures idempotency and maintains a consistent migration history.

This tool validates all pending database migrations to ensure correctness, safety, and adherence to best practices. Use it before applying migrations to catch critical issues like broken foreign key references, incomplete rollback logic, unintended destructive operations (e.g., DROP TABLE), and naming convention violations. It checks for rollback completeness, schema integrity, and idempotency.

A comprehensive guide to PostgreSQL best practices, covering advanced indexing (GIN, BRIN, Partial), schema design, performance tuning, and security implementation (RLS). It details optimizing common SQL patterns like cursor pagination and UPSERT, essential for building high-performance, reliable database systems.

This guide provides a comprehensive workflow for searching and retrieving biomedical literature from PubMed and NCBI. It covers advanced query construction using MeSH terms and specific field tags, advanced filtering (date, publication type), and a repeatable programmatic workflow using NCBI E-utilities (esearch, efetch). Essential for researchers conducting systematic reviews and literature monitoring.

This utility diagnoses and automatically repairs common issues within the Ruflo installation environment. It performs comprehensive health checks on core dependencies like Node.js, npm, and git, while also validating configurations, daemon status, memory databases, and API keys. It provides targeted commands to resolve issues related to memory initialization, daemon startup, and configuration resets, ensuring a stable operational environment.

This comprehensive guide details the complete Test-Driven Development (TDD) workflow for Spring Boot applications. It covers best practices for writing unit tests (JUnit 5, Mockito), web layer tests (MockMvc), integration tests (SpringBootTest), and persistence tests (DataJpaTest). It also instructs how to use Testcontainers for realistic database simulations and achieve high code coverage with JaCoCo, ensuring robust and maintainable codebases.

This tool generates sophisticated trading signals by leveraging an advanced anomaly detection engine. It scans financial assets for various market anomalies—such as spikes, drifts, and oscillations—and classifies them. It then integrates neural network prediction and searches historical pattern databases to output highly ranked, actionable trading signals, complete with confidence scores and target parameters.