Skill UI

Automates database backups by generating compression/encryption scripts, scheduling cron jobs, and documenting restore procedures for PostgreSQL, MySQL, MongoDB, and SQLite whenever backup automation or disaster recovery planning is requested.

Automates database backups by generating compression/encryption scripts, scheduling cron jobs, and documenting restore procedures for PostgreSQL, MySQL, MongoDB, and SQLite whenever backup automation or disaster recovery planning is requested.

This guide provides comprehensive techniques to optimize LangChain applications for production environments. Learn how to measure baseline latency, implement efficient caching strategies (in-memory, Redis, SQLite), utilize batch processing with concurrency control, and maximize perceived speed through streaming. Furthermore, it covers prompt optimization and strategic model selection to ensure high throughput and low costs.

Manages database schema migrations by generating timestamped up/down scripts for PostgreSQL, MySQL, SQLite, or MongoDB, letting you create, apply, or rollback changes safely when handling schema updates.

Mastery of modern mobile development across multiple platforms, including React Native, Flutter, and native iOS/Android. Expertise covers the entire lifecycle, specializing in architectural patterns (Clean, MVVM), performance optimization, offline-first data synchronization (GraphQL, SQLite), advanced DevOps practices (CI/CD, Fastlane), and App Store Optimization (ASO). Ideal for building robust, scalable, and highly performant cross-platform applications.

This skill provides comprehensive, structured audit logging for OpenRouter API interactions. It automatically captures essential metadata like total cost, token usage, model details, latency, and status, while also performing PII redaction. The resulting audit trail is stored in an append-only SQLite database, making it ideal for building compliance-ready systems, detailed cost monitoring, and deep debugging of production environments.

An expert assistant providing deep knowledge and best practices for Prisma ORM. It covers the entire lifecycle of database interaction, including optimal schema design, relation modeling, safe migration workflows, and advanced query optimization techniques (addressing N+1 issues and implementing raw queries) across PostgreSQL, MySQL, and SQLite.

Aggregates official auctioneer information from all 27 Brazilian Commercial Boards into a SQLite store, exposes a FastAPI REST interface, and enables CSV/JSON exports plus customizable scraping per state.

A comprehensive guide for conducting penetration testing on iOS and Android mobile applications, adhering to the OWASP MASTG. This skill covers the full mobile attack surface, including static analysis of binaries, dynamic runtime testing, and deep API security assessment. Techniques taught include bypassing certificate pinning, analyzing local data storage (Keychain, SQLite), and identifying vulnerabilities in authentication and network communication.

This skill provides a comprehensive guide for identifying and exploiting insecure local data storage vulnerabilities in Android and iOS applications. It covers analyzing plaintext credentials, unencrypted SQLite databases, insecure SharedPreferences, and improper keychain/keystore usage. Essential for performing robust mobile penetration testing focused on OWASP M9.

A comprehensive guide for digital forensics and incident response, detailing methods to extract and analyze critical web activity data. This includes history, cookies, cache, downloads, and bookmarks from major browsers like Chrome, Firefox, and Edge. Techniques involve utilizing SQLite querying and specialized tools on forensic images or live systems to establish a user's digital timeline.

LaZagne is an open-source post-exploitation tool utilized by red teams to harvest stored credentials from compromised endpoints. It supports Windows, Linux, and macOS, extracting passwords from browsers (Chrome, Edge), databases (MySQL, SQLite), system vaults (DPAPI, LSA), and various applications. It is crucial for privilege escalation and lateral movement during authorized security assessments.