Skill UI

An end-to-end workflow for building robust, production-ready Python backend APIs. This guide covers all stages, including project scaffolding, SQLAlchemy database integration, Pydantic validation, implementing JWT/OAuth2 authentication, comprehensive error handling, unit testing, and Docker deployment for modern microservices.

Specializes in building modern, high-performance Rails 7+ web applications. Expertise includes optimizing Active Record queries (N+1 prevention), implementing partial page updates with Hotwire (Turbo Frames/Streams), handling real-time communication via Action Cable, and managing background jobs using Sidekiq. The process includes rigorous RSpec testing and database schema management.

This comprehensive guide provides detailed steps for load testing and capacity planning of Replit deployments. Learn how to benchmark performance using industry tools like k6 and autocannon, optimize Autoscale behavior, right-size Reserved VMs, and manage database connection pools. It covers optimizing cold start times and ensuring high availability under variable and peak traffic loads.

Provides a comprehensive guide and framework for executing end-to-end (E2E) tests. It simulates real user interactions across the entire application stack, covering browser UI, API calls, and database operations. The guide details best practices like implementing the Page Object Model (POM), configuring multi-browser environments (Playwright, Cypress, Selenium), and establishing robust error handling mechanisms to ensure high application stability and quality.

Automates environment prep, service orchestration, and cleanup for executing integration test suites, covering database setup, migrations, and optional coverage reports.

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.

Execute systematic SQL injection vulnerability assessments on web applications using reconnaissance, payload tuning, and exploitation workflows to uncover database flaws, capture evidence, and validate remediation recommendations for authorized security testing.

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.

This skill provisions instant, temporary PostgreSQL databases via Neon. It eliminates the need for user sign-up, logins, or credit cards, making it ideal for rapid local development, API prototyping, and isolated testing environments. Supports multiple methods including REST API calls, CLI commands, and SDK integration.

This skill generates a complete, opinionated, modern full-stack Rails application boilerplate. It sets up a robust tech stack including Rails 8, PostgreSQL, React, Inertia.js, Vite, Tailwind CSS, Sidekiq, and Redis. Designed for developers who need a starting point that adheres to best practices for database structure (UUIDs, JSONB), background job processing, comprehensive testing, and modern frontend development (TSX). Ideal for bootstrapping complex, production-grade web services.