Skill UI

A comprehensive toolset for the full backend development lifecycle. This suite enables developers to scaffold API routes from OpenAPI specifications, manage complex database migrations and optimization (PostgreSQL), and perform rigorous load/performance testing. It supports building robust microservices, securing REST APIs, and ensuring system scalability.

This skill specializes in optimizing complex SQL queries, designing efficient database schemas, and diagnosing performance bottlenecks across various SQL dialects (PostgreSQL, MySQL, SQL Server, etc.). Use it when dealing with slow queries, complex data aggregation, advanced joins, or when needing to implement best practices like CTEs, window functions, and covering indexes. It provides deep analysis of execution plans (EXPLAIN/ANALYZE) to ensure peak data retrieval performance.

Guides using SQLMap to automate SQL injection discovery, enumerate databases/tables/columns, dump data, and collect hashes across MySQL/PostgreSQL/MSSQL/Oracle during authorized penetration tests.

Guides analysts through automated SQL injection discovery and exploitation with SQLMap, covering enumeration, table/column mapping, data dumping, and advanced targeting across MySQL, PostgreSQL, MSSQL, Oracle, and other databases during authorized penetration tests.

Guides using SQLMap to automate SQL injection discovery, enumerate databases/tables/columns, dump data, and collect hashes across MySQL/PostgreSQL/MSSQL/Oracle during authorized penetration tests.

Bootstraps a new Rails 8 project wired to PostgreSQL, Inertia.js, React, Vite, Tailwind, Sidekiq, and Redis while enforcing UUID primary keys, timestamptz timestamps, JSONB metadata storage, minitest/mocha/VCR testing, and rubocop/brakeman guidance before verifying via bin/rails server.

Provides a complete guide to backing up and restoring Odoo, covering PostgreSQL dumps, filestore archiving, cron automation, and optional cloud uploads so production instances can recover quickly from failures.

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.

Deploy privileged access management for Oracle, SQL Server, PostgreSQL, and MySQL by configuring session proxies, credential vaulting, auditing, and dynamic authentication to enforce least privilege and compliance.

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.

Guides developers through designing SaaS multi-tenant stacks: tenant models, RLS policies, tenant-aware middleware, ORM/migration hygiene, and admin bypass flows in PostgreSQL and TypeScript.