Skill UI

Sets up production-ready Odoo with Docker, docker-compose, PostgreSQL, persistent volumes, env config, optional Nginx SSL proxy, plus diagnostics and best practices for launching on VPS or local dev.

Diagnose and fix Odoo performance bottlenecks by tuning PostgreSQL queries, adjusting worker/memory limits, and applying profiling insights to achieve faster page loads and stable production behavior.

This guide details how to implement HashiCorp Vault's dynamic secrets engine. It automates the generation, lease management, and rotation of short-lived credentials for databases (e.g., PostgreSQL, MySQL), AWS IAM, and PKI certificates. This method eliminates the use of static, hardcoded secrets, enforcing zero-trust principles and meeting stringent compliance mandates like PCI-DSS.

This skill details the deployment of Privileged Access Management (PAM) for critical database systems, including Oracle, SQL Server, PostgreSQL, and MySQL. It covers essential security controls such as session proxy configuration, credential vaulting, query auditing, and enforcing least-privilege access, helping organizations meet stringent compliance and security standards.

A powerful operational companion for database developers. This skill assists with the daily lifecycle of database interactions, including translating natural language requirements into optimized SQL queries, generating database migrations, performing comprehensive schema introspection across multiple dialects (PostgreSQL, MySQL, SQLite, SQL Server), and identifying performance bottlenecks through detailed query optimization and index recommendations. It also supports ORM patterns like Prisma and SQLAlchemy.

This guide provides comprehensive patterns for designing and implementing secure multi-tenant SaaS applications using shared databases. It covers critical techniques like Row-Level Security (RLS) in PostgreSQL, implementing tenant-aware middleware in TypeScript (Express/Fastify), and enforcing data scoping at the ORM level (Prisma/Drizzle). Learn how to prevent data leakage and manage tenant isolation across shared schemas.

This guide provides a comprehensive, step-by-step process to scaffold a modern Spring Boot application using Kotlin. It covers downloading the template, configuring dependencies (including SpringDoc and ArchUnit), and setting up complex polyglot environments using Docker Compose. Supports PostgreSQL, MongoDB, Redis, and WebFlux reactive programming.

This comprehensive guide details the workflow for creating robust, database-agnostic integration tests for data access layers migrating from Oracle to PostgreSQL. It outlines best practices for generating deterministic test cases using controlled seed data, ensuring that business logic and behavior remain consistent and validated across both source and target database systems.

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.

This skill analyzes an entire .NET solution (containing multiple projects) to map out a systematic migration path from Oracle to PostgreSQL. It scans for common Oracle indicators (NuGet packages, connection strings, code usage) and classifies every project into categories like MIGRATE, SKIP, or ALREADY_MIGRATED. The output is a structured, actionable Master Migration Plan, helping development teams manage large-scale database transitions efficiently.