Coding & Dev Tools

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.

Explains MariaDB-specific EXPLAIN and ANALYZE syntax, including FORMAT=JSON, SHOW EXPLAIN/ANALYZE FOR, and the standalone ANALYZE statement that executes queries.

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.

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 CREATE USER syntax and behavior, including authentication chaining, TLS options, resource limits, password expiry, and account locking, to help write accurate statements.

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.

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.

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

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 SET TRANSACTION behavior, including scope rules, isolation levels, and innodb_snapshot_isolation conflict detection, to help write correct transaction statements and retry logic.

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.

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.

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

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

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

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

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.

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

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

Verifies data structures, files, YAML blocks, or agent output against their defined schema, producing a pass/fail report with actionable fix instructions.

Builds accessible React UIs with shadcn/ui components, Tailwind CSS utility styling, and canvas-based visual design systems.

Analyzes codebases to understand existing features, tracing entry points, execution paths, architecture layers, patterns, and dependencies before new development.

Runs a multi-perspective review of a pull request, including code quality, tests, and potential silent failures, then reports findings ranked by severity.

Analyzes codebases to map entry points, execution flows, architecture layers, patterns, and dependencies before new development begins.

Generates design systems and UI/UX recommendations for React Native projects, with domain-specific searches for styles, colors, typography, and best practices.

Migrate test files from `as` type assertions to @total-typescript/shoehorn, using fromPartial and fromAny for partial or intentionally wrong test data.

Analyzes type design for encapsulation, invariant expression, usefulness, and enforcement, providing scores and improvement suggestions.

Create exercise directory structures with sections, problems, solutions, and explainers that pass linting, then commit with git.

Autonomously repairs failed task verification by choosing retry, decompose, prune, or escalate strategies before surfacing to the user.

Enforces a verification gate before any completion claim, requiring fresh command output as evidence.

Migrate TypeScript test code from `as` assertions to type-safe `shoehorn` helpers like `fromPartial` and `fromAny`.

Executes a written implementation plan in a separate session, reviewing it critically, running tasks with verification, and stopping to ask for help when blocked.

Provides domain-specific knowledge for working with Remotion, covering 3D, animations, assets, audio, captions, and more.

Generates multiple radically different interface designs for a module, compares them, and synthesizes the best approach.

Rolls back Open-workspace phase or plan commits using a phase manifest with dependency checks and a confirmation gate, preserving history via git revert.

Automates web browser interactions via the browse CLI, including navigation, form filling, screenshots, and scraping, with support for local and remote Browserbase sessions.