Latest Agent Skills

Documents MariaDB-specific CREATE USER syntax and behavior, including authentication chaining, TLS options, resource limits, password expiry, and account locking, to help write accurate statements.

Documents MariaDB-specific ALTER TABLE syntax and behavior, including online DDL algorithms, lock modes, lock timeouts, idempotent subclauses, system versioning, and partition operations, for writing and reviewing schema migrations.

Documents MariaDB-specific DROP TABLE syntax and behavior, including RESTRICT/CASCADE no-ops, DROP TEMPORARY TABLE, partial drops, IF EXISTS warnings, foreign key references, views, triggers, implicit commit, and WAIT/NOWAIT. Use when writing, generating, or reviewing DROP TABLE statements targeting MariaDB.

Covers MariaDB-specific ALTER USER and SET PASSWORD syntax, including IF EXISTS semantics, authentication methods, password expiration, account locking, and resource limits.

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 behavior of DROP USER and RENAME USER, including multiple accounts per statement, IF EXISTS handling, active-connection warnings, and effects on privileges and definers. Use when writing or reviewing account-lifecycle SQL for MariaDB.

Guides developers migrating applications from MySQL to MariaDB, covering authentication, JSON handling, replication, and SQL syntax differences.

Explains MariaDB-specific features and behaviors that differ from MySQL, including system-versioned tables, RETURNING, sequences, and version-specific defaults, to help optimize and migrate MariaDB applications.

Explains MariaDB's REPLACE statement: its delete-then-insert behavior, when it triggers, data-loss risks, and the upsert alternative. Use when writing or reviewing REPLACE statements.

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 EXPLAIN and ANALYZE syntax, including FORMAT=JSON, SHOW EXPLAIN/ANALYZE FOR, and the standalone ANALYZE statement that executes queries.

Provides best practices for using MariaDB's built-in vector support for AI workloads, including SQL syntax for vector columns, indexes, distance functions, and RAG patterns.

Documents MariaDB-specific UPDATE syntax and behavior, including single-table vs multi-table forms, assignment evaluation order, RETURNING with OLD_VALUE(), temporal tables, and common pitfalls. Use when writing, generating, or reviewing UPDATE statements targeting MariaDB.

Covers MariaDB-specific SELECT syntax and behavior, including optimizer hints, LIMIT extensions, row locking, temporal queries, and file output.

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

Documents MariaDB-specific INSERT syntax and behavior, including RETURNING, ON DUPLICATE KEY UPDATE, INSERT IGNORE, and various forms and modifiers, to help write and review INSERT statements.

Bulk-load text files into MariaDB tables using the mariadb-import client, covering table-name-from-filename rules, TAB defaults, --local vs server-side reads, duplicate handling, and parallel loads.

Covers MariaDB-specific DELETE syntax and behavior, including RETURNING, multi-table forms, temporal-table deletion, and DELETE vs TRUNCATE differences.

Covers MariaDB-specific behavior of the mariadb command-line client, including batch mode output, delimiter handling, safe-updates, charset detection, and TLS defaults, for writing or reviewing shell commands and scripts.

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.

Documents MariaDB-specific GRANT behavior, including privilege scope levels, implicit account creation, MariaDB-only privileges, roles, proxy grants, resource limits, and TLS options, to help write accurate GRANT statements.

Explains MariaDB-specific SHOW statement syntax, including replication terminology, filtering rules, and diagnostic commands like SHOW EXPLAIN and SHOW ANALYZE.

Explains MariaDB-specific defaults and traps of the mariadb-dump client for dev workflows, including consistent backups, routines/events flags, diffable dumps, idempotent seeding, and restore via the mariadb client.

Documents MariaDB-specific CALL syntax and behavior, including optional parentheses, OUT/INOUT parameter binding, result sets, privileges, prepared statements, and recursion limits.

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

Identifies common software anti-patterns in code and suggests refactoring solutions to improve code quality.

Build and deploy machine learning models with TensorFlow, covering Keras, data pipelines, and production serving.

Explains dense vector embeddings, their key concepts, common use cases, and best practices for semantic search and RAG applications.

Implement WCAG-compliant web interfaces with semantic HTML, keyboard navigation, ARIA attributes, color contrast, and screen reader support, plus automated testing with axe-core.

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

Guides users through creating effective Agent Skills for Cursor, covering skill structure, best practices, and SKILL.md format.

Runs Codex CLI, Claude Code, OpenCode, or Pi Coding Agent via background process for programmatic control.

Measures code quality, identifies code smells, and implements quality gates using static analysis and technical debt tracking.

Designs cloud-native architectures using containers, microservices, Kubernetes, serverless, and event-driven patterns, with guidance on observability and GitOps.

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

Explains cell structure, organelles, signaling pathways, and cell cycle regulation for biology study and research.

Provides design patterns and architectural approaches for implementing and integrating browser APIs in software projects.

Analyzes biochemical processes, including enzyme kinetics, metabolic pathways, and biomolecule characterization, with practical techniques and examples.

Analyzes stellar structure, galactic dynamics, orbital mechanics, gravitational lensing, cosmic microwave background, and exoplanet detection methods.

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

Provides expert-level guidance on implementing and applying app security concepts, including design, optimization, debugging, and best practices.

Build LLM-powered applications with modular components for chains, agents, memory, and retrieval, supporting Python and JavaScript frameworks.

Provides guidance on using Anthropic's Claude API, covering message formats, context windows, tool use, and best practices for building conversational AI applications.

Creates Cursor rules in .cursor/rules/ with YAML frontmatter for persistent AI guidance, including scope and file pattern configuration.

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

Provides code review best practices, checklists, and example feedback for quality, security, performance, and maintainability.

Automates multi-language software builds with Makefiles, dependency management, testing, packaging, and CI/CD integration.

Automates browser interactions for web testing, form filling, screenshots, and data extraction. Use when the user needs to navigate websites, interact with web pages, fill forms, take screenshots, or extract information from web pages.

Sends and manages iMessages through the BlueBubbles integration, including texts, attachments, reactions, edits, unsends, and thread replies.

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

Designs application architecture, selects patterns, structures code modules, and manages dependencies for new projects.

Manage Apple Notes from the terminal using the `memo` CLI: create, view, edit, delete, search, move, and export notes on macOS.

Designs API gateway architecture and implements routing, authentication, rate limiting, transformation, caching, logging, and circuit breaking.

Runs 150+ AI apps in the cloud via the inference.sh CLI, covering image generation, video creation, LLMs, web search, 3D generation, and Twitter automation.

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

Provides expertise in containerization technology, covering container creation, orchestration integration, security hardening, and operational best practices for production workloads.

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

Guides implementation of data protection and privacy controls for regulatory frameworks such as GDPR, HIPAA, SOC 2, and PCI-DSS, including audits, retention policies, and data subject requests.

Analyzes algorithm time and space complexity, classifies problems by complexity classes, proves NP-completeness, and designs approximation algorithms.

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