Latest Agent Skills

Designs strategic HTML presentations with data visualization, layout patterns, and copywriting formulas for marketing and pitch decks.

Builds interactive HTML sketches with working states, transitions, and a shared CSS theme system for design exploration.

Unified design skill covering brand identity, design tokens, UI styling, logo and icon generation, corporate identity programs, presentations, banners, and social media images.

Runs a disciplined diagnosis loop for hard bugs and performance regressions, from reproduction through hypothesis testing, instrumentation, fixing, and regression testing.

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

Defines brand identity, voice, messaging, and visual standards, with scripts to inject brand context, validate assets, extract colors, and sync guidelines to design tokens.

Programmatically access Google NotebookLM via reverse-engineered RPC calls, managing notebooks, adding sources, querying, and generating or downloading artifacts like audio, video, quizzes, and slide decks.

Triage issues through a state machine driven by triage roles. Use when user wants to create an issue, triage issues, review incoming bugs or feature requests, prepare issues for an AFK agent, or manage issue workflow.

Converts code repositories and document directories into semantically-chunked text files optimized for NotebookLM ingestion, with support for config files and incremental processing.

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

Configure authentication and authorization for a MariaDB REST Service: create REST auth apps, link them to services, add REST users, and manage REST roles and privileges.

Prepare a MariaDB Schema Management (MSM) version release by snapshotting the development script, filling the generated update script with the actual migration, and then generating the deployment script.

Develop the next version of a MariaDB Schema Management (MSM) schema by editing the development script and splitting large sections into SOURCE-included files.

Deploys a MariaDB Schema Management (MSM) schema version onto a live server using msm.deploy_schema, creating a fresh schema or upgrading an existing one, with optional backup.

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.

Installs and configures MariaDB Connector/Python, covering the 1.1 and 2.0 lines, build prerequisites, and connection settings.

Installs and configures the MariaDB Connector/Node.js npm package, covering API entry points, TLS, and pooling.

Best practices for MariaDB system-versioned (temporal) tables, covering creation, querying historical data, managing history growth, and handling ALTER TABLE operations.

Adds the MariaDB Connector/R2DBC reactive driver to a Maven or Gradle build and configures connection factories, pooling, and TLS, including the R2DBC-specific URL scheme and parameter names.

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.

Explains MariaDB Connector/Python's DB API 2.0 behavior, including qmark placeholders, autocommit, prepared statements, buffered cursors, connection pooling, and error handling, for writing and reviewing Python code that uses the mariadb module.

Installs and configures MariaDB Connector/ODBC, covering driver manager registration, DSN setup, connection-string keywords, and TLS options for Linux, macOS, and Windows.

Explains MariaDB Connector/Node.js specifics: Promise vs Callback API, placeholders, BigInt handling, batch inserts, query streams, pooling, transactions, and prepared statements, for writing or reviewing Node.js code that uses the `mariadb` package.

Scaffolds a MariaDB Shell plugin folder with a correctly documented init.py or init.js, following the plugin registrar's conventions for decorators, docstrings, and loading paths.

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.

Explains MariaDB Connector/R2DBC specifics for writing reactive Java code: URL scheme, placeholder binding, lazy execution, consume-once results, transactions, pooling, and error handling.

Installs and configures MariaDB Connector/C++ across Linux, Windows, and source builds, covering prerequisites, linking, and runtime plugin setup.

Guides writing MariaDB-specific database create scripts with best practices for schema objects, session settings, and UUID usage.

Reference for MariaDB's built-in encryption, hashing, and compression functions, covering AES_ENCRYPT/DECRYPT, SHA2, KDF, COMPRESS, and related functions, with guidance on correct usage and common pitfalls.

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.

Creates a MariaDB REST Service by configuring the REST metadata schema, creating the service and REST schema, and exposing tables, views, and routines as REST endpoints via SQL DDL in mariadb-shell.

Reference for MariaDB's built-in date and time functions, covering current time, arithmetic, differences, extraction, parsing, formatting, Unix time, time-zone conversion, construction, and Oracle-compatible helpers, with guidance on version-specific behavior and common pitfalls.

Adds the MariaDB JDBC driver to a build, configures connection URLs and datasources, and sets up TLS with the correct sslMode and certificate options.

