Skill UI

This comprehensive guide covers best practices for building robust database systems. It teaches crucial concepts like schema normalization, effective indexing strategies, selecting the right database (e.g., SQLite vs PostgreSQL) and ORM, and optimizing queries to prevent common performance issues like N+1 problems. It emphasizes making context-aware architectural decisions.

A comprehensive guide and workflow for identifying behavioral risks when migrating applications from Oracle to PostgreSQL. It cross-references code against known differences in complex areas such as empty strings, refcursors, type coercion, sorting, and concurrent transaction handling. Essential for both pre-migration architectural planning and post-migration validation testing.

This comprehensive guide provides a complete, step-by-step workflow for setting up a modern Spring Boot Java project from scratch. It covers downloading the project template, configuring multiple data sources (PostgreSQL, Redis, MongoDB), integrating API documentation (SpringDoc), and orchestrating a full, containerized service environment using Docker Compose. Ideal for complex, enterprise-level application development.

Creates structured bug reports for defects found during Oracle-to-PostgreSQL database migration, covering severity, root cause, reproduction steps, and remediation. Useful for documenting behavioral differences and validating fixes.

This skill migrates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL. It translates Oracle-specific syntax while preserving method signatures and type-anchored parameters. It leverages orafce where appropriate and applies explicit collation mapping. Use this when converting Oracle stored procedures or functions to PostgreSQL equivalents during database migration.

Generates a structured, actionable integration testing plan for data access artifacts migrating from Oracle to PostgreSQL. The tool analyzes a single target project to identify repositories, DAOs, and service layers, prioritizing tests based on Oracle-specific features and known behavioral differences (e.g., date/time handling, type coercion). It ensures comprehensive test coverage for crucial database interactions.

Analyzes PostgreSQL snippets or entire projects to flag anti-patterns, enforce best practices, optimize JSONB/array usage, schema design, custom types, triggers, extensions, and security policies like RLS.

Assistant for PostgreSQL developers that highlights native features, advanced data types, performance tuning patterns, and extension usage to optimize queries, indexes, and analytics in PostgreSQL projects.

Scaffolds an empty xUnit integration test project targeting Oracle in .NET solutions, including a transaction-rollback base class and seed data manager. Use in Phase 3 before writing Oracle baseline tests for Oracle-to-PostgreSQL migration.

A universal assistant for conducting deep code reviews across major SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). It rigorously analyzes SQL code for critical vulnerabilities (like SQL injection), performance bottlenecks, maintainability issues, and adherence to industry best practices. Features include security audits, index optimization recommendations, query structure analysis, and schema design validation, ensuring robust and secure database development.

Cross-database SQL performance optimization assistant offering query tuning, indexing strategies, pagination, batch operations, and monitoring guidance for MySQL, PostgreSQL, SQL Server, Oracle, and other relational systems.

This reference architecture provides a blueprint for integrating Fathom meeting intelligence data into enterprise systems. It details the full data pipeline, spanning from initial Fathom recordings via webhooks to structured storage (PostgreSQL), action item extraction, and downstream synchronization with CRMs (like Salesforce/HubSpot) and email systems. Ideal for developers building automated, real-time business process workflows.