Skill UI

This skill performs deep forensic analysis on SQLite databases, going far beyond simple SQL queries. It is used in digital forensics and incident response to recover deleted records from freelist pages, analyze Write-Ahead Logs (WAL), and examine internal B-tree structures. It is essential for extracting critical evidence from mobile, browser, and application data sources.

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 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 reference architecture detailing how to automate Apple Notes on macOS. Since there is no public REST API, this system relies on a layered approach using Node.js, JXA scripting via osascript, local SQLite caching, and FSEvents polling. It outlines best practices for creating robust, local automation solutions for note management and data export.

This comprehensive workflow provides robust export and conversion capabilities for Apple Notes. It converts Apple Notes' internal HTML storage into multiple developer-friendly formats, including Markdown, JSON, HTML, and SQLite. Use it for reliable backups, migrating notes to other applications, or building searchable, portable note archives.

This skill analyzes and reports on the token usage, expenditure, and budget for AI models (like Claude Code) by querying a local SQLite database. It is essential for users who need detailed financial accountability, tracking costs by project, tool, or date, and managing operational budgets.

This skill analyzes and reports on the token usage, expenditure, and budget for AI models (like Claude Code) by querying a local SQLite database. It is essential for users who need detailed financial accountability, tracking costs by project, tool, or date, and managing operational budgets.