Covers MariaDB-specific behavior of the Connector/C++ sql:: API, including driver and connection setup, 1-based indexes, placeholder syntax, ResultSet iteration, raw pointer ownership, SQLString, autocommit, and exception handling.

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

Reference for MariaDB aggregate functions, covering counting, totals, extrema, string and bitwise aggregation, and statistical functions, with guidance on NULL handling and common pitfalls.

Provides best practices for optimizing MariaDB queries, including indexing strategies, EXPLAIN analysis, pagination, histogram statistics, and MariaDB-specific optimizer settings.

Manages a MariaDB database schema across its lifecycle using the MariaDB Schema Management plugin via the mariadb-shell MCP server, covering project creation, versioned development, releases, and deployment.

Browse and inspect MariaDB REST Service objects using read-only SHOW REST and SHOW CREATE REST statements to list services, schemas, views, procedures, functions, content sets, auth apps, roles, grants, and dump DDL for reverse-engineering or auditing.

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.

Reference for MariaDB numeric and math functions, covering rounding, division, powers, logs, trigonometry, randomness, base conversion, checksums, and formatting, with guidance on exact-vs-approximate types and division-by-zero behavior.

Explains MariaDB Connector/J JDBC driver behavior: auto-registration, URL schemes, prepared statement handling, batch inserts, transactions, fetch sizes, pooling, and failover. Use when writing or reviewing Java code that talks to MariaDB with the mariadb-java-client driver.

Explains MariaDB Connector/C's `mysql_`-prefixed API, connection setup, result handling, prepared statements, and transaction behavior for writing or reviewing C code that talks to MariaDB.

Reference for MariaDB window functions and the OVER clause, covering ranking, value navigation, and ordered-set functions with syntax and common pitfalls.

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.

Reference for MariaDB string functions: extraction, length, search, concatenation, modification, case, PCRE2 regex, formatting, and encoding, with common pitfalls and version notes.

Documents MariaDB-specific CREATE PROCEDURE syntax, including OR REPLACE/IF NOT EXISTS exclusivity, DEFINER and SQL SECURITY behavior, parameter modes, DEFAULT values, advisory characteristics, privilege requirements, and the client-side DELIMITER convention.

Explains MariaDB-specific SET TRANSACTION behavior, including scope rules, isolation levels, and innodb_snapshot_isolation conflict detection, to help write correct transaction statements and retry logic.

Generates and reviews MariaDB CREATE SEQUENCE statements with version-specific syntax, defaults, and gotchas.

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.

Provides MariaDB-specific syntax and behavior for CREATE, ALTER, and DROP DATABASE statements, including OR REPLACE vs IF NOT EXISTS, charset and collation defaults, and the absence of RENAME DATABASE.

Explains MariaDB-specific TRUNCATE TABLE semantics: DROP privilege, implicit commit, AUTO_INCREMENT reset, trigger and FK behavior, and restrictions on system-versioned tables and sequences.

Catalog of MariaDB JSON functions with signatures and semantics, covering constructors, extraction, modification, merging, validation, introspection, and formatting. Use when writing SQL that builds, queries, or alters JSON data in MariaDB.

Covers MariaDB-specific CREATE TRIGGER syntax and behavior, including OR REPLACE, DEFINER, multiple trigger events, FOLLOWS/PRECEDES ordering, OLD/NEW rules, and restrictions. Use when writing, generating, or reviewing CREATE TRIGGER statements for MariaDB.

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

Provides MariaDB-specific syntax, atomicity, privilege requirements, and restrictions for RENAME TABLE statements, including multi-table swaps, temporary tables, and cross-database moves.

Covers MariaDB-specific CREATE TABLE syntax and behavior, including atomic CREATE OR REPLACE, invisible and compressed columns, temporal PERIOD clauses, ignored indexes, encryption, page compression, and the utf8/utf8mb4 distinction.

Explains MariaDB-specific CREATE INDEX and DROP INDEX syntax, including mapping to ALTER TABLE, prefix lengths for TEXT/BLOB, lack of expression indexes, real descending indexes, IGNORED indexes, and index kinds. Use when writing or reviewing index statements for MariaDB.

Explains MariaDB explicit table locking (LOCK TABLES/UNLOCK TABLES) and named user-level locks (GET_LOCK family), covering alias traps, implicit commits, and multi-lock semantics for writing or reviewing locking code.

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.