Skill UI

PostgreSQL database optimization workflow for query tuning, indexing strategies, performance analysis, and production database management.

Provides Prisma ORM expertise for schema design, migrations, relations modeling, and query optimization plus database operations across PostgreSQL, MySQL, and SQLite in Node.js projects.

Performs OWASP-guided security scans on PostgreSQL and MySQL databases via the database-security-scanner plugin, identifying weak passwords, SQL injection risks, and misconfigurations while generating reports and remediation advice.

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.