All Skills

Create, search, and manage Bear notes on macOS using the grizzly CLI, including token-based operations for appending text and listing tags.

Provides guidance and best practices for working with Cloudflare, covering setup, configuration, deployment, and troubleshooting.

Designs 3D models, selects printing technologies, optimizes prints, and troubleshoots issues for additive manufacturing.

Tracks blog and RSS/Atom feed updates using the blogwatcher CLI, with commands to add, list, scan, and manage articles.

Writes, rewrites, or improves marketing copy for web pages, including headlines, CTAs, and page sections, with a focus on clarity, benefits, and conversion.

Applies SOLID principles, clean architecture layers, dependency injection, and patterns like CQRS and event sourcing to design scalable, maintainable systems.

Provides guidance and best practices for working with cert-manager, covering setup, configuration, deployment, and troubleshooting.

Explains cryptographic primitives and provides Python implementations for encryption, hashing, key exchange, and digital signatures.

Explains MariaDB-specific SET syntax and behavior, including scope rules, the SET STATEMENT ... FOR extension, and persistence differences from MySQL.

Decodes and replays MariaDB binary logs with correct flags: commented pseudo-SQL vs. executable BINLOG blobs, ANNOTATE_ROWS events, flashback undo SQL, and safe replay via the mariadb client.

Explains MariaDB-specific REVOKE syntax and behavior, including the five grammar forms, privilege requirements, error semantics, and role/proxy revocation nuances.

Explains MariaDB server-side prepared statements (PREPARE, EXECUTE, DEALLOCATE, EXECUTE IMMEDIATE), including syntax, allowed statements, placeholders, session scope, and restrictions. Use when writing or reviewing dynamic SQL for MariaDB.

Explains MariaDB-specific syntax and behavior for LOAD DATA [LOCAL] INFILE and LOAD XML, including LOCAL vs server-side file handling, security and privilege requirements, default tab/newline parsing, duplicate and strict-mode caveats, IGNORE n LINES, user-variable SET transforms, CHARACTER SET clause, and priority.

Explains MariaDB-specific view syntax and behavior, including CREATE OR REPLACE VIEW, ALGORITHM options, SQL SECURITY, updatability rules, and WITH CHECK OPTION, for writing or reviewing MariaDB view statements.

Documents MariaDB-specific transaction control syntax and behavior, including START TRANSACTION, COMMIT, ROLLBACK, SAVEPOINT, implicit commit rules, autocommit defaults, and idle transaction timeouts.

Explains MariaDB's three CREATE FUNCTION forms — stored functions, stored aggregate functions, and loadable UDFs — covering syntax, privileges, and behavior differences for writing or reviewing MariaDB SQL.

Reference for MariaDB's vector functions and VECTOR data type, covering VEC_Distance, VEC_Distance_Euclidean, VEC_Distance_Cosine, VEC_FromText, VEC_ToText, and MHNSW vector index usage for SQL queries over embeddings.

Remove MariaDB REST service objects with DROP REST statements, including services, schemas, data mapping views, procedures, functions, content sets/files, auth apps, users, and roles, using IF EXISTS to avoid errors.

Installs and configures MariaDB Connector/C, covering package names per distribution, compile and link flags, option file handling, and TLS options.

Explains MariaDB Connector/ODBC-specific behavior for application code, including DSN-less connection strings, positional parameter markers, prepared statement execution modes, autocommit defaults, TLS auto-enablement, and error handling. Use when writing or reviewing ODBC-based code (C/C++ or pyodbc) that talks to.

Reference for MariaDB information functions, covering session and server metadata such as LAST_INSERT_ID, ROW_COUNT, FOUND_ROWS, USER, and VERSION, with usage guidance for writing SQL that reads auto-increment IDs, row counts, and connection details.

Reference for MariaDB control-flow functions and operators, including IF(), IFNULL(), NULLIF(), COALESCE(), CASE, NVL2(), and DECODE_ORACLE, with guidance on correct usage and common pitfalls.

Scaffold a MariaDB Schema Management (MSM) project and author the initial schema in the development folder, creating the project with msm.create_project and writing the first version's tables, objects, and grants into the MSM sections of <schema>_next.sql.

Modify existing MariaDB REST Service endpoints using ALTER and DROP REST statements, including renaming request paths, enabling/disabling, publishing, and merging JSON options.

Identifies and removes dead code safely, with test verification at each step and categorization of risk levels.

Analyzes codebase structure and generates token-lean architecture documentation in codemap files, with diff detection and metadata tracking.

Evaluates execution outcomes against defined success criteria, scoring each criterion and producing a structured verdict with actionable feedback.

Guides the red-green-refactor cycle for implementing features with test-driven development, including test quality guidelines, framework setup, and commit patterns.

Builds a configurable scraping agent that collects data from APIs, HTML, or RSS, enriches it with Gemini AI scoring, and stores results in Notion, Google Sheets, Supabase, or local files.

Adopt Swift 6.2's Approachable Concurrency model, which runs code single-threaded by default and uses explicit @concurrent for background offloading, isolated conformances, and MainActor default inference to eliminate data-race errors.

Designs banners across social, ad, web, and print formats, generating multiple art direction options with AI-generated visuals and HTML/CSS composition.

Incrementally fixes Gradle build and compilation errors for Android and Kotlin Multiplatform projects.

Provides domain-specific best practices for creating videos with Remotion in React, covering 3D, animations, audio, captions, charts, transitions, and more.

Enforces language-specific coding rules, style guidelines, patterns, security, and testing standards by referencing a built-in guidelines bank.

Provides SwiftUI architecture guidance covering state management with @Observable, view composition, type-safe navigation, performance optimization, and modern iOS/macOS UI best practices.

Audits and improves search visibility through technical SEO, on-page optimization, structured data, Core Web Vitals, and content strategy.